Build Complex Data warehouses and Automate Entire Business Processes

Transfer Data from ANY Database into ANY Database or file. Complete automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Works directly with Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or any ODBC compliant database.

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.

The Enterprise version includes execution agent, which can be run as a Windows service.

Keywords: ETL, Powerful ETL tool, Oracle, MS Sql server, BCP, SQL Loader, ODBC, ETL, Data Transformation, Complete business automation,

Recent Changes: It is now possible to pass variables between Packages and Transformations
Keep value transformation function
Shows PK information for access target and Ole DB target
Renaming transformations changes tab caption as well
No more duplication in transformation and Validator grids

Install Support: Install and Uninstall

Supported Languages: English

Additional Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003

PAD file URL: http://www.etl-tools.com/pad/aetlent.xml