QArchive.ORG Main Page
Home | Blog | Terms of service | Sign in
All Vista Win Linux Mac
Related Products

Visual Importer ETL Professional
Download Now
File Size: 11.9 Mb

Visual Importer ETL Professional

Publisher:DB Software Laborato ry
Platform:Vista, Windows, Mobile
Requirements:40 meg disk space
Install:Install and Uninstall
Recommend Visual Importer ETL Professional Suggest to Friend

Publisher's Description:

Visual Importer ETL Professional - 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!!!

List of Changes:

Version from 2012-11-24

Show all changes

Version from 2012-11-03

+ Added option to ignore XML tags between Table tag and Record tag
+ Documentation Update

Version from 2012-09-01

+ Support for QlikView QVD files was introduced
- Various bug fixes

Version from 2012-08-11

+ New Version control tab was introduced
+ Version control can submit several objects now
+ Version control dialog can delete multiple objects now
- Various bug fixes

Version from 2012-07-01

+ Support for BrightPearl was introduced
+ Support for Sales Force was introduced
+ Support for JDBC was introduced
+ Support for IMAP4 was introduced
+ Documentation update
- Various bug fixes

Version from 2012-05-18

+ Uses 10 times less memory for large Excel files
+ Support for loading data from RSS, Google spread sheets and windows event logs was introduced
+ Dynamic Excel sheet names
+ Documentation update
- Various bug fixes

Version from 2012-04-08

+ 10x performance increase for generating QVX files
- Addressed some SMTP problems
- Various bug fixes

Version from 2012-03-23

+ Support for Dynamic SQL for ETL transformations was introduced
- Addressed some SMTP problems

Version from 2012-03-07

- Addressed some issues related to working with integrated scheduler

Version from 2012-02-20

- Addressed some issues related to working with MS Sql Server Compact edition

Version from 2011-12-30


+ 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

Version from 2011-10-22

+ Package debugger was introduced
+ Breakpoints were introduced
+ Execute single package object option was introduced
+ More generic log viewer
+ Execution agent writes startup error messages in the log file
- Disappearing tree nodes problem was addressed
- Minor interface tweaks
- AV fixes

Version from 2011-10-10

+ Interface Improvements
+ Standard print preview
+ Support for scrolling in Package editor
- Better error handling for ADO and MS Sql scripts

Version from 2011-05-10

Get latest version menu item was added
Support for UTF-16 was introduced fro XML data reader
Various bug fixes

Version from 2011-04-13

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

Version from 2011-03-28

Fixed number of problems related to working with uniqueidentifierfileds in sql server
Added post changes button
Added Optimize Column Width button for all grids
Some corrections for German Locale were introduced

Version from 2011-02-28

Addressed number of problems related to working with uniqueidentifier fields in SQL Server
Fixed bug loading zero length files
Various bugs fixes

Version from 2011-02-05

Support for MS SQL Server Compact Edition was introduced
Calculations Enhancements
Various bugs fixes

Version from 2011-01-12

Fixed Issues with SQLite imports
Support for zip files > 4 gigs was introduced

Version from 2010-12-15

Support for SFTP was introduced
Various problems related to working with very large files were resolved

Version from 2010-11-26

Major update

Powerful data transformation language:

Source fields are aways strings
Single quotes instead of double quotes
In order to make conversion easier we have added new menu item
"Correct calculations"
Lots of new functions, procedures, bug fixes
Documentation update

Version from 2010-11-11

Works correctly with mixed case objects in PostgreSQL
Various bug fixes

Version from 2010-10-23

Loads Data from XML files
Works correctly with multiple PosgreSQL schemes
Support for PosgreSQL 9 was introduced
Support for German Locale was introduced
Select all and copy from data grids

Version from 2010-06-27

HTTP Downloads and ETL Package scripts were introduced
System Variables
Documentation Update
Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max)

Version from 2010-05-21

Fixed Loading data into DBF files


An ETL tool loads data into any database

Download Now
File Size: 11.9 Mb

Share |

Text link code :
Hyper link code:
UBB/BLOG code:

Download Now
File Size: 11.9 Mb