16.00 - Editing JDBC Connection Properties - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
You can add or remove connection properties to the list of JDBC Connection Properties.
  1. Click Add to display a dialog with the list of JDBC properties.
  2. Select the property you want to add. To remove a property, select it and click Remove. To clear the entire list of connection properties click Clear All.
  3. 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.
  4. Type in a Property Value of no more than 30 characters.
  5. Click OK to save the JDBC property. If the property already exists in the list, a confirmation dialog appears.
  6. Click OK to replace the JDBC property in the list.
  7. Click Reset to Defaults to set the properties to the default values.
  8. 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
  9. Repeat these steps to add multiple properties.
  10. 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.
  11. Select Connect every time the workbench is started to automatically connect to the database when the application is started.
  12. Click Finish to close the wizard and connect to your database.