Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 21 Dec 2000 @ 16:09:31 GMT

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

Subj:   Re: Import via ODBC
From:   Randy Heldt


I've successfully used NCR's OLE DB Access Module to move data from many different data sources (including MS Access, MS Excel, Oracle, MS SQL Server) to Teradata. It's point and click simple and extremely fast. Once you've identified the data source, it automatically generates and executes a Teradata FastLoad job to create the target table using column definitions that correspond to the source and populate it without having to create an intermediate data file. I once moved over fifty Oracle tables to Teradata in less than four hours.

Unfortunately, it only runs on Windows NT (workstation or server) or 2000 and requires the Teradata FastLoad product to be installed on the same client.

Randy Heldt
Teradata Solutions Group
NCR Corporation

  <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: 28 Jun 2020