Visual Importer ETL Professional

One of the main advantages of the information technology has been the automation of our organizational procedures which used to be mechanical and painfully time consuming, involving lots of human errors. You may receive some external reports via an e-mail requiring a change in your current activities and you want to take automatic corrective actions immediately. If you go by the conventional means, you may have to hire extra man-power for such activities. But if you have some program which can automate this process according to some fixed criteria, then you can expect it to be much easier. Visual Importer ETL Professional v.7.7.7.11 is a simple solution for such requirements.

Visual Importer ETL Professional by DB Software Laboratory is a shareware program primarily for converting the database file of one format to another format. The interface of the program is a bit complex requiring an experienced and a professional user. It has a menu bar on the top showing distinct menus like file, view, tools, help etc. It has a contents tree on the left hand side window pane showing various objects and shows the contents in a display window. It works as a complete application for automation of various processes in a typical organization. It supports inter-conversion among various database formats like Text files, DBF, XML, EXCEL, ORACLE, SQL etc. Apart from this it has full support for FTP, e-mails via SMTP and POP3 protocols, running and executing SQL scripts for the events algorithms and a provision for maintaining complete logs of activities. It also supports customization and editing of files in the process before taking any further actions on the basis of it.

Overall, Visual Importer ETL Professional v.7.7.7.11 is a program which offers complete functionality and feature rich and accurate automation of many small and medium level processes which may otherwise be hardly possible to accomplish so easily and accurately. Hence, it receives a score of four and half rating points on the scale of five.

Visual Importer Professional automates loading data into ANY Database from ANY Database or file. Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Full support for Excel, MS Access, DBF, XML and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite or any ODBC compliant database.
Here is simple usage example: Download files from an FTP server, load them into the database, run stored procedure or SQL script and send email to the admin, once the package is completed.
One of the major benefits of using Visual Importer Professional that it can also add new and update old records based on user defined primary key.
Let's say, for example, you work at university and must publish results of exams from different departments. Visual Importer Professional can help you automate data processing without the need for more staff. It will enable you to process data sent via email and FTP without user intervention. Simply create a dedicated email account, design a package and that's it - start processing data!
Another unique benefit of using Visual Importer Professional its ability to load data from multiple files or tables using mask.
If there is a problem it is very easy to resolve: Every package execution is logged. In case of loading errors, Visual Importer Professional writes a detailed message into the log and writes a record into the rejected records file.
On top of that there are several wizards to make your life easier so you can automate your routine tasks today and spend more time sitting in the bar watching football and drinking beer!!!