Archives of the TeradataForum
Message Posted: Thu, 21 Dec 2000 @ 16:09:31 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|