Visual Importer Entreprise FAQ

 1) What is Visual Importer Enterprise?

  Visual Importer Enterprise 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 Enterprise stores all information in the repository. Unlike DTS, SSIS and Oracle Warehouse builder  Visual Importer Enterprise can send and receive emails and process attachments as well. All FTP operations also supported. By combining simple Package Items together Visual Importer Enterprise helps businesses and Fortune 100 companies helps to automate complicated business processes and everyday tasks.
Enterprise Version includes execution agent which can be run as Windows service.

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

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

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 Enterprise works directly with following data sources 

• Delimited and fixed width Text files
• MS Excel 3.0 -2007
  
• DBF/FoxPro Files
• MS Access 95-2007 Databases
• MS Sql Server Database 7-2008
  
• Any ODBC source

  4) Which target databases are supported?

 Visual Importer Enterprise 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 Enterprise to transfer data from one Oracle Ver. to Another Oracle Version?

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

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

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

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

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

 Ans. No, Amount of memory used by Visual Importer Enterprise 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 Enterprise 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 Enterprise are user definable, for more information please consult user manual.

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

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

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

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

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

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

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

 17) What is the package in Visual Importer Enterprise?

 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) I would like to schedule package execution Is it possible?

Ans. Yes it is possible. There is an Execution Agent which does exactly that. You can also run it as windows service

 21) We would like to export data from the database every day and save it into separate file 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.

 22) What is the difference between Visual Importer standard, Enterprise and enterprise version?

 Please have a look at the comparison table 

 23) Does Visual Importer work on Windows Vista?

 Ans. Yes, It does.

 24) 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