1) What is Visual Importer Professional?

Visual Importer Professional is an automation tool. User can design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis. Visual Importer Professional stores all information in the repository. Unlike DTS, SSIS and Oracle Warehouse builder  Visual Importer Professional can receive emails and process attachments as well. All FTP operations also supported. By combining simple Package Items together Visual Importer Professional helps small businesses and Fortune 100 companies helps to automate complicated business processes and everyday tasks. 

2) What are the requirements for Visual Importer Professional installation?

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

Working with Oracle:

   Oracle client 7.3.4 and MS Ole DB Driver for Oracle to use Oracle repository on Oracle 7 and load data into it
     Or
   Oracle client 8.1.7 and Oracle Ole DB Driver for Oracle to use Oracle repository on Oracle 7-9 and load data into it
     Or
   Oracle client 9 and Oracle Ole DB Driver for Oracle to use Oracle repository on Oracle 8-9 and load data into it
     Or
   Oracle client 10 and Oracle Ole DB Driver for Oracle to use Oracle repository on Oracle 9-10g and load data into it

   Oracle ODBC Driver to load data from Oracle

Note:
   Depending on the Requirements you may or may not need to have all components installed

3) Which Data sources are supported?

Visual Importer Professional works directly with following datasources 

• Delimited and fixed width Text files
• MS Excel
• DBF Files
• MS Access Databases
• MS Sql Server Database
• Any ODBC source

 4) Which target databases are supported?

Visual Importer Professional works directly with Microsoft SQL Server 7-2005, 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 Professional to transfer data from one Oracle Ver. to Another Oracle Version?

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

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

Ans. No, Visual Importer  Professional 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 Professional own Filter    

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

Ans. Yes Visual importer Professional 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 Professional?

Ans. No, Amount of memory used by Visual Importer Professional 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 Professional Packages from the command line?

Ans. Yes,  there is  a separate tool available vpr.exe,

Usage

      run vpr -Opt to show options dialog

      run vpr 1234 to execute package (1234 is a package ID) 

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 Professional?

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 Professional?

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

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

Ans. Yes, Visual Importer Professional 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 Professional?

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

17) What is the package in Visual Importer Professional?

Ans. Packages combines different Actions together.

 Possible Actions are:

• Imports
• Exports
• SQL Scripts
• Packages
• File Checks
• File operations
• Ftp Downloads/Uploads
• Emails
• Applications
• ZIP’s
• POP3 Email Receivers
• SQL Data checks

18) Is it possible to combine several packages together?

Ans. Yes it is possible to add several packages into one and run it.

19) I would like to download files from our ftp server and load it into oracle database Is it possible?.

Ans. Yes it is possible. You can also notify system administrator about package execution results via email

20) What is the difference between Visual Importer standard, professional and enterprise version.

Please have a look at the comparison table 

21) We would like to export data from the database every day and save it into separate files using "yyyymmdd.txt" for file format, is it possible? 

Ans. Yes it is possible. by using functions  in filenames  as follows



Note:
Only one {} pair is allowed.

GETSYSTEMVARIABLE('SYSTEM_DATE') will return current date in ‘YYYYMMDDHHNNSS’ format

If we want only part of date we can use LeftString(String,Count):String for example

LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8) will return only date part.

Now more complicated example for loading yesterday’s data;

LeftString(DecDateS(GETSYSTEMVARIABLE('SYSTEM_DATE'),'YYYYMMDDHHNNSS', 'DAY',1),8)

Note:
For complete reference of available functions please consult chapter 16 of documetation.

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