Advanced ETL Processor Professional 3.3.0.15

1. Extracting data from:
   • Multiple Delimited or Fixed width Text files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases
   • Multiple DBF Files
   • Any ODBC compliant database
   • MS Sql Server
   • Oracle
   • Multiple Tables
2. And Loading it into:
   • 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 7-11g database
   • SQL server 7-2008
   • Any ODBC compliant database
3. Validation:
   • Deal With Dirty Data
   • Validate Post codes, Phone numbers,TAX Codes using regular expressions
   • Validate Date Formats
   • Validate Date and Time
   • Validate Numbers
   • Validate Strings
4. Transformation:  
   • Split, merge Fields
   • Split data and load it into diffrent tables
   • Add, replace, delete strings
   • Run custom transformations
   • Translate coded values
   • Derive a new calculated value
5. Automation:
   • Load Data into ANY database
   • Export Data from ANY database
   • FTP Downloads and Uploads
   • Create or Delete directories on FTP server
   • Rename or delete files on FTP server
   • Send Emails with attachments
   • Receive Emails with attachments
   • Save attachmets
   • Compress files
   • Decomress zip files
   • Copy, move, rename, merge, delete files
   • Compare files using MD5, size or creation  date
   • Check if file exist
   • Generate Reports
   • Execute Different part of package depending of the day of the week
   • Schedule packages for execution
   • Run bat files or execute any windows application
   • Edit and run SQL Scripts
   • Execute Packages from the command line
   • Add Records
   • Update Records
   • Delete Records
   • Add New and Update existing Records
   • Deduplicate Data
   • Sort Data
   • Group Data
   • Summarize Data
   • Pivot and UnPivot Data
   • Create surrogate keys
   • Run Sql script before and after loading data
   • Filter Source Data
   • Use Select Statement as a Data Source
   • Transform Unicode Data

Enhancements:

• ODBC Connection String Builder was introduced
• Support for FTP Directory Listing Improved support for NonStop ODBC/MX 2.0 ver 3.51.20.126
• ODBC Driver Various Cosmetic Changes and Bug Fixes
• Additional Option to select
• OLE DB Provider for Oracle was introduced

Requirements:

• Win98
• WinME
• WinXP
• WinNT 4.x
• Windows2000
• Windows2003