Archives of the TeradataForum

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

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

Jiri,

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>>