Advanced ETL Processor Enterprise 3.3.2.3

Advanced ETL Processor Enterprise 3.3.2.3 is designed as a useful codeless ETL tool which can help you easily load, validate, transform, group, sort and deduplicate data without writing a single line of code. It works with ANY database or file format, including unicode.

Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis. By combining simple Package actions together Advanced ETL Processor Enterprise helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks. Advanced ETL Processor Enterprise supports complex enterprise environments including database, file, smtp, pop3 and ftp servers. Since Advanced ETL Processor Enterprise is a codeless most of the tasks performed without writing a single line of code.

Advanced ETL Processor Enterprise is designed to automate everyday routine tasks. Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into the database, run stored procedure or Sql script. Once loading is completed send email to the administrator. Every package execution is logged,If something went wrong Advanced ETL Processor Enterprise writes detailed message into the log and writes a record into rejected records file.

Major Features:

1. • Extract 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
   • Oracle
   • MS Sql Server
   • MySql
   • PostgreSQL
   • Firebird/Interbase
   • Multiple Tables
2. And Load 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
   • MS SQL server
   • MySql
   • PostgreSQL
   • Firebird/Interbase
   • Any ODBC compliant database
3. Save time by automating Everyday tasks:
   • Move data from one system to another
   • Import sales into marketing system
   • Validate and correct key data
   • Remove duplicated data
   • Avoid re-keying data
   • Add Records
   • Update Records
   • Delete Records
   • Add New and Update existing Records
   • 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
   • Split, merge Fields
   • Split data and load it into diffrent tables
   • Add, replace, delete strings
   • Run custom transformations
   • Deduplicate Data
   • Sort Data
   • Group Data
   • Summarize Data
   • Pivot and UnPivot Data
   • Create surrogate keys
   • Translate coded values
   • Derive a new calculated value
   • Run Sql script before and after loading data
   • Filter Source Data
   • Use Select Statement as a Data Source
   • Run transformation script from the command line