Teradata Native Connector - Data Integrator Premium

[Former Member]

Hi all,

We have Data Integrator Premium 3.0, and this version include all database interfaces.

How can i connect to Teradata without ODBC Driver for Teradata??

There is some Teradata Client?

Thanks for your help.

Edited by: Jorge Orozco on Dec 10, 2008 3:04 PM

[Former Member]

Hi Jorge,

You need to distinct between reading from Teradata and loading into Teradata. For reading DI will always uses ODBC, the benefits of a native connectivity only come in for the loading part. Loading via ODBC would be terribly slow, so in our Teradata loader we provide support for the different bulk loading mechanisms Teradata has (FastLoad, MultiLoad, TPump, Parallel Transporter).

So if you create a Teradata datastore in DI, you need to fill in the ODBC parameters for reading and metadata browsing, when one of the tables is used as a target, you will see all the bulk loading options in the table loader.

- Ben.

[Former Member]

Ok. That's clear now.

Thanks Ben.

[Former Member]

Hi Ben,

I was searching for Teradata connector for SAP BI and came across your post.

We are using SAP BI (BI 7.3) for data ETL and interfacing requrements. We produce flat files from Openhub.

But we would like to use DB write directly to Teradata in order to improve performance and solve several issues with files.

Could you provide a link on details on the Tera Data connector which would enable us to write directly to teradata tables at the same time use bulk loading mechanisms Teradata has (FastLoad, MultiLoad, TPump, Parallel Transporter).

Thanks,

Amit