Installing a Teradata Connector
- Install the Sqoop connector by opening the
distribution archive in a convenient location such as /usr/lib. Opening the distribution
creates a directory that contains the jar file of the compiled version of the
connector. Note the path to this jar file. The directory that is created when the
file is expanded varies according to which connector you are using. Examples of
typical resulting paths include:
- Cloudera Connector for Teradata 1.0.5: /usr/lib/sqoop-td-connector-1.0.5/sqoop-td-connector-1.0.5.jar
- Cloudera Connector for Teradata 1.1.1: /usr/lib/sqoop-td-connector-1.1.1/sqoop-td-connector-1.1.1.jar
- Cloudera Connector Powered by Teradata 1.0.0: /usr/lib/sqoop-connector-teradata-1.0.0/sqoop-connector-teradata-1.0.0.jar
- Copy the Teradata JDBC drivers (terajdbc4.jar and tdgssconfig.jar) to the lib directory of Sqoop installation. You can obtain these drivers from the Teradata download website: http://downloads.teradata.com/download/connectivity/jdbc-driver. Without these drivers, the connector will not function correctly.
- Confirm that the managers.d directory exixsts in the Sqoop configuration directory.
Note: Depending on how Sqoop is installed, its configuration directory may be in /etc/sqoop/conf, /usr/lib/sqoop/conf, or elsewhere if Sqoop was installed using the tar-ball distribution.If the managers.d directory does not exist, create it.
- Create a text file in the managers.d directory. Give the text file some descriptive name such as cldra_td_connector.
- The cldra_td_connector file must have the connector class name followed by
the complete path to the directory where the connector jar is located. For example, for the Cloudera Connector for Teradata 1.0.5:
com.cloudera.sqoop.manager.TeradataManagerFactory= \ /usr/lib/sqoop-td-connector-1.0.5/sqoop-td-connector-1.0.5.jarFor example, for the Cloudera Connector for Teradata 1.1.1:
com.cloudera.sqoop.manager.TeradataManagerFactory= \ /usr/lib/sqoop-td-connector-1.1.1/sqoop-td-connector-1.1.1.jarFor example, for the Cloudera Connector powered by Teradata 1.0.0
com.cloudera.connector.teradata.TeradataManagerFactory= \ /usr/lib/sqoop-connector-teradata-1.0.0/sqoop-connector-teradata-1.0.0.jarNote: The preceding command is shown on two lines, but this must be entered in a single line.The TeradataManagerFactory acts as a single point of delegation for invoking the connector bundled with this distribution. An alternate way to specify TeradataManagerFactory is to add the following inside a sqoop-site.xml file, which must be inside a classpath directory:
<configuration> <property> <name>sqoop.connection.factories</name> <value>com.cloudera.sqoop.manager.TeradataManagerFactory</value> </property> </configuration>
This is the way to configure a Sqoop action to use the Teradata connector inside Oozie.
Note: If you are using a Cloudera Connector for Teradata, you may need to change the value of the mapred.task.timeout property to be greater than the default of 10 minutes. The mapred.task.timeout property determines how long to wait before killing an unresponsive task, and mapred tasks may not respond within the default 10 minute limit while a staging table is being used.
|<< Previous: Choosing a Teradata Connector||Next: Using Teradata Connectors >>|