Is there any way to import MYSQL Database into Teradata at Staging Level?

General
Fan

Is there any way to import MYSQL Database into Teradata at Staging Level?


Hi all,
I want to ask, is there any way to import MYSQL Database or MYSQL dump file into Teradata using any scripts like FLoad or using OleLoad utility?
1 REPLY
Enthusiast

Re: Is there any way to import MYSQL Database into Teradata at Staging Level?

I don't think you'll be able to import the Dump file, as it's most likely in a proprietary format for MySQL. OleLoad should work. It works with any data source that has some kind of OLEDB access (either native or through ODBC). It just could be time consuming, depending on how many tables you have to copy. The same thing can be done with TPT and the ODBC operator, but again it takes time. Most ETL tools (Data Integrator, DataStage, AbInitio, etc.) should also allow you to copy data from an ODBC source like a MySQL database to Teradata.