Page 1 of 1

Teradata V2R6 to MySql 5.0.26

Posted: Mon Jan 19, 2009 8:32 pm
by patchpanel
Hi there,

I don't know if there is already a topic for this. did'nt search and I am very new to datastage.

Is it possible to transfer data from Teradata v2r6 to Mysql 5? Just an exact copy of the table. What would be needed/requirements?

Thanks,

Posted: Mon Jan 19, 2009 9:21 pm
by ray.wurlod
Welcome aboard.

The answer is yes. You need client software for Teradata and an ODBC driver for MySQL, both installed on the same machine as your DataStage server.

Posted: Mon Jan 19, 2009 11:19 pm
by hamzaqk
:shock:

Posted: Tue Jan 20, 2009 12:03 am
by ray.wurlod
Yes, but you're biased!
:wink:

Posted: Tue Jan 20, 2009 6:14 am
by hamzaqk
Just a bit of a shocker :lol:

Posted: Wed Jan 21, 2009 10:13 pm
by patchpanel
ray.wurlod wrote:Welcome aboard.

The answer is yes. You need client software for Teradata and an ODBC driver for MySQL, both installed on the same machine as your DataStage server. ...
Thanks for the input :D
Just need to solidify the possibility it would work. I have read articles of it working with 7.5..

Yeah ,a bit biased since this is what we have right now for the project..hehe :lol:

Posted: Wed Jan 21, 2009 10:13 pm
by patchpanel
hamzaqk wrote:Just a bit of a shocker :lol:
Why the shock? haha :lol:

Posted: Thu Jan 22, 2009 1:13 am
by ray.wurlod
Take a look at hamzaqk's signature block: probably regards MySQL as a toy.