Visual Importer ETL Professional v.8.0.3.1

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!!!

An ETL tool loads data into any database. Visual Importer Professional loads 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. Works directly with most Databases

etl, oracle, ms sql server, bcp, sql loader, odbc, datawarehouse, business automation

 
  • Visual Importer ETL Professional
  • 8.0.3.1
  • 08 Apr 12
  • DB Software Laboratory
  • WinXP, Windows2000, Windows2003, Windows Vista, Win98, WinME, WinNT 4.x, Windows Tablet PC Edition 2005, Windows Media Center Edition 2005
  •  
  • Shareware
  • 11.94 Mb
  • 119
  • $220.00
Visual Importer ETL Professional - An ETL tool loads data into any database
View screenshot
 
 
Latest Versions History
Version Date Released Release Notes
8.0.3.1 08.04.2012 + 10x performance increase for generating QVX files - Addressed some SMTP problems - Various bug fixes
8.0.1.5 07.03.2012 - Addressed some issues related to working with integrated scheduler
8.0.1.2 30.12.2011 + Support for QlikView QVX files was introduced + Timeout was added to SQL scripts - Various bug fixes
8.0.0.2 30.12.2011 MAJOR RELEASE + New repository structure compatible with Database browser, + Advanced ETL Processor and Active Table Editor + Multiple SMTP, POP3, and FTP connections + Design and Generate Reports + Projects + Easy agent management + Package Debugging + Highly optimized code
7.7.8.0 10.10.2011 + Interface Improvements + Standard print preview + Support for scrolling in Package editor - Better error handling for ADO and MS Sql scripts
7.7.7.18 01.09.2011 GUI changes Improved support for email processing Various bug fixes
7.7.7.12 20.06.2011 Addressed some issues related to loading data from XML Files
7.7.7.8 13.04.2011 Script language extension: DeleteCharacters(S,CharactersToDelete) Deletes specific characters from the string Delete(S,Start,End) Deletes part of string S EnsureNoPrefix(S,Prefix) Removes prefix from the string when present EnsureNoSuffix(S,Suffix) Removes Suffix to the string when present
 
 

Review Visual Importer ETL Professional

  • captcha
 

Other software of DB Software Laboratory
  • Active Business Intelligence Portal  v.3.2.0Active BI Portal is business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and intranet. Active BI Portal works with all major commercial and open source databases.
  • Active Table Editor  v.5.0.2.0Design Data Entry Screens and Edit ANY table in ANY Database with ease. Control what users can edit and see. Design menus, Input forms, define security roles. Easy to use and highly customizable
  • Advanced ETL Processor  v.3.4.1.0Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the "Preview" button and see what the results of an ETL flow would look like.

New Database Management software
  • DB2ToAccess  v.1.6DB2ToAccess - Export DB2 data to Access easy and quickly. Main features: 1. Easy visual configuration. 2.Exports from both table and query. 3. Displays progress through time estimation. 4 Wizard, Step by step.
  • Advanced ETL Processor Enterprise  v.5.3.0.3Build Complex Data warehouses and Automate Entire Business Processes, Transfer data from ANY Database into ANY Database or file,Use FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, Task scheduler and comprehensive logging.