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
• OLE DB Datasource
• MS Sql Server
• Oracle
• MySql
• PostgreSQL
• Firebird/Interbase
  
• 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

• 48  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)
• MySql
  
• PostgreSQL
• Firebird/Interbase
  
• Any ODBC compliant database (Using ODBC API)
• OLE DB
• Sql Insert Script
• 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