Visual Importer Standard icon

Visual Importer Standard

2.7/5 5
Certified 100% CLEAN Trial   

A versatile and comprehensive application whose main purpose is to automate complicated business processes and everyday tasks with ease. #Import database  #Manage database  #ODBC connection  #Import  #Connect  #View  

Softpedia Review

specifications

changelog

Free Download

buy now

Review by:
4.0/5

Visual Importer is a reliable and full-featured Business Intelligence (BI) program that provides you with a simple means of extracting, loading and transforming databases effortlessly. It is geared towards users who need to execute SQL statements, import data into any database, be it MySQL, PostgreSQL or Oracle, as well as manipulate various files.

What’s more, the application is able to load data from ASCII and UNICODE files in various formats, including UTF8, UTF16BE and UTF16LE. Still, before making any connection and importing all the necessary files, you need to make sure that all the required ODBC drivers are working properly, otherwise you won’t be able to import data, irrespective of the database you choose to work with.

The main window of the program is intuitive and user-friendly, organized in five tabs namely ‘Target Table’, ‘SQL’, ‘Template’, ‘Transformation Log’ and ‘Rejected Records’.

First off, you need to access the ‘ODBC Administrator’ option from the File menu in order to make sure that all the drivers are available. In case the required driver is not properly configured, press the ‘Add button’, then access the one which you want to set up a data source.

After that, you need to configure the data target options according to your needs. During our tests, we connected to MS SQL Server, thus specifying the server name, selecting the database and setting the login information. Also, Visual Importer identifies all the databases you can work with, so in case you want to connect to Salesforce, for instance, but it is not properly configured, you will notice that the option is grayed out.

The ‘Target Table’ tab displays all of the available columns identified in the selected database. You can view information such as data type, size, primary key, mapping type and data format.

By accessing the ‘SQL’ tab you are able to automate the execution of various scripts, as well as create new queries, from simple to complex ones.

Overall, Visual Importer proves to be a steady solution especially intended for users who need to include ETL packages (Extraction, Load, Transformation) into their business in order to perform workflow functions, as well as automate everyday tasks.

What's new in Visual Importer Standard 5.4.6.18:

  • Improved: String delimiter handling
Read the full changelog
User Comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy

Visual Importer Standard 5.4.6.18

add to watchlist add to download basket send us an update REPORT
  runs on:
Windows 11
Windows 10 32/64 bit
Windows 8 32/64 bit
Windows 7 32/64 bit
Windows Vista 32/64 bit
Windows XP
  file size:
12.3 MB
  filename:
VImpS_32.zip
  9 screenshots:
Visual Importer Standard - Visual Importer will help you extract, transform and load data into any database from any database or fileVisual Importer Standard - The SQL tab section will provide users with a list of options like SQL Before / After as well as basic management functionsVisual Importer Standard - Users will be able to create and edit templates for their various selection of connections supported by the applicationVisual Importer Standard - screenshot #4Visual Importer Standard - screenshot #5Visual Importer Standard - screenshot #6Visual Importer Standard - screenshot #7Visual Importer Standard - screenshot #8Visual Importer Standard - screenshot #9
  main category:
Internet
  developer:
  visit homepage