It is designed as a single solution to replace all the Teradata legacy stages. The Teradata Connector is available on IBM InfoSphere Information Server Version 8.0.1 and later.
It allows applications to perform constant data load operations to a table in the background while the interactive read and write operations can occur concurrently.Įxport driver - uses the FastExport protocol to perform the parallel data export. Stream driver - uses the TPump protocol to perform the parallel real-time DML operations on tables.
Update driver - uses the Multiload protocol and supports parallel insert/update/delete/upsert operations to new or existing tables. Load driver - uses the FastLoad protocol to perform parallel load to empty tables.
The Teradata connector supports four drivers specified in the Teradata parallel transporter interface: The Teradata parallel transporter interface is a parallel enabled programming interface that can run a bulk operation using multiple processes on multiple computing platforms. In bulk mode, the connector leverages the Teradata parallel transporter interface and the multiple computing nodes defined in the SMP and MPP configuration to perform the parallel data load and data export operations. The immediate mode and the DBC/SQL partition are suitable for supporting the low volume data processing.īulk mode - this mode is suitable for batch and bulk data processing. The Teradata DBC/SQL partition is responsible for processing the SQL requests. Immediate access mode - in this mode the connector sends the database SQL statements to the Teradata DBC/SQL partition and gets immediate responses back from the Teradata.
It operates in either immediate access mode or in bulk mode: The Teradata Connector leverages new Teradata features. Teradata Shared Component for Internationalization (tdicu) Teradata Generic Security Services (TeraGSS) client package TTU is required on the engine tier and must also be installed on the client tier if the Teradata legacy stages are used in ETL jobs. Teradata Tools and Utilities (TTU) - this component includes many products that work with the Teradata databases. The Teradata legacy stages, however, include the client installation for the client tier and the server installation for the engine tier. The Teradata connector is installed on the engine tier. The Teradata connector is a single solution designed to replace all the legacy stages. The InfoSphere Information Server requires the following components to support data integration with Teradata databases:ĭataStage Connectivity for Teradata - this component includes the Teradata Connector and all the other Teradata legacy stages. The Information Server supports deploying the engine tier on a symmetric multiprocessing (SMP) computing platform or on a massive parallel processing (MPP) computing platform to achieve high scalability and performance. The tiers can be installed separately on different computers or on the same computer. IBM InfoSphere Information Server logical tiersĮach tier defines a logical group of software modules that can be mapped to a physical piece of hardware.
These examples provide guides that show you how to solve typical data integration problems with Teradata databases. It contains examples to demonstrate the business integration scenarios.
This article illustrates and compares several integration approaches within the IBM InfoSphere Information Server to deal with the Teradata data. IBM Information Server is an ideal solution to integrate and synchronize Teradata enterprise data with other ERP systems and enterprise applications It profiles, cleanses, and transforms data from heterogeneous data sources to deliver consistent and accurate business data. IBM InfoSphere Information Server is a unified and comprehensive information integration platform.