Visual Importer loads data into ANY Database from ANY Database or file. Full support for Excel, Access, DBF and Text files, Oracle, MS SQL Server, Interbase / Firebird, MySQL, PostgreSQL or any ODBC compliant database. Thousands of records per second.
Version: 22.214.171.124Now You Can Load 14, 347 Records A Second With The Easy-To-Use Visual Importer ETL
License: Free To Try $100.00
Operating System: Windows
If you regularly export, transform or load database data, Visual Importer ETL is designed to Save you time.
It does this in three ways:Time Saver #1: Processing Speed
Using Visual Importer ETL Standard version 126.96.36.199, you can load a delimited text file into MS SQL Sever via BCP 500000 lines in...
That's 14, 347.58 records per second.
Time Saver #2 Compatibility and Versatility
Processing speed is important, but it's not much use if you have to fiddle around with your data to get it into the right format.
So, we made sure Visual Importer works with almost all data formats you might be using.
It works with... * Multiple Delimited or Fixed width Text files * Multiple Excel files + Multiple Excel Spreadsheets * Multiple MS Access Databases + Multiple Tables * Multiple DBF Files
* Multiple Tables * MS Sql Server * Oracle Database * MySql * PostgreSql * Interbase / Firebird * SQLite * XML * Any ODBC Database
Visual Importer is a simple ETL tool
The latest version now allows you to load data from Utf8, Utf16BE, Utf16LE files with or without BOM.
There is full support for international characters for ODBC connections, MS SQL Servers and Oracle databases.
Unlike Oracle SQL loader, BCP, DTS or SSIS Visual Importer ETL can also add new and update old records based on user-defined key.
Time Saver #3 Ease Of Use
Because Visual Importer ETL was especially designed for non-technical users, it can be picked up in as little as 10 minutes...
I had my first upload running within 10 minutes of installing Visual Importer ETL" Gene Kovacs, Director of Technical Business Operations, A2B
Source Data Filtering, Multiple source tables and files. Unlike Oracle SQL loader, BCP, DTS or SSIS, Visual Importer can also add new and update old records based on the user-defined key.
Version 188.8.131.52: + Improved: Third party components update - Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)
Version 184.108.40.206: + Improved: Third party components update - Fixed: Addressed issues with loading data into XML,Image and Identity fields (SQL Server)
Version 220.127.116.11: + Improved: Up to two times faster loading data into sql server - Added: Support for TLS 1.2 SQL Server connections - Fixed: Addressed issues with loading data into XML,Image and Identity fields-SQL Server - Fixed: Issues with exporting data into csv and tab files from grids
Version 18.104.22.168: + Improved: Google Spreadsheet import - Fixed: Salesforce Bulk API load issues - Fixed: Round Function issues - Fixed: Issues with exporting very large grids into excel files
Version 22.214.171.124: - Fixed : Issues with QVX Files reading
Version 126.96.36.199: - Fixed : Issues with loading version information - Fixed : Fixed QVD reading issues
Version 188.8.131.52: + Improved: Setup procedure - Fixed : Issues with loading version info + Improved: Maximum ODBC Connection String is 4K now + Improved: Updated Salesforce API to v38
Version 184.108.40.206: + Improved: Query Builder components update + Improved: SSL components update - Fixed : Issues with updating data via table browser + Added : Added displayName,distinguisedName,initials,mailNickname,publicDelegates,sAMAccountType,scriptPath,showInAddressBook,sn,pager
Version 220.127.116.11: + Improved: Up to 10 percent performance increase while loading data into date/time fields + Improved: Support for JSON as data source
Version 18.104.22.168: + Added: Support for JSON as data source