Download Download Visual Importer Standard 5.4.5.11 Free

Visual importer It is a reliable and fully functional business intelligence (BI) program that can provide you with a simple way to easily extract, load and convert databases. It is suitable for users who need to execute SQL statements, import data into any database (whether MySQL, PostgreSQL or Oracle) and manipulate various files.

Moreover, the application can load data from ASCII and UNICODE files in various formats, including UTF8, UTF16BE and UTF16LE. Nevertheless, before making any connections and importing all the necessary files, you need to make sure that all the necessary ODBC drivers are running normally, otherwise, no matter which database you choose to use, you will not be able to import data.

The main window of the program is intuitive and easy to use. It is divided into five tabs, namely “Target Table”, “SQL”, “Template”, “Conversion Log” and “Reject Record”.

First, you need to access the “ODBC Manager” option from the “File” menu to ensure that all drivers are available. If the required driver is not configured correctly, press the “Add button” and then access the driver for which you want to set the data source.

After that, you need to configure the data destination options as needed. During the test, we connected to MS SQL Server, thereby specifying the server name, selecting the database, and setting the login information. In addition, Visual Importer identifies all the databases you can use, so, for example, if you want to connect to Salesforce, but the configuration is incorrect, you will notice that the option is grayed out.

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

By accessing the “SQL” tab, you can automate various scripts and create new queries ranging from simple to complex.

Overall, Visual Importer has proven to be a stable solution, especially suitable for users who need to incorporate ETL software packages (extract, load, convert) into their business to perform workflow functions and automate daily tasks.

File down

Import database management database ODBC connection import connection view connection