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.