All Forums General
Vinay151 20 posts Joined 12/14
30 Dec 2014
Loading data from Netezza table to Teradata table using TPT

Hi,
  Is it possible to load the data from Netezza table to Teradata table using TPT script?
 
Thanks,
Vigneshwar.

Raja_KT 1246 posts Joined 07/09
30 Dec 2014

The last wizard I saw, Netezza was not there as source type.You can check it. Nevertheless, I used SAP DS, Ab Initio, Informatica... and there are other tools too to migrate. But it is better to choose tools that have parallelism features to the maximum.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

dnoeth 4628 posts Joined 11/04
31 Dec 2014

Hi Vigneshwar,
you should try TPT's ODBC operator to connect to Netezza.

Dieter

Raja_KT 1246 posts Joined 07/09
31 Dec 2014

BTW Dieter, the odbc should be from Progress Direct if it is pre 15.0, am I right? Hoping the performance is good there.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.