NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Advanced ETL Processor - What is it for

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.

Excel to  Googlemail 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
  • BrightPearl
  • WindowsEvent 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
  • 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 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
  • 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 accuracy of the database.

Visit Support Forum Learn More Download Buy It
We Process 3000 files daily, 24h x 365d

C Gandhi
Nesa-Canada

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with