Modify JDBC Connection Properties | Teradata Studio/Studio Express - Modifying JDBC Connection Properties - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Teradata Studio
Release Number
September 2022
English (United States)
Last Update
Product Category
Teradata Tools and Utilities
  1. In the Navigator or Data Source Explorer, right-click a connection profile and select Properties.
  2. Select Teradata JDBC Connection.
  3. Do one of the following:
    Option Action
    Add a connection property
    1. Click Add next to JDBC Connection Properties.
    2. From the list of Property Values, select the property value.

      If the value requires user input, a dialog appears. Default connection properties are supplied for new connection profiles. To override these defaults, click Save Properties. Future definitions use the saved properties.

    3. At Property Value, type a value of no more than 30 characters.
    4. Click OK.

      If the property already exists in the list, a confirmation dialog appears.

    5. Click OK to replace the JDBC property in the list.
    Remove a connection property
    1. Select the connection property in JDBC Connection Properties.
    2. Click Remove.

      To clear the entire list of connection properties, click Clear All.

  4. Click Reset to Defaults to set the properties to the default values.
  5. To cache schema, use metadataCache Properties.
    You must enter a user name and password in order to configure the cache properties. To delete all schema cache files for the connection profile, select Delete Cache Files.
  6. Repeat these steps to add multiple properties.
  7. To test the connection, click Test Connection.
    A message box appears stating the ping either succeeded or failed. Click OK to close the message box.
  8. Select Connect every time the workbench is started to automatically connect to the database when the application is started.
  9. Click Finish to close the wizard and connect to your database.