Visual Importer ETL Enterprise 8.3.4.8

Advertisements

Visual Importer ETL Enterprise is a platform for building high performance data integration solutions, Including extraction, transformation, and load (ETL) packages for data warehousing and business automation. Visual Importer ETL Enterprise includes graphical tools and wizards for building and debugging automation packages; 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. Unlike Oracle SQL loader, BCP, DTS or SSIS, Visual Importer Enterprise 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 Enterprise 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 Enterprise 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 Enterprise writes a detailed message into the log and writes a record into the rejected records file.

The Enterprise version includes execution agent, which can be run as a Windows service.

User's rating:

  • Currently 2.50/5
  • 1
  • 2
  • 3
  • 4
  • 5
Enlarge the screenshot of Visual Importer ETL Enterprise
[ Enlarge Image ]

Download alternate Visual Importer ETL Enterprise solution

Look at the free or trial alternatives and similar apps to Visual Importer ETL Enterprise software by the tags. It's possible also to find substitutes for the most popular titles in the Business & Management category.

| Sql Loader | Powerful Etl Tool | Oracle | Odbc | Ms Sql Server | Datawarehouse | Business Automation | Bcp |

History updates (Complete changelogs since the listing on this site)

8.3.4.8 [05-09-13]

+ Introduced Repository Synchronization wizard
+ Addressed problems with updating Oracle blob fields
+ Documentation update
- Various bug fixes

Other versions : 8.3.4.4 8.3.3.7 8.3.3.2 8.3.2.9 8.3.2.3 8.3.2.0 8.3.1.4 8.2.0.4 8.2.0.0 8.1.2.0 8.1.0.0 8.0.3.2 8.0.3.1 8.0.2.3 8.0.1.6 8.0.1.4 8.0.1.0 8.0.0.1 7.7.8.4 7.7.8.0 7.7.7.23 7.7.7.19 7.7.7.18 7.7.7.16 7.7.7.15 7.7.7.14 7.7.7.13 7.7.7.12 7.7.7.11 7.7.7.9 7.7.7.8 7.7.7.7 7.7.7.5 7.7.7.3 7.7.7.1 7.7.7.0 7.7.6.8 7.7.6.6 7.7.6.2 7.7.6.0 7.7.5.18 7.7.5.15 7.7.5.12 7.7.5.11 7.7.5.10 7.7.5.8 7.7.5.6 7.7.5.5 7.7.5.3 7.7.5.2 7.7.5.0 7.7.4.18 7.7.4.16 7.7.4.15 7.7.4.13 7.7.4.8 7.7.4.6 7.7.4.2 7.7.2.9 7.7.2.4 7.7.2.3 7.7.1.10 7.7.0 7.6.2 7.6.1 7.5.17 7.5.15 7.5.14 7.5.11 7.5.10 7.5.7 7.5.5 7.5.3

v8.3.4.4 [04-20-13]

Undo/Redo Functionality was improved
Documentation update

v8.3.3.7 [03-11-13]

Added support to Redo and Undo to package designer
Added Register option to help menu
Various bug fixes and interface improvements

v8.3.3.2 [03-03-13]

Added align left, align top, align right, and align bottom buttons
Better object selection for packages
Various bug fixes and interface improvements

v8.3.2.9 [02-14-13]

+ Added Keep Characters Function
+ Added Epoch to Date Function
+ Added Date to Epoch Function
+ Interface improvements
+ Documentation update
- Various bug fixes

v8.3.2.3 [01-31-13]

+ Improved support for MS SQL Server 2012
+ Improved support for BDE
+ Logging improvements for Connection type, connection name and connection details
- Agent bug fixes
- Various bug fixes

v8.3.2.0 [01-15-13]

+ Support for BDE was introduced
+ Documentation Update
- Various bug fixes

v8.3.1.4 [12-17-12]

+ Added copy paste functionality to IMAP connections
+ OLE Reports Dialogue is resizable now
+ Introduced Auto complete functionality
- Addressed some issues related to loading data from QVD files
- Various bug fixes

v8.2.0.4 [11-03-12]

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

v8.2.0.0 [09-02-12]

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

v8.1.2.0 [07-22-12]

+ New package object was introduced = Case
+ New variables ,,
- Various bug fixes

v8.1.0.0 [07-01-12]

+ 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

v8.0.3.2 [05-19-12]

+ 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

v8.0.3.1 [04-07-12]

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

v8.0.2.3 [03-23-12]

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

v8.0.1.6 [03-09-12]

- Addressed some issues related to working with integrated scheduler

v8.0.1.4 [02-21-12]

+ Improved Support for QlikView QVX files was introduced (uses QVX_QV_DUAL fields now, It is the fastest way of loading data into QlikView)
- Addressed some issues related to working with MS SQL Server Compact edition

v8.0.1.0 [01-15-12]

+ ZIP dialog can decompress and compress files now
+ Order of fields was charged in connection dialog: user selects server name, enters the user name and password and finally user selects the database.
+ Even smaller executable now
- SMTP testing was fixed for SSL connection

v8.0.0.1 [12-31-11]

MAJOR RELEASE

+ CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums
+ Simplified Repository management
+ Execution log has Execution time percentage
+ Schedule package execution directly from the package designer

v7.7.8.4 [10-27-11]

+ 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

v7.7.8.0 [10-12-11]

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

v7.7.7.23 [09-17-11]

Addressed some issues related to processing emails
Added pause package execution object
Fixed bugs related to working with time fields in MySQL
Export into excel via DDE was introduced
Added Support for XSLT transformations
Ping Server and Check Database connection was introduced

v7.7.7.19 [09-06-11]

Added Support for XSLT transformations
Various bug fixes

v7.7.7.18 [09-02-11]

GUI changes
Improved support for email processing
Various bug fixes

v7.7.7.16 [08-07-11]

Ping Server and Check Database connection was introduced
It is also possible to schedule package for execution directly from package designer
Various bug fixes

v7.7.7.15 [07-21-11]

Package can be run every second now

v7.7.7.14 [07-12-11]

Data import wizard fixes
Import Script can get variables values from packages now

v7.7.7.13 [07-07-11]

Added "Search in subdirectories" option to data reader

v7.7.7.12 [06-22-11]

Addressed some issues related to loading data from XML Files

v7.7.7.11 [05-26-11]

Package editor interface improvements
Clear log shows dialog box first
Direct Latest Version downloads from application
Various Bug Fixes

v7.7.7.9 [05-11-11]

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

v7.7.7.8 [04-14-11]

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

v7.7.7.7 [03-29-11]

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

v7.7.7.5 [02-28-11]

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

v7.7.7.3 [02-06-11]

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

v7.7.7.1 [01-14-11]

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

v7.7.7.0 [12-31-10]

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

v7.7.6.8 [12-11-10]

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

v7.7.6.6 [11-28-10]

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

v7.7.6.2 [11-16-10]

Works correctly with mixed case objects in PostgreSQL
Various bug fixes

v7.7.6.0 [10-29-10]

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

v7.7.5.18 [10-20-10]

Loads data into PostgreSQL 9.0
Improved Unicode support for Oracle connections
Title menu in data grids was added
Various Data transformation improvements

v7.7.5.15 [09-14-10]

Works directly with SQLite now
New look and feel
Various Interbase/Firebird related bug fixes
Fixed bug with import of MS Access tables with spaces in names
Import Wizard Improvements

v7.7.5.12 [08-27-10]

Works directly with Excel 3.0-2007
No ODBC, OleDB or MS Jet Required
Works correctly with mixed data types
Works correctly with cells with more 255 characters
No need for IMEX=1, HDR=Yes or Registry hacks (TypeGuessRows)
Loads data correctly all the time + no need to edit Excel file

v7.7.5.11 [07-26-10]

Various interface improvements
Various access violations were fixed
Problem with duplicated fields was resolved
Application loads much faster now
Large repositories are updated much faster now

v7.7.5.10 [07-06-10]

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)
Added shortcuts to table's menu
Select * from table
Delete from table
Truncate table

v7.7.5.8 [05-24-10]

Fixed Loading data into DBF files

v7.7.5.6 [04-23-10]

Various bug fixes

v7.7.5.5 [04-13-10]

Support for SQL Server 2005/2008 was improved
Various bug fixes

v7.7.5.3 [04-03-10]

Improved support for blobs.
Various bug fixes

v7.7.5.2 [03-09-10]

Fields notes were added
Various bug fixes

v7.7.5.0 [02-13-10]

Support for FTPS and FTPES was introduced
Support for Ole Db was added
Minor bug fixes

v7.7.4.18 [02-04-10]

New tab was added to data source properties dialog called "Data reading restrictions"
Find Object dialog was added
Minor bug fixes

v7.7.4.16 [01-06-10]

Check Disk Space Object was introduced
Minor bug fixes

v7.7.4.15 [12-13-09]

Repository Synchronization bugs were fixed
Support for MySql, Intebase and PostgreSql was added to Sql Check Data
Package copy paste bug was fixed
Minor bug fixes

v7.7.4.13 [11-16-09]

Repository Synchronization bugs were fixed
Support for MySql, Intebase and PostgreSql was added to Sql Check Data
Package copy paste bug was fixed
Minor bug fixes

v7.7.4.8 [10-18-09]

Some issues related to renaming files were resolved

v7.7.4.6 [09-28-09]

Data Export Wizard was introduced
Now you can export 3000+ tables from the database with couple of clicks

v7.7.4.2 [08-17-09]

Now works directly with
MySql
PostgreSQL
Interbase and Firebird

v7.7.2.9 [06-18-09]

Minor bug fixes

v7.7.2.4 [05-12-09]

Various bug fixes

v7.7.2.3 [04-15-09]

Various bug fixes

v7.7.1.10 [02-25-09]

Up to 7 times faster ETL Transformation
Thousands of records per second
Full Support for Unicode
Better integration for Oracle databases

v7.7.0 [12-18-08]

Updated SQL Query Builder
Support for Oracle 11g

v7.6.2 [09-16-08]

Support for Excel 2007 and Access 2007 was added

v7.6.1 [08-23-08]

Major improvements related to working with ftp servers

Resuming uploads and downloads
Uploads and Download progress bar
Automatic reconnects

v7.5.17 [07-12-08]

* Minor bugs fixes

v7.5.15 [06-21-08]

* Minor bugs fixes
* Import script interface improvements

v7.5.14 [05-31-08]

Various bug fixes

v7.5.11 [05-10-08]

Now it is possible to specify newline character for text files.

Repository Synchronisation was introduced. This wizard helps to copy objects between different repositories.
When package or any other object selected for synchronisation all related objects are selected as well.

v7.5.10 [04-19-08]

Support for Password Protected Zip Fies was introduced

v7.5.7 [03-26-08]

Import Script creation Wizard was added.
This feaure was requested by one of our customers
http://www.dbsoftlab.com/index.php/Support/491-Usability-questions.html

v7.5.5 [03-04-08]

Now works with MS Access and DBF Files

v7.5.3 [02-06-08]

Now works with MS Access and DBF Files

Average review rating :

Useful independent reviews and opinions of the users

Review Visual Importer ETL EnterpriseWrite a review « Be the first to post a review for Visual Importer ETL Enterprise download!

Predicted future versions and notices:

The doDownload.com constantly monitors the update of all programs, including information from the Visual Importer ETL Enterprise 8.3.5.0 changelog file, however sometimes it can happen that data are not complete or are outdated.We assume that author continue's to develop 8.4.0.0 version with further advanced features, and soon you will be informed. Equally important 9.0.0.0 upgrades of the program we will continue to monitor. Full Visual Importer ETL Enterprise description has been compared with the overall software database and our algorithm has found the following applications (are showed below).

Click to buy Visual Importer ETL Enterprise online

Buy now

Online shop for buying.

Download 17.1MB Visual Importer ETL Enterprise

Download Direct

(17.1MB, Extension: ZIP)