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 extracting data from Excel File, Validate Date Formats, Sort data, de-duplicate it and loading it into the database, running stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, BCP or SSIS Advanced ETL Processor can also add new and update old records based on the primary key.

mt_ignore:Excel to Google mail Data Transformation

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
  • Any JDBC compliant database
  • OLE DB Datasource
  • Oracle
  • MS SQL Server
  • MS SQL Server CE
  • MySql
  • PostgreSQL
  • Firebird/Interbase
  • SQLite
  • POP3 Server
  • IMAP4 Server
  • SalesForce
  • Slemma
  • Brightpearl
  • Windows event log
  • File System
  • XML files
  • QVX Files
  • QVD Files
  • HL7
  • BDE
  • HTML Forms
  • 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
  • SQLite
  • Any ODBC compliant database
  • OLE DB
  • SMTP Server
  • XML Files
  • QVX Files
  • QVD Files
  • SalesForce
  • Slemma
  • HL7
  • BDE
  • Insert Scripts
  • File System

Data transformation:

  • Add Records
  • Update Records
  • Delete Records
  • Add New and Update existing Records
  • Deal With Dirty Data
  • Validate Postcodes, 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 newly 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
  • Address and Report Data Quality Issues
  • 500+ validations and transformation functions

In the event of an error, Advanced ETL Processor generates a detailed and explanatory report, giving the user ultimate control of the accuracy of the database.