Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data sources and targets.
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 Free Download Information
File Cart periodically updates pricing and software information of Advanced ETL Processor 2.1.1 Free Download from the publisher, so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft, Using Advanced ETL Processor 2.1.1 Free Download crack, password, serial numbers, registration codes, key generators is illegal and will prevent future development of Advanced ETL Processor 2.1.1 Free Download Edition.