Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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.

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023