Create a Teradata Connection Profile | Teradata Studio/Studio Express - Creating a Teradata Connection Profile - 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
The Connection Profile contains the JDBC information required to connect to an instance of Vantage.
  1. In the Data Source Explorer or Navigator, click "" .
  2. Do the following:
    1. Select Connection Profile Types > Teradata.
    2. Type a Name and optionally a Description to identify the connection profile.
    3. Click Next.
  3. Select a driver from Select a driver from the drop-down or create one:
    1. Click "" .
    2. Select the External JDBC Driver template for your system type.
    3. In Driver name, enter a unique name for the driver definition.
    4. On the JAR List tab, click Add JAR/Zip to add the list of JDBC driver JARs.
    5. On the Properties tab, edit the JDBC driver properties.
    6. Click OK.
  4. In Database Server Name, type the host name running Vantage.
  5. In User Name[Domain], type the user name for the connection.
    If you are connecting through Kerberos authentication, include the Domain name.
  6. In Password, type the password for the connection.
  7. If you are using advanced authentication, select the Authentication Mechanism.
  8. [Optional] Set the Database if your connection requires that a default database be set at logon.
  9. Select Save Password to save the password.
    The password is valid for the workbench session.
  10. 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 CHARSET, ENCRYPTDATA, and TMODE name value pair for a session.

    Teradata JDBC Driver does support Data Encryption on all data which passes through including user logon credentials/passwords.

    By default, Studio sets the Data Encryption to ON for Teradata connections. Users may experience significant performance issues using this setting as Encryption of all data traffic places more overhead to the application.

    For instructions on adding a JDBC property, see Adding a JDBC Property.

  11. [Optional] Click Cache Properties to open the Database Cache Properties dialog and select the databases to cache.
    See Database Cache for more information.
  12. [Optional] Click Delete Cache Files and confirm to delete cache files.
  13. 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.
  14. Click Next to view the Summary information.
  15. Click Finish to create the connection profile.