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.

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)

Limitations:

· 30 days trial period
· Nag screen

What's New in This Release: [ read full changelog ]

· Various bug fixes and performance improvements