16.10 - Hadoop Cloudera Connection Profiles - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K
When creating Hadoop Cloudera connection profiles, you can select different connection options based on your current system connection setup and your data transfer needs. You should select Kerberos Security Authentication if your Hadoop Cloudera system is configured within a Kerberos realm.
Connection Option Description
TDCH Select this option if you plan to use this connection for data transfers between the Cloudera System and a Teradata Database. Teradata Connector for Hadoop (TDCH) enables you to move data between Teradata Databases and Hadoop systems.

Manual metadata update for an Impala instance is required. Please refer to the REFRESH/INVALIDATE METADATA statements in the Cloudera Impala documentation.

TDCH is not available for Teradata Studio Express.

SQL-H Select this option if you plan to use this connection for data transfers from the Cloudera System to an Aster Database.

Manual metadata update for an Impala instance is required. Please refer to the REFRESH/INVALIDATE METADATA statements in the Cloudera Impala documentation.

SQL-H is not available for Teradata Studio Express.

Smart Loader

Select this option if you plan to use this connection to import data from text delimited files into a Hadoop System.

Impala Select this option if you plan to use this connection to access the Hadoop Cloudera System using SQL from the SQL Editor. This option uses the Hive Impala JDBC Driver to access your Hadoop System.
Presto Select this option if you plan to use this connection to access the Hadoop Cloudera System using SQL from the SQL Editor. This option uses the Presto JDBC Driver to access your Hadoop System.