Hadoop Hortonworks Connection Profiles - Teradata Studio

Teradata Studio Express User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cxo1484765174902.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities
When creating Hadoop Hortonworks 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 Hortonworks system is configured within a Kerberos realm.
Connection Option Description
Knox Gateway Select this option if you currently connect to your Hortonworks Hadoop System through a Knox Gateway. The Apache Knox Gateway is a REST API gateway for interacting with Hadoop clusters. See Creating a Hortonworks Self-Signed Certificate for instructions about retrieving and installing certificate information.
TDCH Select this option if you plan to use this connection for data transfers between the Hortonworks Hadoop System and a Teradata Database. Teradata Connector for Hadoop (TDCH) enables you to move data between Teradata Databases and Hadoop systems.
TDCH is not available for Teradata Studio Express.
TDCH access is not supported if Kerberos authentication is selected.
SQL-H Select this option if you plan to use this connection for data transfers from the Hortonworks Hadoop System to an Aster Database.

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.

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