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 theDBC
database. Check with your Teradata administrators or operators if you are not sure whether you have the required privileges. You must haveSELECT
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
Cloudera Connector powered by Teradata version 1.8c7
- Teradata versions:
- Teradata Database 15.10
- Teradata Database 16.00
- Teradata Database 16.10
- Teradata Database 16.20
- Teradata Database 17.00
- CDP Public Cloud 7.2.0 - 7.2.8
- CDP Private Cloud 7.1.0 - 7.1.6
Cloudera Connector powered by Teradata version 1.7c6
- Teradata 13.00 and higher
- CDH 6.0 and higher
- Sqoop 1.4 and higher, but not compatible with Sqoop2