Visual Importer Enterprise - FAQ

1. What is Visual Importer ETL Enterprise?

Answer:

Visual Importer ETL 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 ETL Enterprise stores all information in the repository. Unlike DTS, SSIS and Oracle Warehouse builder Visual Importer ETL Enterprise can send and receive emails and process attachments as well. All FTP operations also supported. By combining simple Package Items together Visual Importer ETL 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 ETL Enterprise installation?

Answer:

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

 

Software

Version

 

Notes

Microsoft Windows

98 or higher

 

 

MDAC

2.6 or higher

Part of OS on W2K, XP, Vista.

 

MS Access ODBC driver4.00.6364.00 or higherPart of OS on W2K, XP, Vista.Only to load data from MS Access 95-2003 Databases

MS Access 2007 ODBC driver

2000.81.9041.40

Here is download link

Only to load data from MS Access 2007 Databases

Visual FoxPro ODBC driver

6.1.8629.1 or higher

Here is download link

Only to load data from DBF or Foxpo Files

SQL ODBC driver2000.81.9041.40Part of OS on W2K, XP, Vista.Only to import data into MS SQL Server

Oracle Client

7.3.4 or higher

Provided by Oracle

Only to import data into Oracle

Interbase Client GDS32.DLLOlnly to to load data into |Interbase or Firebird

 

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

Or
Oracle client 11 and Oracle Ole DB Driver for Oracle to use Oracle repository on Oracle 10-11g and load data into it

Note:

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

3. Which Data sources are supported?

Answer:

Visual Importer ETL Enterprise works directly with following data sources

  • Multiple Delimited or Fixed width Text files
  • Multiple Excel files + Multiple Excel Spreadsheets
  • Multiple MS Access Databases
  • Multiple Foxpro/DBF Files
  • Oracle
  • Microsoft SQL Server
  • Firebird/Interbase
  • MySQL
  • PostgreSQL
  • Any ODBC source
  • OLE DB
  • XML files
  • RSS Feeds
  • Google Spreadsheets
  • SalesForce
  • BrightPearl
  • QVX files

4. Which target databases are supported?

Visual Importer ETL Enterprise loads data into Microsoft SQL Server, Oracle, Firebird/Interbase, MySQL, PostgreSQL, OLE DB  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 ETL Enterprise to transfer data from one Oracle Ver. to Another Oracle Version?

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

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

Answer: No, Visual Importer ETL 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?

Answer: 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 ETL Enterprise own Filter

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

Answer: Yes Visual Importer ETL 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 ETL Enterprise?

Answer: No, Amount of memory used by Visual Importer ETL Enterprise does not depend on number of records processed.

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

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

11. Is there any way to run Visual Importer ETL Enterprise Packages from the command line?

Answer: 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?

Answer: Date Formats in Visual Importer ETL Enterprise are user definable, for more information please consult user manual.

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

Answer: 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 ETL Enterprise?

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

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

Answer: Yes, Visual Importer ETL 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 ETL Enterprise?

Answer: 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 ETL Enterprise?

Answer: Packages combines different Actions together.

Possible Actions are:

  • Imports
  • SQL Scripts
  • Packages
  • File Checks
  • File operations
  • Ftp Downloads/Uploads
  • HTTP downloads
  • Emails
  • Applications
  • Compression/Decompression
  • Reports
  • Scripts
  • Pause
  • Ping server
  • Check connection
  • Backup repository
  • Export data
  • Pause
  • Messages/questions
  • Variables
  • POP3 Email Receivers
  • SQL Data checks
  • Check disc space
  • Compare files

18. Is it possible to combine several packages together?

Answer: 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?

Answer: 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?

Answer: 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?

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

  • c:\mydata{GETSYSTEMVARIABLE('SYSTEM_DATE')}.txt

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?

Answer:

Please have a look at the ETL Comparison table

23. Does Visual Importer ETL Enterprise work on Windows Vista/Win 7?

Answer: Yes, It does.

24. What is the difference between standard license and site license?

Answer:

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

25. DTS and SSIS do not support secure FTP (FTPS), what about your ETL software?

Answer: Yes, It does support secure FTP and it also supports secure Email.

26. What is the best way to learn ETL software?

Answer: Using online ETL flash manuals is the best way to learn

Visit Support Forum Learn More Download Buy It

Testimonials

Support team is quick and very often they reply to forum posts within minutes.

Mark Jonson,
EDS

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Databases we work with