Visual Importer FAQ

 1) What is Visual Importer?

Visual Importer is an ETL Tool designed to automate loading data into ANY database. Typical usage of it would be truncate table, load data into it, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP,  DTS or SSIS Visual Importer can also add new and update old records based on primary key

2) What are the requirements for Visual Importer installation?

Below is a List of Software that must be installed before installation of Visual Importer:

3) Which Data sources are supported?

 Visual Importer works directly with following datasources 

• Delimited and fixed width Text files
• MS Excel 3-2007
  
• DBF/Foxro Files
• MS Access 95-2007 Databases
• Any ODBC source

 4) Which target databases are supported?

 Visual Importer works directly with Microsoft SQL Server 7-2008, Oracle 7-10g and any ODBC Compliant database.

 Oracle
 
There are two ways of loading available:

• Oracle direct path loading
• Conventional path

SQL server

This software uses the same API as Microsoft DTS service.

5) Can I use Visual Importer to transfer data from one Oracle Ver. to Another Oracle Version?

Ans. Yes, you can use Visual Importer to load data from one Oracle version to another Oracle Version.

6) Is there any limit on number of rows which Visual Importer can process?

Ans. No, Visual Importer can be used to load millions of rows.  There are also no limitations in The Trail version

7) Is there any way for filtering source records?

Ans. Yes, you can filter rows while loading from MySQL, Oracle, MS-Access, MS-SQL Server, Foxpro Database source to any other Target Database or Text file.

You can write where clause or you can use Visual Importer own Filter    

8) I have several Files with same structure is it possible to load them in one go?

Ans. Yes Visual importer can load data from multiple text file, tables, MS Access Databases and Excel Files 

9) I am planning to load data from table with several millions of rows. I tried several tools and noticed that they will use all the memory and eventually fail. Is there such problem with Visual Importer?

Ans. No, Amount of memory used by Visual Importer does not depend on number of records processed.

10) Is it possible to truncate table before loading data into it?

Ans. Yes you can run a sql script before and after loading data.

11) Is there any way to run Visual Importer Scripts from the command line?

Ans. Yes, just run vimp.exe yourscriptname.vis

12) What kind of Date Formats are supported?

Ans. Date Formats in Visual Importer are user definable, for more information please see the list of date formats suported .

13)  Is it possible to run customised data transformation in Visual Importer?

Ans. Yes there is a vast number of transformation functions available such as concatenation, subtraction etc, for more information please consult user manual.

14) How do I resolve data quality issues in Visual Importer?

Ans. Visual Importer generates sophisticated transformation log and rejected records file.

15) Is it possible to update data using Visual Importer?

Ans. Yes, Visual Importer can Update, delete and insert data based on update key, for more information please consult user manual.

16) Is it possible to load data from pivot tables using Visual Importer?

Ans. Yes, Visual Importer can load data from pivot tables, for more information please consult user manual.

17) What is the difference between Visual Importer standart, professional and enterprise version?

Please have a look at the comparison table 

18) Does Visual Importer work on Windows Vista?

 Ans. Yes, It does.

19) What is the difference between standard license and site license?

 Standard license = one user.
 Site license = unlimited number of users within one or group of buildings within one city

If you have any other questions or problems please contact us and we will be glad to help you.

For Technical Support: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it

For General Support: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it