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
  • Any JDBC compliant database
  • Full support for ODBC connection strings
  • OLE DB Datasource
  • MS SQL Server
  • MS SQL Server CE
  • MySQL
  • PostgreSQL
  • Interbase/Firebird
  • Oracle
  • SqLite
  • Multiple Tables
  • POP3 + SSL
  • IMAP4 + SSL
  • File System
  • Windows Event Log
  • XML
  • SalesForce
  • BrightPearl
  • QlikView QVX and QVD files
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
  • 15 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)
  • Customized 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
  • SqLite
  • Any ODBC compliant database (Using ODBC API)
  • Ole DB
  • Full support for ODBC connection strings
  • Generate SQL Insert Script
  • SMTP + SSL
  • XML
  • QlikView QVX and QVD files
  • File System

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