Visual Importer Standard 5.4.4.12

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. Additionally, 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.

FEATURES :
Transformations:
Adding Records
Updating Records
Deleting Records
Adding/Updating Records
Data Sources:
Multiple Text Files
Multiple Excel Files
Multiple Tables
Any ODBC Database
Target Databases:
Oracle 7-9i databases
MS Sql server 7- 2000
Any ODBC Database
Comprehensive log
Rejected records file
Integrated expressions builder
Mapping editor
Sql scripts
Data Preview
Data Filtering

Home Page: https://www.etl-tools.com/

Language: English