Advanced ETL Processor 2.2.2
Advanced ETL Processor is designed to automate extracting data from ANY database, transform, validate it and load into ANY database . Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into Oracle 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 primary key. Some examples of what our customers use this ETL tool for include:
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 source
* MS Sql Server
* Multiple Tables
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
* ODBC Source
* Oracle 7-11G database
* SQL server 7- 2005
* ODBC source
Other tasks are
* Add Records
* Update Records
* Delete Records
* Add New and Update existing Records
* Validate Post codes, Phone numbers,TAX Codes using regular expressions
* Check Date Formats
* Check Numbers
* Split, merge Fields
* Split data and load it into diffrent tables
* Add, replace, delete strings
* 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
If something went wrong Advanced ETL Processor writes detailed message into error log and writes a record into rejected records file.
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 source
* MS Sql Server
* Multiple Tables
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
* ODBC Source
* Oracle 7-11G database
* SQL server 7- 2005
* ODBC source
Other tasks are
* Add Records
* Update Records
* Delete Records
* Add New and Update existing Records
* Validate Post codes, Phone numbers,TAX Codes using regular expressions
* Check Date Formats
* Check Numbers
* Split, merge Fields
* Split data and load it into diffrent tables
* Add, replace, delete strings
* 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
If something went wrong Advanced ETL Processor writes detailed message into error log and writes a record into rejected records file.
No comments:
Post a Comment