Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 21 Dec 2000 @ 16:59:59 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Import via ODBC
From:   John K. Wight


I believe that you will find the OLE-DB Access module just made for your problem. However, what you will need is an NT server on which to run the OLE Module and the NT Client FastLoad, Multiload or TPUMP (all supported by OLE-DB). You will have to configure WinCLI as well when you install the Teradata Client software (now TUF 6.0), but that is pretty straight forward. You will find it considerably faster that ODBC and you DO NOT need a landing zone.

Also, OLE-DB will automatically establish your landing table when you create a process. However, you can (and we do) use our own scripts that we cut and past for the SELECT from the originating data source. Although it does not automatically generate a shell for MultiLoad, you can (and we do) use it with MultiLoad at a customer on the west coast. Give it a try - I think (hope) you will be pleasantly surprised! Ask your 'friendly neighborhood NCR rep' to get it on a trial basis to prove it to yourselves before you buy. You will need an NT server for this. If you are moving a goodly amount of data with OLE, suggest you configure a dual processor server with at least a gig or two of memory. When we went from a single processor system to a dual (550Mhz or better) with 2 gig of memory, we saw significant improvements with larger data sets and running 2-3 jobs in parallel.

Hope this helps you.

John K. Wight
Senior Solutions Consultant - Teradata Solutions Group
NCR Corp. - Arizona Territories

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023