All Forums Tools
jdliau 10 posts Joined 09/13
09 Jan 2014
OLELoad and FastLoad on Linux

Hi,
Two questions:
1. We have AMJ files generated by OLELoad on Windows. Can I use them with FastLoad tool on Linux machine and export data from Microsoft SQL Server to Teradata?
2. What kind of driver should I install on Linux so FastLoad can communicate with Microsoft SQL Server? 
Thanks!
J.D.
 

Fred 1096 posts Joined 08/04
09 Jan 2014

No, you can't use the AMJ files on Linux. OLELOAD is Windows-only. And FastLoad can only communicate with Teradata.
Consider using TPT with Load and ODBC operators, plus a SQL Server ODBC driver.

feinholz 1234 posts Joined 05/08
09 Jan 2014

I need to state here that TPT is only "certified" with ODBC drivers from DataDirect.
 
However, you are free to try to use any ODBC drivers you want.
 

--SteveF

cbackman 2 posts Joined 03/11
13 Jan 2014

Can I have some guidance on how to use TPT with ODBC on Linux (SUSE)?
 

feinholz 1234 posts Joined 05/08
16 Jan 2014

Please refer to the TPT documentation.
Everything you need should be explained there.
 

--SteveF

You must sign in to leave a comment.