Extraction
  • Multiple Delimited or Fixed width Text files
  • Multiple Excel files + Multiple Excel Spreadsheets
  • Multiple MS Access Databases 3.0-2007
  • Multiple DBF/Foxpro Files
  • Any ODBC compliant database
  • Full support for ODBC connection strings
  • MS SQL Server
  • MySQL
  • PostgreSQL
  • Interbase/Firebird
  • Oracle
  • Multiple Tables
  • SQL Select Statements as a Datasource
  • File system
  • OLE DB
  • POP3 + SSL
  • XML
Validation
  • 190 Validation Functions
  • String Validation
  • Number Validation
  • Date Validation
  • Time Validation
  • Validation Against a list of values
  • Regular Expressions: Postcodes, Phone Numbers, VAT Numbers ETC
Transformation
  • 51 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 newly 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 database (using OCI API)
  • Full support for Oracle Instant Client
  • MS SQL Server (using BCP API)
  • MySQL+ SSL
  • PostgreSQL+ SSL
  • Interbase/Firebird
  • Any ODBC compliant database (Using ODBC API)
  • Full support for ODBC connection strings
  • OLE DB
  • SMTP + SSL
  • XML
  • File System
  • 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 BCP/DTS/SSIS service.