16.00 - Creating a Teradata Connection Profile - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide

The Connection Profile contains the JDBC information required to connect to an instance of a Teradata Database.

  1. In the Data Source Explorer or Navigator, click to create a new connection.
  2. Select Teradata from Connection Profile Types.
  3. At Name, type a name to identify the connection profile.
  4. [Optional] At Description, type a description of the connection profile.
  5. Click Next.
  6. Select a driver from Select a driver from the drop-down. The Teradata Embedded JDBC Driver template is selected as the default JDBC driver template. If you need to create a new Teradata JDBC driver template, click .
  7. At Database Server Name, type the host name running the Teradata Database.
  8. At User Name[Domain], type the user name for the connection. If you are connecting through Kerberos authentication, include the Domain name.
  9. At Password, type the password for the connection.
  10. If you are using advanced authentication, such as LDAP or Kerberos, select the Authentication Mechanism. TDNEGO is also supported. If you did not choose LDAP, Kerberos, or TDNEGO, the default protected logon is used.
  11. [Optional] Set the Database if your connection requires that a default database be set at logon.
  12. Select Save Password to save the password. The password is valid for the workbench session.
  13. In JDBC Connection Properties, accept the default properties or add and remove JDBC connection properties to specify the connection details for the profile. The default JDBC connection properties include a QueryBand string that contains query band name value pairs (separated by semicolons) for a session.
  14. [Optional] Click Cache Properties to open the Database Cache Properties dialog and select the databases to cache.
  15. [Optional] Click Delete Cache Files and confirm to delete cache files.
  16. 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.
  17. Click Next to view the Summary information.
  18. Click Finish to create the connection profile.