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, de-duplicate it and load it into the 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 compliant database
- OLE DB Datasource
- Oracle
- MS Sql Server
- MySql
- PostgreSQL
- Firebird/Interbase
- POP3 Server
- File System
- 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/Foxpro File
- Oracle database
- MS SQL server
- MySql
- PostgreSQL
- Firebird/Interbase
- Any ODBC compliant database
- OLE DB
- SMTP Server
- XML Files
- Insert Scripts
- File System
Data transformation:
- 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 different tables
- Add, replace, delete strings
- Run custom transformations
- De-duplicate 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
- Generate Sql Insert Script Using any Table or File
- Database to Email Transformation
- Email to Database transformation
- Load files into the database
- Export data from blobs into separate files
- Generate XML files
- Extract data from XML Messages
In the event of an error, Advanced ETL Processor generates a detailed and explanatory report, giving the user ultimate control of accuracy of the database.
Questions?
