Archives of the TeradataForum
Message Posted: Thu, 17 Jun 1999 @ 16:23:11 GMT
| Subj: | | Re: Teradata + DTS |
| |
| From: | | Bob Hahn |
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.
| 
