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.