Teradata
Last updated: 9/18/2026Teradata is available as a target only in Qlik Talend Cloud Replicate projects. The connection uses the Teradata Parallel Transporter (TPT) API for data loading and ODBC for metadata queries, DDL requests, and information from Teradata error tables.
Set up the connection
Before you create a replication task, create and test a connection to the Teradata target.
- In Connections, click Create connection.
- Select the Teradata target connector.
- Enter the connection properties described in Teradata connection properties.
- Click Test connection and resolve any reported errors.
- Save the connection.
Teradata connection properties
Configure the following properties for the Teradata target connection:
| Section | Property | Description |
|---|---|---|
| Data target | Data gateway (required) | Select the data gateway that can reach the Teradata server and has the required Teradata client components installed. |
| Connection properties | Teradata server(s) (required) | Enter the Teradata server name or IP address. Ensure that the server is reachable from the selected data gateway. |
| Account properties | User (required) | Enter the Teradata database user name. This is a database credential, not the account string. |
| Password (required) | Enter the password for the Teradata server database user. This is a database credential, not the account string. | |
| Account string | Enter the account string that the Teradata database administrator assigned to the user. This is the database server login account and is distinct from the User and Password credentials. | |
| Database properties | Enter database name manually | Select this option to enter the database name. |
| Default database (required) | Enter the Teradata database where data is replicated. The database must be accessible to the specified user. | |
| Load databases | Click to discover databases available to the specified user. The list depends on successful connectivity and the user's database permissions. | |
| Additional connection properties | ODBC properties | Enter additional ODBC connection properties as Name and Value pairs. Confirm property names and values with your Teradata or ODBC administrator. |
Prerequisites
Prepare the Teradata environment and access required by the connection before you create the target connection.
- Ensure that the Teradata server is installed in your network and reachable from the computer running the selected data gateway.
- Install and configure the Teradata ODBC driver and required Teradata client components on the data gateway. Do not assume that a driver installed on another computer is available to the gateway.
- Ask a Teradata database administrator to create or identify a database user and provide the user's password and account string, when required.
If you are adapting the Teradata target capability to your environment, ask a Teradata database administrator to verify whether the following privileges are required for your task. The grants apply to the target database unless noted otherwise; they are not necessarily the minimum permissions for every Qlik Talend Cloud task:
GRANT SELECT ON <database>GRANT INSERT ON <database>GRANT DELETE ON <database>GRANT UPDATE ON <database>GRANT EXECUTE ON <database>GRANT EXECUTE FUNCTION ON <database>GRANT EXECUTE PROCEDURE ON <database>GRANT CREATE TABLE ON <database>GRANT DROP TABLE ON <database>GRANT CREATE VIEW ON <database>GRANT DROP VIEW ON <database>GRANT NONTEMPORAL ON <database>GRANT CHECKPOINT ON <database>
For a source that supports the Stream operator, also ask the DBA to verify the following grant when TPT Operator is set to Stream:
GRANT CREATE MACRO ON <database>
Troubleshoot connection errors
If the connection test fails, review the reported error and check the following items before testing the connection again:
- Gateway or network: Confirm that the selected data gateway is running and can reach the Teradata server. Check the server name or IP address and any network rules between the gateway and server.
- Driver or client: Confirm that the Teradata ODBC driver and required client components are installed and configured on the selected gateway. A driver installed on the local computer is not used by a remote gateway.
- Credentials or permissions: Confirm the case-sensitive User and Password, the optional Account string, and the required database grants with a DBA.
- Database discovery: If Load databases returns no databases or an error, first test connectivity and then confirm that the user can discover and access the databases. You can enter a known database with Enter database name manually if appropriate.
- ODBC properties: Check every Name and Value pair for spelling, supported values, and conflicts with the driver configuration. Remove an optional property that causes the connection test to fail, or ask an ODBC administrator to verify it.
Configure task settings
Configure these settings in a Replicate task under Data uploading.
Basic settings
- TPT Operator: Select Load or Stream. The default is Stream.
- JSON Format: Select Text, BSON, or UBJSON. The default is Text.
TPT Operator modes
The TPT Operator determines how data is written to Teradata.
-
Stream (default): Uses the Teradata TPump protocol for high-speed DML transactions in near-real-time. Tables can be queried while DML operations occur. This mode is less restrictive for ongoing change processing. When the source supports this operator, the database user may also require the
CREATE MACROprivilege. -
Load: Uses the Teradata FastLoad protocol to load a large volume of data into an empty table. The target table must be empty and cannot have secondary indexes. Use this mode only when those restrictions fit the task's processing requirements.
JSON Format option
Specify how JSON columns are stored in Teradata:
- Text (default): Stores JSON data as text.
- BSON: Stores JSON data in BSON format.
- UBJSON: Stores JSON data in UBJSON format.
Advanced TPT attributes
Under Advanced TPT Attributes, configure the following options:
- Buffer size (KB): Set the output buffer size used to send load parcels to Teradata. Enter a value from 1 through 64.
- Buffers: Set the number of request buffers used. Enter a value of 2 or higher.
- Explicit Session Range: Set the minimum and maximum number of sessions that can log on to Teradata. Enter values from 1 through 65,535.
- Dynamic statement packing: Select this option to let the stream driver determine the maximum possible packing for the current Stream job.
- Statement packing: Set the number of statements packed into a multiple-statement request for Stream mode. Enter a value from 2 through 600. This option is available when Dynamic statement packing is not selected.
Limitations and considerations
- The available replication modes are Full load, Apply changes, and Store changes.
- For tasks that use Apply changes or Store changes, DDL operations and automatic schema evolution are not supported. This limitation does not apply to a Full load-only task.
- For Load mode, the target table must be empty and must not have secondary indexes. Select Stream when the task requires ongoing DML processing or concurrent table queries.