Creating Hadoop Hortonworks Connection Profiles Using Knox Gateway - Teradata Studio

1. In the Data Source Explorer or Navigator, click to create a new connection.
2. Select Hadoop Hortonwords from Connection Profile Types.
3. At Name, type a name to identify the connection profile.
4. [Optional] At Description, type a description of this Connection Profile.
5. Click Next.
6. Select Knox Gateway.
7. [Optional - not available in Studio Express] Select these additional connection options if needed:

   Option	Description
   TDCH	Transfer data between Teradata Databases and Hadoop systems.
   SQL-H	Transfer data from the Hortonworks Hadoop system to an Aster Database.

8. Specify when to connect :

   Option	Description
   Connect when the wizard completes	Connect to the database when you complete the profile.
   Connect every time the workbench is started	Connect to this database each time you launch the workbench.

9. Click Next.
10. Enter the credentials required to access the Knox connection:
    1. At Gateway Host, type the host name.
    2. At Gateway Port Number, type the port number for the host.
    3. At Cluster Name, type the cluster name.
    4. At Gateway User Name, type the user name for the Knox Gateway.
    5. [Optional] In Gateway Password, type the password for the Knox Gateway.
    6. Select Save Password to save the password.
11. Click Next to view the Summary information.
12. Click Finish to create the connection profile.