Teradata
The Teradata connector in iceDQ is a software adapter allows iceDQ to connect to Teradata databases. It provides a standard interface for accessing Teradata data, making it easy to integrate Teradata with iceDQ system application.
Compatible Engines
The Teradata connector is supported by the following engines:
- Standard
- High Throughput
Prerequisites
The following prerequisites must be met for a user to create and test a successful connection.
- The Teradata should be accessible from the iceDQ instance
- Users should have the credentials to access the database
- Teradata JDBC version should be 20.0 or above versions
Authentication Mechanism
Currently, the following authentication mechanism is supported for Teradata connection.
- Username and Password
Connection
Use one or more properties from the below table to create a valid Teradata connection.
| Property | Description | Note |
|---|---|---|
| Custom JDBC URL | Connect using Full JDBC URL | View the URL Format |
| Host | Server hostname | |
| Port | Database port | Default is 1025 |
| Database | Default database name | User can access other databases with FQN in the SQL |
| Username | Database username | |
| Password | Password for the username |
URL Format
jdbc:teradata://[host]/DBS_PORT=[port],DATABASE=[database]
Properties
Visit Teradata's documentation to find additional connection properties for JDBC URL.
| Property | Description | Note |
|---|---|---|
| USE_SSL | Use SSL to connect Teradata Database | Default value is False |
| SOCKET_TIMEOUT | Connection established before timeout | Default value is 30 seconds |
| IDLE_TIMEOUT | Idle Timeout before closing the connection | Default is 0 |
Unsupported Datatypes
The following datatypes are not supported.
- XML
- BLOB
- CLOB
- INTERVAL
- NATIVE_UNICODE.