Teradata connection
This connector is currently in Beta stage.
Teradata on Data Integration together provides the strengths of Teradata's data warehousing technology with Data Integration and orchestration. This integration enables seamless loading, transformation, and analysis of data from diverse sources into Teradata's powerful analytics environment. With Data Integration capabilities, businesses can efficiently manage their data workflows and leverage Teradata's scalability and performance for data-driven decision-making and insights.
Teradata compatibility versions
| River Modes | Versions Supported | Support for Managing Schema Drift |
|---|---|---|
| Multi-Tables (Standard Extraction) | Version 15.10 | Yes |
Prerequisites
You must set up your database's Host, Port, Username, and Password before connecting to Teradata.
Procedure
You can connect to Teradata using one of two methods:
- Login Credentials
- SSH Tunnel
Login credentials
-
Navigate to the Data Integration Account.
-
Click Connections and select + New Connection.
-
Choose Teradata.
-
Choose your Connection Name.
-
Enter Host.
-
Fill in the Port Number.
-
Enter your Username and Password
-
Click Test Connection to verify your connection is up to the task. If the connection succeeded, you can use this connection in Data Integration.
SSH tunnel
To connect via SSH Tunnel, refer to the SSH Tunnel using auto-generated public key topic.