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
  • Oracle
  • MySql
  • PostgreSQL
  • Firebird/Interbase
  • SqLite
  • SalesForce
  • Brightpearl
  • Windows Event Log
  • Google Spreadsheets
  • Multiple Tables
  • POP3 + SSL
  • IMAP4 + SSL
  • File System
  • XML
  • QlikView QVX and QVD Files
  • HL7
  • BDE
  • HTML Forms
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
  • 200+ 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
  • SQL scripts execution before and after loading
  • Delimited or Fixed width Text file
  • MS Access Database
  • Microsoft Excel File
  • DBF File
  • Oracle database (using OCI API)
  • Full support for Oracle Instant Client
  • MS SQL server (using BCP API)
  • MS SQL Server CE
  • MySql
  • PostgreSQL
  • Firebird/Interbase
  • SqLite
  • Any ODBC compliant database (Using ODBC API)
  • OLE DB
  • SalesForce
  • SQL Insert Script
  • SMTP + SSL
  • Full support for ODBC connection strings
  • File System
  • XML
  • QlikView QVX and QVD Files
  • HL7
  • BDE

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.