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
• MySQL
• PostgreSQL
• Interbase/Firebird
• 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 

• 
  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
• Delimited or Fixed width Text files
• MS Access Databases
• Microsoft Excel Files
• DBF Files
• Oracle 7-11g database (using OCI API)
• Full support for Oracle Instant Client
• SQL server 7-2008 (using BCP API)
• MySQL
• PostgreSQL
• Interbase/Firebird
• Any ODBC compliant database (Using ODBC API)
• Ole DB
  
• Full support for ODBC connection strings
• Generate Sql Insert Script
  

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 - hundreds of records per second
• Comprehensive Error log
• Rejected records file
• Low OS Memory requirements

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