ETL and Data Integration tools - Modern ETL software for everyone

I am creating a package, which I want to be a replica of a DTS package I have in a SQLServer 2005 database. The source database is Informix, and
the target database is MySQL. From what I have found so far, for each ODBC connection I create an export and an import object. I can specify 'Buffer' as the output/input for the export/import respectively, but doesn't this export from the source database to a text file, and then import from the text file to the target database? Maybe I am missing something here, but this would be slower than pumping the data directly from the source
database to the target database (as the DTS DataPumpTask does). Some of the tables contain several million rows, that with SQL Sever DataPumpTask
takes around 10mins per table - writing to disk takes a bit longer, and then this time would be effectively doubled when reading into the target
table.

I have created the visual importer repository in MySQL, but when I execute the package - I get the same error over and over, it's too quick to note
down the actual error, but it has something to do with queue_id being null. If I use the default repository (MS Access) I don't get this error, but the package fails - even though if I execute the steps one at a time, it looks OK.

As I said, it could be my understanding, as I haven't got the package execution working properly.

I must admit I do like the package, if only I could get it working efficiently for me! Thank you for you time


Regards,
Ian

Ian

I suggest to use MS Access Repository for a now and try to import
data the way you want it after that we can have a look what is wrong with
MySql Repository if anything

Can you email us screenshot of the package and your error logs.

In order to trasfer data between ODBC databases you need to do the
following

1. create two odbc connections Using Microsoft ODBC Manager
2. Create two ODBC connections in Visual Importer
3. Create new import and specify as Data source Informix ODBC Connection
and Data Target MySql ODBC Connection
4. Next thing you need to is to specify sorce table, target table and map
the tables together
If you can't figure out it on your own I can prepare short guide with
screenshots and email it to you tonight

Mike

Mike,

I think I must have been having a "blonde" moment. Apologies.

I'll recheck the package execution to see if I still get errors, and get
back to you if I have any further problems.

Thanks once again.

Regards,
Ian

Mike,

I have now realised what I was doing wrong. The initial problem was that
the folder specified for the Text Files/Excel Files/Buffer were pointing to
C:\ drive - and my system drive is H:. I've corrected this and the
packages execute fine.

Thanks for your support. As soon as you return the Supplier Questionnaire
I will place an order for the software.

Regards,
Ian