Advanced ETL Processor 2.4.0.4

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 command line

Enhancements:

• Works up to 30 percent faster comparing to the previous release
• Full support for unicode 
• Support for sql functions and oracle sequences 
• It is now possible to pull data directly from Oracle database without ODBC. 
• Various bug fixes

Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003