Archives of the TeradataForum

Message Posted: Thu, 17 Jun 1999 @ 16:23:11 GMT

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

I'm in NCR Engineering....

We have a 9/99 deliverable that we are (internally) referring to as the OLE-DB Consumer Access Module.

The product will include a DTS-like GUI that enables table copy or sending a SQL request to any OLE-DB provider. We have not committed support for the DTS provider (defining DTS' output as a dsorowset provider). There are a couple of aspects that don't work quite right that are still under investigation.

The GUI will generate a Fastload script for the load from the rowset received from the provider. I'm not sure if the first out will also create an MDL script. Even if we don't, the Access module itself can be used by Fastload, Multiload, TPump.

In the meantime, DTS can be used with the Microsoft OLE-DB Provider for ODBC along with the NCR Teradata ODBC driver for bidirectional data propagation amongst Teradata and any OLE-DB provider (including DTS) albeit with a less performant flow than the utility integration will provide.

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