Advanced ETL Processor Professional

This is a piece of software that can automate many a routine tasks in IT department of your business.

Advanced ETL Processor Professional is designed to automate everyday routine tasks. Some stuff that may need to be carried out every day would, typically include, extract data from excel file, validate date formats, sort data, de-duplicate and load the data into a database, run stored procedure or SQL script and so on. The tool will even send an email to the administrator when all the chores are done! The tool is claimed to be codeless by the publishers, meaning that you do not need to write even a line of code to accomplish all the tasks it is capable of. Transfer of data from a database to another, automation of FTP, Email by POP3 and SMTP, File operations, SQL scripts, Zip and Unzip etc. are on offer. The ETL task scheduler is supported by detailed logging. You are sure of what went wrong when something actually goes wrong in the automated process. It writes a message line into rejected records file.

Works directly with Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite or any ODBC compliant database. Other useful features include complex data validation and transformations, copy, move, rename and delete files, report generation, receive and process emails, send mail, export of data from databases, generating insert statements, saving BLOBs into separate files, compare files with MD5 check sums and size and many such useful ones. The interface is simple and intuitive. Thus if you are entrusted with managing databases, this is a tool that can save a lot of aggravation in your life easily.

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.
Work with: Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView files.
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.