Advanced ETL Processor is a Codeless ETL tool

It can load, validate, transform, group, sort and deduplicate data without writing a single line of code. It works with ANY database or file format, including unicode

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).

Backed up by Free, Fast, Unparalleled Support

What can Advanced ETL Processor Do?

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
• Oracle
• 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

Online Flash Demos and Tutorials

• Loading data from multiple files into MS Sql Server
• Converting text files using Advanced ETL Processor

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
• Oracle
  
• 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:

• 38  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

Loading: 

• 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 (using OCI API)
• Full support for Oracle Instant Client
• SQL server 7-2008 (using BCP API)
• Any ODBC compliant database (Using ODBC API)
• Full support for ODBC connection strings
  

Oracle
 
There are two ways of loading available:

• Oracle direct path loading
• Conventional path

More Information...

SQL server

This software uses the same API as Microsoft DTS service. 

Also: 

• High performance - thousands of records per second
• Comprehensive Error log
• Rejected records file
• Low OS Memory consumption

Advanced ETL Processor runs on Microsoft Windows 98/ME/NT 4.0/2000/XP/2003/Vista

 Advanced ETL Processor Screenshots