Visual Importer 4.9.4.8
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 4.9.1.4, you can load a delimited text file into
MS SQL Sever via BCP 500000 lines in... 34 seconds!
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
* Any ODBC Database
Visual Importer is a simple ETL tool
And...
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.
Aded new calculation function DateDiffS
DecDateS(Date1,Format1, Date2,Format2,Type):String.
Use DateDiffS to calculate Type difference between two dates.
Minor bug fixes
Rest of the products to follow.
We also working on adding support for PostgreSQL and Interbase/Firebird
Minor bug fixes
Improved support for NonStop ODBC/MX 2.0 ver 3.51.20.126 ODBC Driver
Various Cosmetic Changes and Bug Fixes
Thousands of records per second
Full Support for Unicode
Better integration for Oracle databases
Thousands of records per second
Full Support for Unicode
Better integration for Oracle databases
Query ODBC data sources, author SQL scripts and queries, execute multiple SQL scripts or stored procedures simultaneously, and more.
Advanced CSV Converter supports all the modern data interchange formats, such as XLS, DBF, XML, HTML, RTF and others. The program supports batch conversion and the ability to set the conversion filter by example.
Configuring and running of data exchange between various sources - OPC servers, OPC client applications, device communication drivers, data handling, monitoring, storage into process databases, trends, alarms, logging, reports, integrating to SOA
Vendor Organizer Deluxe is a flexible vendor and supplier management software for Windows users.
Easy and quick database administration, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Main features: Creating and restoring backups. Transfer data between databases, tables and data files or edit database schema.

