Hadoop Hortonworks Connection Profiles | Teradata Studio/Studio Express - Hadoop Hortonworks Connection Profiles - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
ztp1648839236373.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
Product Category
Teradata Tools and Utilities

You can select different connection options based on your current system connection setup and your data transfer needs. 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 Vantage. Teradata Connector for Hadoop (TDCH) enables you to move data between Vantage and Hadoop systems.

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 Hortonworks Hadoop System to an Aster Database.

  • SQL-H is not supported in Hadoop 3.0.1. Data transfer from Hadoop 3.0.1 to Aster will not work.
  • SQL-H is not supported in 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 Hive JDBC driver to access your Hadoop System.