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: 220.127.116.11Now 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 18.104.22.168, 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 22.214.171.124: + Improved: Software registration process + Improved: JSON Data Handling + Added: Support for SQL Server 2017 - Fixed: Issues with loading data into varchar(max) field - Improved: SQL Server error handling
Version 126.96.36.199: + Added: Ability to pull license from the license server
Version 188.8.131.52: + Improved: Third party components update: Excel processing libraries + Improved: Various bug fixes and improvements - Fixed: Excel data reading problems
Version 184.108.40.206: + Added: Syslog datasource - Fixed: JSON Data reader AV
Version 220.127.116.11: Improved: Loads data from OLE Db up to 4 times faster Improved: Loads data from SQLite up to 2 times faster Improved: The application starts much faster Improved: It is now possible to add files to the existing archive Fixed: Issues with reading google spreadsheet data
Version 18.104.22.168: Added: New datasource - Twitter Improved: Loads data into SQL server up to 25 percent faster Improved: Active Directory Connection look and feel
Version 22.214.171.124: + Improved: Third party components update - Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)
Version 126.96.36.199: + Improved: Third party components update - Fixed: Addressed issues with loading data into XML,Image and Identity fields (SQL Server)
Version 188.8.131.52: + 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 184.108.40.206: + Improved: Google Spreadsheet import - Fixed: Salesforce Bulk API load issues - Fixed: Round Function issues - Fixed: Issues with exporting very large grids into excel files