1. What is Visual Importer ?
Answer: 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 ETL installation?
Answer: Below is a List of Software that must be installed before installation of Visual Importer ETL:
|
Software |
Version |
|
Notes |
|---|---|---|---|
|
Microsoft Windows |
98 or higher |
|
|
|
MDAC |
2.6 or higher |
Part of OS on W2K, XP, Vista. |
|
| MS Access ODBC driver | 4.00.6364.00 or higher | Part 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 driver | 2000.81.9041.40 | Part 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.DLL | Olnly 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 works directly with following datasources
- Delimited and fixed width Text files
- MS Excel 3-2007
- DBF/Foxro Files
- MS Access 95-2007 Databases
- OLE DB
- Oracle
- SQL Server
- MySql
- PostgreSQL
- Interbase/Firebird
- Any ODBC source
- XML
- QVX files
4. Which target databases are supported?
Visual Importer ETL works directly with Microsoft SQL Server, Oracle, MySql, PostgreSQL, Interbase/Firebird, 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 to transfer data from one Oracle Ver. to Another Oracle Version?
Answer: Yes, you can use Visual Importer ETL to load data from one Oracle version to another Oracle Version.
6. Is there any limit on number of rows which Visual Importer ETL can process?
Answer: No, Visual Importer ETL 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 the data
You can write "SQL where" clause or you can use Visual Importer ETL own Filter.
8. I have several Files with same structure is it possible to load them in one go?
Answer: Yes, Visual Importer ETL 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?
Answer: No, Amount of memory used by Visual Importer ETL 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 Scripts from the command line?
Answer: Yes, just run vimp.exe yourscriptname.vis
12. What kind of Date Formats are supported?
Answer: Date Formats in Visual Importer ETL 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 ETL?
Answer: 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 ETL?
Answer: Visual Importer generates sophisticated transformation log and rejected records file.
15. Is it possible to update data using Visual Importer ETL?
Answer: 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 ETL?
Answer: Yes, Visual Importer can load data from pivot tables, for more information please consult user manual.
17. What is the difference between Visual Importer ETL standart, professional and enterprise version?
Answer: Please have a look at the comparison table
18. Does Visual Importer ETL work on Windows Vista/Win 7?
Answer: Yes, It does.
19. 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
Still have questions?
