Teradata V2R6 to MySql 5.0.26

patchpanel · Post by **patchpanel** » Mon Jan 19, 2009 8:32 pm

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,

ray.wurlod · Post by **ray.wurlod** » Mon Jan 19, 2009 9:21 pm

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.

hamzaqk · Post by **hamzaqk** » Mon Jan 19, 2009 11:19 pm

ray.wurlod · Post by **ray.wurlod** » Tue Jan 20, 2009 12:03 am

Yes, but you're biased!

hamzaqk · Post by **hamzaqk** » Tue Jan 20, 2009 6:14 am

Just a bit of a shocker

patchpanel · Post by **patchpanel** » Wed Jan 21, 2009 10:13 pm

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

patchpanel · Post by **patchpanel** » Wed Jan 21, 2009 10:13 pm

hamzaqk wrote:Just a bit of a shocker

Why the shock? haha

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2009 1:13 am

Take a look at hamzaqk's signature block: probably regards MySQL as a toy.