Visual Importer ETL Standard v.

Editor's Review
Go For Visual Importer ETL Tool To Easily Load Data Into Database

Importance Of Visual Importer
Database necessities are systematically expanding with the increment in the mechanization of organizational actions. In today’s scenario, an exemplary organization doesn't keep barely one but a horde of multiplex databases in assorted formats in a bid to fulfill its demands. The chief trouble that amounts in such a scenario or during changing over between contrasting database programs that the database executives face-off is associated to secure and precise shift of database amidst these applications. If any supplement application program is truly effective, then it frequently misses out on the acceleration of performances. Visual Importer is a master tool that allows you to do all the transportation of database between assorted programs in an elementary and quick fashion and also permits you to do processes on this information.

Key Features
Visual Importer ETL software is configured to automate loading up data into any database. Whenever you regularly load information into the database, then it is ideal for you to use this tool as it is configured to spare you time. It works at a highly quick pace which extends to loading 14,347 records in a moment with arrant perfection with no information loss in the action. The application program is specifically intended for daily users who frequently face up troubles in importation, exportation and transforming this database. The program ingests an easy interface which has been manufactured to generate a spontaneous functionality to the final user and helps in quick treating of the database. The application program seamlessly functions with complete set of data formats you are able to entertain. A few of the formats are MySQL  Postgre SQL, Oracle, DBF files, Single or multiple Excel files, Ms Access database and a lot more. In short, the database format must have conformity with ODBC measure which is in general encountered with just about any of the formats.

• Software is very easy to use and is designed in such a way that even a novice user can master it within ten minutes of use
• Highly compatible and versatile as it works with most of the data formats that are available today
• Has excellent processing speed and hence saves a lot of your time

There is no doubt that Visual Importer is a decent application program for seamlessly functioning with multiplex database formats in a quick and elementary fashion.

Publisher's Description

Now You Can Load 14,347 Records A Second With The Easy-To-Use Visual Importer ETL

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, 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
* SQLite
* 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.

Visual Importer loads data into any database. 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.

load data into the database, dts, ssis, etl, oracle, ms sql server, bcp, sql loader, odbc, datawarehouse, oracle warehouse builder

  • Visual Importer ETL Standard
  • 24 Jul 15
  • DB Software Laboratory
  • WinXP, Windows2000, Windows2003, Windows Vista, Win98, WinME, WinNT 4.x
  • Shareware
  • 6.79 Mb
  • 1252
  • $100.00
Latest Versions History
Version Date Released Release Notes 24.07.2015 + Added support for Slemma + All documentation is in wiki format now + Excel Import and export from data grids is much faster now - Addressed issues with exporting data as excel from data grids - Addressed issues with deleting records from data grids - Addressed issues with loading null values into 30.05.2015 + Documentation update + Added GetExcelCellValue calculation function - Addressed issues with loading null values into salesforce - Addressed issues with loading data from SQL Server CE 21.02.2015 + Up to 10 percent faster data loading + Support for MS SQL server 2014 was extended 12.01.2015 + Query builder update + Added support for sub queries + Added incremental search to Query builder + Third party components update 26.11.2014 + Third party components update + Incremental search was added to all grids + Export to RTF was introduced + Excel export formats improvements + Various Interface improvements + Documentation update - Minor bugs fixes - Spelling corrections 13.10.2014 + Introduced support for Salesforce as datatarget 26.08.2014 + Better Data Reader Memory Management 26.08.2014 - Addressed issues with BIGINT fields + Import Script checking improvements 30.05.2014 + Smaller Setup - Addressed issues of loading data from the files with old creation date - Fixed problem with log deletion - Date Diff function fixes 27.03.2014 + Up to 5 percent performance increase - MySQL date processing bugs fixes 04.01.2014 - Addressed issues of loading data from flat files 30.06.2013 - Various bug fixes and interface improvements 08.06.2013 + Data reader timeout was introduced for ODBC,Access,MS Sql Server, OleDB, PostgreSQl, MySQl and MS Sql Server CE connections + Smaller executable + Memory usage was reduced for Excel files - Various bug fixes and interface improvements 08.05.2013 + Addressed problems with updating Oracle blob fields + Documentation update - Various bug fixes 18.04.2013 Added Register option to help menu Various bug fixes and interface improvements 27.01.2013 + Improved support for MS SQL Server 2012 + Improved support for BDE + Logging improvements for Connection type, connection name and connection details - Various bug fixes 13.01.2013 + Support for BDE was introduced + Documentation Update - Various bug fixes 03.11.2012 + Added option to ignore XML tags between Table tag and Record tag + Documentation Update 25.08.2012 + Support for QVD Files as data source was introduced 26.06.2012 + Support for BrightPearl was introduced + Support for Sales Force was introduced + Support for JDBC was introduced - Various bug fixes 14.05.2012 + Uses 10 times less memory for large excel files + Documentation update + Supports RSS, Google Spreasheets and Windows event log as datasource now 09.03.2012 + Support for Dynamic SQL for ETL transformations was introduced 22.01.2012 - Addressed some issues related to working with MS Sql Server Compact edition 22.01.2012 - Various bug fixes 19.12.2011 + Documentation Update + GUI Improvements 20.11.2011 + Added incremental search for expressions editor + Added file size transformation function + GUI Improvements 10.10.2011 + Interface Improvements + Standard print preview - Better error handling for ADO and MS Sql scripts 05.08.2011 Improved support for XML 10.05.2011 Now user can double click on *.vis file to open it Get latest version menu item was added Support for UTF-16 was introduced fro XML data reader Various bug fixes 13.04.2011 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

Review Visual Importer ETL Standard

  • captcha

Other software of DB Software Laboratory
  • Active Business Intelligence Portal  v.3.2.0Active BI Portal is business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and intranet. Active BI Portal works with all major commercial and open source databases.
  • Advanced ETL Processor  v. ETL Processor extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the "Preview" button and see what the results of an ETL flow would look like.
  • Advanced ETL Processor Enterprise  v. Complex Data warehouses and Automate Entire Business Processes, Transfer data from ANY Database into ANY Database or file,Use FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, Task scheduler and comprehensive logging.

New Database Management software
  • Aglowsoft SQL Query Tools  v.10.0Extract database schemas, build and run SQL queries, visualize data relationships in your databases, all with a single software package.
  • DbForge Unit Test for SQL Server  v.1.5.82GUI for implementing automated unit testing based on the open-source tSQLt framework in SQL Server Management Studio ...
  • Data Copy  v.7.6Find, Copy, Create, Edit, Convert, Query, Print, Email DataSnap, DBExpress, Access, Excel, and Text Files. Convert DataSnap, DBExpress, Access, and Excel Files.Exchange Data between Database Files, using the entire file or selected Fields.
  • DbForge SQL Tools  v.5.8.29The ultimate toolkit allows you to version-control databases, compare schemas and data, optimize database performance, write SQL queries on a fly, generate meaningful test data and much more straight in your favorite IDE ...
  • DriverVista For Gateway  v.7.5Update Vista/Win7 drivers for your Gateway notebooks. DriverVista For Gateway can help relieve you of worries about installing out-of-date drivers. It scans your system and install Gateway official drivers to your Gateway notebooks automatically.
  • HS MSG C/C++ Messaging Library  v.1.0.2HS MSG is a C/C++ messaging library (message oriented middleware) for communication between threads of the same process and between different processes on the same or on different computers.