Advanced ETL Processor 2.4.0.13 Download

fyxm network: our download portal - Softliste.de
Advanced ETL Processor
        Bookmark and Share
  • Name:Advanced ETL Processor
  • License:Trial
  • Developer:DB Software Laboratory
  • Downloads:86
  • Rating:3 / 5
  • OS:Windows All
  • Size:7.5 MB
  • D.M.C.A. 
  • Download > 

Advanced ETL Processor 2.4.0.13

Advanced ETL Processor 2.4.0.13 Description:

Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data sources and targets. Therefore, it is an all-in-one software that will be very useful in your work, no matter what it is related to.

A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be transformed and loaded into the data warehouse or database without actually loading it.

At any time, you can press the ‘Preview’ button and see what the results of an ETL flow would look like. Advanced ETL Processor can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into the database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Advanced ETL Processor can also add new and update old records based on the key defined by user.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables. It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database. If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Extraction:
· Multiple Delimited or Fixed width Text files
· Multiple Excel files Multiple Excel Spreadsheets
· Multiple MS Access Databases
· Multiple DBF Files
· Any ODBC source
· Multiple Tables

Validation:
· 190 Validation Functions
· String Validation
· Number Validation
· Date Validation
· Time Validation
· Validation Against list of values
· Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC

Transformation:
· 36 Transformation Functions
· String Transformation
· Number Transformation
· Date Transformation
· Sorting
· Grouping
· Deduplication
· Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
· Deriving a new calculated value (e.g., sale amount = qty * unit price)
· Joining together data from multiple fields
· Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
· Generating surrogate key values
· Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
· Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
· Customised Transformation

Loading:
· Multiple Data Targets
· Sql scripts execution before and after loading
· Delimited or Fixed width Text file
· MS Access Database
· Microsoft Excel File
· DBF File
· ODBC source (Using ODBC API)
· Oracle 7-10G database (using OCI API)
· SQL server 7- 2005 (using BCP API)
· ODBC source (Using ODBC API)

Advanced ETL Processor 2.4.0.13 Limitations:

· 30 days trial period
· Nag screen

Related:

advanced data export

Related searches:

advanced attachments processor - advanced etl processor - advanced mailbox processor

Advanced ETL Processor security information

You cannot download any crack or serial number for Advanced ETL Processor on this page. Every software that you are able to download on our site is legal. There is no crack, serial number, hack or activation key for Advanced ETL Processor present here. Our collection also doesn't contain any keygens, because keygen programs are being used in illegal ways which we do not support. All software that you can find here is freely downloadable and legal.

Advanced ETL Processor installation package is prepared to be downloaded from our fast download servers. It is checked for possible viruses and is proven to be 100% clean and safe. Various leading antiviruses have been used to test Advanced ETL Processor, if it contains any viruses. No infections have been found and downloading Advanced ETL Processor is completelly problem free because of that reason. Our experts on malware detection tested Advanced ETL Processor with various spyware and malware detection programs, including fyxm.net custom malware and spyware detection, and absolutelly no malware or spyware was found in Advanced ETL Processor.

All software that you can find on our servers, including Advanced ETL Processor, is either freeware, shareware or open-source, some of the software packages are demo, trial or patch versions and if possible (public domain licence), we also host official full versions of software.

Because we want to be one of the fastest download sites on the web, we host all the software including Advanced ETL Processor on our servers. You cannot find here any torrents or download links that would lead you to dangerous sites.

Fyxm.net does support free software, however we do not support warez or illegal downloads. Warez is harming producers of the software.

Enjoy!

Rate Advanced ETL Processor 2.4.0.13!

Rating: 2.5/5 (13 votes cast)

Similar Programs License Size Rating  
PHP Processor Trial 7.5 MB 2 / 5
Virdi Advanced Mail Processor (VAMP) Shareware 850 KB 2 / 5
WAB-Processor Shareware 310 KB 1 / 5
Advanced Mailbox Processor Trial 1.4 MB 2 / 5
Advanced Form Creator and Processor Shareware 61 KB 2 / 5

Featured Products

LimeWire 5.2.1 Beta / 5.1.3

LimeWire

Share computer files with anyone on the internet!

Kaspersky Anti-Virus Personal 2010

Kaspersky Anti-Virus Personal

BKaspersky AV provides all types of anti-virus protection

Winamp 5 Full

Winamp

A flexible and sophisticated application for playing and managing your music

DAEMON Tools Lite 4.30.4

Daemon Tools

Advanced application for multiprotection emulation

CMS Templates Download

Blogger Themes

Check our website devoted to CMS themes download
FYXM.net - We have everything! If not - please do contact us here.