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.