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 Spread sheets
  • 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 list of values
  • Regular Expressions: Post codes, 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 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 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.

Visit Support Forum Learn More Download Buy It
Advanced ETL Processor Standard

Recommended product for desktop users who require advanced data transformation

From only 340$ per license

Read More

Advanced ETL Processor Professional

Recommended product for development environment

From only 480$ per license

Read More

Advanced ETL Processor Enterprise

Recommended product for complex enterprise environment

From only 690$ per license

Read More

We have 140 guests and no members online