All Forums General
asa436 2 posts Joined 04/08
20 Jun 2011
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?

Abdus S@boor Ahm@d
mnylin 118 posts Joined 12/09
21 Jun 2011

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.

You must sign in to leave a comment.