Visual Importer Trial

Written by Admin on. Posted in Software

Visual Importer TrialVisual 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.
Visual Importer is a fast and efficient application for extracting, loading and transforming databases. Now you can load 14,347 records a second with the easy-to-use Visual Importer 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  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. · Time saver #3: ease of use because Visual Importer  was especially designed for non-technical users, it can be picked up in as little as 10 minutes.
Here are some key features of “Visual Importer”:
  • 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
  • 30 days trial
  • Timed nag screen
What’s New 
  • MySQL date processing bugs fixes

Tags: ,

Trackback from your site.

Leave a comment