ETL and Data Integration tools - Modern ETL software for everyone

Hi

I had downloaded Visual Importer Professional and I was able to do simple Single table to Single table mapping. But I was not able to Map Multiple table columns in to an Single Target Table.

Can U Please through some light on this situation.

Thanks and Regards
Pavan

There are several ways of doing it

First of all you tables have absolutely same structure eg fields order, names and data types, you can load data from multiple tables using mask.
or you can create multiple import scripts and execute them one after another.
Or you can use select statement as datasource fro example
Select * from orders1
Union all
Select * from orders2

Mike

Thank you for the clarification

We have used Visual Importer (VI) professional Trial version for a demo for one of our client's requirements and would like to suggest VI(Enterprise) to be used for the project. But we have a few questions from the client we are unable to satisfactorily respond. Could you help us on the same.

Questions
1. VI Professional took just over 1 minute to import 65000 records from a Oracle DB into a MySQL DB. The client wants to know what has been the maximum volume of data that VI has handled in some of its earlier projects as the main database runs into 500plus GB of data and millions of records. Could you provide some inputs on this.

2. Where does VI tool store the configuration data and in what format? This is to take backup of config file data for any emergency situations

3. The Client also wants some information on Scalability features of VI

4. Can the log file creation be configured to capture more details. If so how?

Could you help us with more information on these questions. This will help us sell the case for VI.

Kindly revert on this ASAP
Pavan

Hi.

1. Detailed logging of events.

Top level information is written to the repository.
More detalided information saved to the text files.
Such as
Package execution log
Sql script execution log
Import script execution log
FTP Log
SMTP Log
Rejected records file

It is already very detailed if something is missing we will be happy to extend it

2. Scalability issues (handling millions of records)

We've tested Vimp pro by loading 1.5 mln records.
Memory consumption does not grow when massive amount of data is beeing
loaded

3 Where does Visual Importer store the configuration data? (to have a
copy of the config data file as a backup for any unforeseen events).

Vimp Pro stores configuration data in the repository
Repository can be
MS Access
MS Sql Server
MySql
Oracle
PostgreSql
Interbase

All scripts required to create repository are provided

Mike