Advanced ETL Processor

Dowload Free Trial

Buy now only 340$

Advanced ETL Processor is an ETL tool that uses unique technology called "What You See Is What You Load".

It can show you, at any time you choose, how the data will be transformed and loaded into the data warehouse or database, without actually loading it.
At any time, you can press the ‘Preview’ button, and Advanced Processor ETL shows immediately what the results of an ETL flow would be.

Download a Free Trial or get the latest version today from only $340.
Read Advanced ETL Processor FAQ , Watch Online Flash Demo , Read Product Documentation (PDF).

Transformation Example

Example below converts first letter of [COMPANY NAME] field to upper case and joins [YEAR] and [MONTHID] fields together

This is how data will look like once it is transformed

Validation Example

This example checks if field [YEAR] is equal to 2002.

Field [YEAR] is equal to 2002

What else can Advanced ETL Processor Do?

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 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
MS Sql Server
Oracl
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
Oracle 7-11g database
SQL server 7- 2005
Any ODBC compliant database

Save time by automating Everyday tasks:

Move data from one system to another
Import sales into marketing system
Validate and correct key data
Remove duplicated data
Avoid re-keying data

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 diffrent tables
Add, replace, delete strings
Run custom transformations
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

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

Key Facts

Extraction:

Multiple Delimited or Fixed width Text files
Multiple Excel files + Multiple Excel Spreadsheets
Multiple MS Access Databases
Multiple DBF Files
Any ODBC compliant database
MS Sql Server
Multiple Tables
Full support for ODBC connection strings

Validation:

190 Validation Functions
String Validation
Number Validation
Date Validation
Time Validation
Validation Against list of values
Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC

Transformation:

36 Transformation Functions
String Transformation
Number Transformation
Date Transformation
Multiple Date Formats
Sorting
Grouping
Deduplication
Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
Deriving a new calculated value (e.g., sale amount = qty * unit price)
Joining together data from multiple fields
Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
Generating surrogate key values
Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
Customised Transformation