Advanced ETL is a business intelligence utility that provides application for Extracting, Validating, Transforming and Loading info between different info sources and targets. Consequently, it is an all-in-one software that will be very beneficial in your work, no matter what it is related to.

Extraction:
- Various Delimited or Fixed width Content files
- Various Excel files + Various Excel Spreadsheets
- Various MS Access Databases
- Various DBF Files
- Any ODBC source
- Various 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 security Alteration 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 info from several fields
- Summarizing several rows of info (e.g., total sales for each store, and for each region)
- Generating surrogate key values
- Transposing or pivoting (turning several columns into several rows or vice versa)
- Splitting a column into several columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
- Customised Transformation

Loading:
- Various Info Targets
- Sql scripts execution before and after loading
- Delimited or Fixed width Content 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)

Popularity: 5% [?]

Tags: API, Delimited, Excel, info, loading, ODBC, source, string, Transformation, Validation