More about Advanced ETL Processor Standard

Watch Online Tutorials Data Transformation Data Validation

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 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
  • Slemma
  • 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
  • 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 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.

Advanced ETL Processor runs on Microsoft Windows XP/2003/2008/2012/Vista/Win7/Win8/Win10

Licence UnInstall Download 32 Bit Download 64 Bit

Advanced ETL Processor Standard

Recommended product for desktop users who require advanced data transformation

From only 340$ per license

Read More

 


Advanced ETL Processor Professional

Recommended product for development environment

From only 480$ per license

Read More

 


Advanced ETL Processor Enterprise

Recommended product for complex enterprise environment

From only 690$ per license

Read More

 

Go to top