Prerequisites for Teradata Connector
The prerequisites for using the Cloudera Connector Powered by Teradata are:
- To download the connector, you must have an active subscription agreement along with the required authentication credentials (namely, the username and password).
The authentication credentials are provided in an email sent to the customer account from Cloudera when a new license is issued. If you do not have the authentication credentials, contact your account representative.
- You must have a functioning Cloudera installation, either CDP or CDH, including Sqoop components.
- Depending on how Sqoop is installed, you may need administrative privileges to create or modify configuration files.
- The Teradata connector uses catalog tables and views to look up metadata information. Therefore, the user making the connection must have the SELECT
privilege on the DBC database. Check with your Teradata administrators or operators if you are not sure whether you have the required privileges. You must have
SELECT privileges on at least one of the following DBC database object types:
- DBC.columns
- DBC.databases
- DBC.tables
- DBC.indices
- Depending on the input method used, the Teradata connector might need to create temporary tables or temporary views to import data.
Check with your Teradata administrators or operators to determine if you have the required privileges.
- The Cloudera Connector Powered by Teradata requires the following additional permissions to use the following *.fastload data methods.
- DBC.table_levelconstraints
- DBC.triggers
- DBC.tvm
- DBC.dbase
- DBC.referencingtbls
Cloudera Connector powered by Teradata version 1.8.1c7
- Teradata versions:
- Teradata Database 15.10
- Teradata Database 16.00
- Teradata Database 16.10
- Teradata Database 16.20
- Teradata Database 17.00
- Teradata Database 17.05
- CDP Public Cloud 7.2.9 and later
- CDP Private Cloud 7.1.7 and later