Advanced ETL Processor 2.4.0.7

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.

Major Features:

1. Extract data from:
   • Multiple Delimited or Fixed width Text files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases
   • Multiple DBF Files
   • Any ODBC compliant database
   • MS Sql Server
   • Oracl
   • Multiple Tables
2. And Load it into:
   • Multiple Data Targets
   • Sql scripts execution before and after loading
   • Delimited or Fixed width Text file
   • MS Access Database
   • Microsoft Excel File
   • DBF File
   • Oracle 7-11g database
   • SQL server 7- 2005
   • Any ODBC compliant database
3. Save time by automating Everyday tasks:
   • Move data from one system to another
   • Import sales into marketing system
   • Validate and correct key data
   • Remove duplicated data
   • Avoid re-keying data
   • Add Records
   • Update Records
   • Delete Records
   • Add New and Update existing Records
   • Deal With Dirty Data
   • Validate Post codes, Phone numbers,TAX Codes using regular expressions
   • Validate Date Formats
   • Validate Date and Time
   • Validate Numbers
   • Validate Strings
   • Split, merge Fields
   • Split data and load it into diffrent tables
   • Add, replace, delete strings
   • Run custom transformations
   • Deduplicate Data
   • Sort Data
   • Group Data
   • Summarize Data
   • Pivot and UnPivot Data
   • Create surrogate keys
   • Translate coded values
   • Derive a new calculated value
   • Run Sql script before and after loading data
   • Filter Source Data
   • Use Select Statement as a Data Source
   • Run transformation script from the comm