Advanced ETL Processor Enterprise 4.1

Major Features:

1. Data Sources
   • Multiple Delimited or Fied width Tet files  
   • Multiple Ecel files + Multiple Ecel Spreadsheets
   • Multiple MS Access Databases + Multiple Tables  
   • Multiple DBF Files  
   • Any ODBC Compliant Database  
   • OLE DB 
   • MS SQL Server
   • Oracle 
   • MySql 
   • PostgreSQL 
   • Interbase/Firebird
   • Multiple Source Files  
   • Multiple Source Tables  
   • SQL Select Statement as a Data source  
   • POP3 Email server 
   • File System
2. Data Targets
   • Oracle database  
   • MS Sql Server  
   • MySql
   • PostgreSQL
   • Interbase/Firebird
   • Any ODBC Compliant Database
   • OLE DB 
   • Delimited or Fied width Tet file 
   • MS Access Database
   • Microsoft Ecel File 
   • DBF File 
   • Multiple Data Targets 
   • SQL Insert Script
   • SMTP Server
   • File System
3. Loading method
   • Adding Records  
   • Updating Records  
   • Deleting Records  
   • Adding new and Updating old Records  
   • Adding new Records only
   • User definable date formats
   • Transformation Functions  
   • Eecution of Sql script Before the loading
   • Eecution of Sql script After the loading  
4. Transformations
   • 49 transformation functions
   • String Transformation
   • Number Transformation 
   • Date Transformation 
   • Multiple Date Formats 
   • 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
   • Generating surrogate key values 
   • 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
5. Validation
   • 190 Validation Functions
   • String Validation
   • Number Validation
   • Date Validation
   • Time Validation
   • Validation Against list of values 
   • Regular Epressions: Post codes, Phone Numbers, VAT Numbers ETC
6. Additional Transformations
   • Sorting 
   • Grouping
   • Deduplication
   • Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
   • Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
7. Other usefull features
   • Full Support for Unicode 
   • Rejected Records File  
   • Transformation Log  
   • Command Line interface
   • Data Preview  
8. Repository
   • MS Access  
   • MS Sql Server  
   • Oracle  
   • MySql  
   • Interbase  
   • PostgreSQL  
9. Advanced Objects
   • Projects
   • Directories  
   • ODBC Connections  
   • SQL Server Connections
   • Oracle Connections
   • MySQL Connenctions
   • PostgreSQL Connections
   • Interbase/Firebird Connections
   • OLE DB Connenctions
   • SMTP Connections
   • POP3 Connections
   • FTP Connections
   • Data Transformations
   • Email Templates
   • Sql Scripts  
   • Reports Designer
   • Scheduler  
   • Eecution Logging  
   • Packages  
   • Backup Repository
   • Restore Repository
10. Package Objects
    • Data Transformations  
    • Eports  
    • Sql Scripts  
    • Check Files  
    • Compare Files (creation date, file size or MD5)  
    • File Operations (copy,delete,rename,etc)  
    • Eternal applications  
    • Email Notifications  
    • Ftp operations Uploads, Downloads, Create Remote directory, Delete File  
    • Zip (zip and unzip with password)  
    • Pop 3 Email receiver  
    • SQL Data Check  
    • FTP Operations with full SSL support
    • Backup Repository 
    • Pause
    • Check Date
    • Reports
    • Check disk space
    • Show Message
    • Ask Question
11. Eecution Agent  
    • Runs as Windows service

Enhancements:

• Database to Email and Email to Database transformations
•  Transform files into blob fields and Export of blob fields
•  Detailed SMTP Log
•  Detailed POP3 Log
•  Detailed FTP Log
•  Secure Email
•  It is no longer required to use "SET sql_mode='ANSI'" for MySql Connection
•  Ole db connections works with blobs now
•  Ms Sql Server connection support: TEXT, NTEXT, VARBINARY(MAX), VARCHAR(MAX),XML, NVARCHAR(MAX), IMAGE
•  ODBC Performance Improvements.
•  ODBC Support for BLOBS was improved and tested with various databases
•  Oracle connection support for BLOB,CLOB and NCLOB, LONG RAW data types.
•  PostgresSQL connection works with bytea
•  Interbase/Firebird support for blobs
•  MySQL support for blobs
•  Several MS Access bug fixes
•  Redesign of reader and writer properties dialog boxes.
•  Total number of Data transformation functions is now 49
•  Documentation Update