Advanced ETL Processor Professional is a Codeless Automation Tool. It transfers 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, XML and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite, MS SQL Server Compact or any ODBC compliant database.
Since Advanced ETL Processor Pro is a codeless most of the tasks performed without writing a single line of code
Advanced ETL Processor Pro is designed to automate complex business processes. 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 transformation is completed send email to the administrator.
Every package execution is logged, If something went wrong Advanced ETL Processor Pro writes detailed message into the log and adds a line into rejected records file.
Keywords: ETL, Powerful ETL tool, Oracle, MS Sql server, BCP, sql loader, ODBC, ETL, Data Transformation, Business Automation, Oracle, SQLite,
Recent Changes: Added Support for XSLT transformations
Added Get Variable, XML XSLT transformation, Validate XML function
Various bug fixes
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/aetlpro.xml