ETL and Data Integration tools - Modern ETL software for everyone

I'm trying to setup a large number of imports from Oracle to SQLServer, and have come across a couple of slightly confusing usability issues.

Obviously I have to setup one export and one import for each table.
Setting up an export is no problem, but in order to setup the import I have to have a text file (or other intermediary structure) that I can use to map the import fields.
This is fine so long as I've run the export task to create a text file, but this appears to require setting up a Package, and setting properties in here to specify the export filename.

This whole process seems extremely unwieldy and adds enormous complexity to the task of setting up simple 'transfer from A to B' tasks.

Am I missing something here, or is it really this complex? The option to export immediately to a text file from the export editor would at least simplify this process, and a 'wizard' to automatically generate the pair of matched files (export/import) and auto-create a Package to run the task would make the process enormously simpler.

I'm looking at using VIEnt to simplify the import process over using something like SSIS, but it really does seem to need a few usability changes.

Can you outline the process you would typically go through to setup an import from (for example) Oracle to SQL Server?

Thanks,
Jason

Jason.

There is no need to use text file in your case.

1. Create ODBC DSN to connect to Oracle.
2. Run Visual Importer and create NEW ODBC connection using ODBC DSN you created at step one.
3 create new Import select your sql server connection as data target and ODBC Connection created at step two as datasource.
4 Map tables and load data

Mike

Thanks Mike,
I'll try this on Monday.
I find the interface extremely unintuitive in many places (double-clicking, differences between 'edit' and 'properties' etc), so I think it could benefit from a wizard or two, even if people only use them to create rough templates to build upon.

Cheers,
Jason

Jason.

Thank you for the feedback.
We will add import wizard to the next release.
It will take one-two weeks.

If you have any more suggestions we are happy to discuss them

Mike

Jason

As you requsted we have added Import Script Creation Wizard.

Please download version 7.5.7 of Visual Importer Enterprise.

Thank you for your comments,
John

Hi,

I'm evaluating VI and am running in the same problem. I want to move data from multiple tables to multiple tables (1:1). Everything seems to work, except that I have to manually create a import task for EACH table.

This is really a LOT of work... Is this really the only way? Is there no way to do multiple tables at the same time?