- In the Navigator or Data Source Explorer, right-click a connection profile and select Properties.
- Select Teradata JDBC Connection.
-
Do one of the following:
Option Action Add a connection property - Click Add next to JDBC Connection Properties.
- 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.
- At Property Value, type a value of no more than 30 characters.
- Click OK.
If the property already exists in the list, a confirmation dialog appears.
- Click OK to replace the JDBC property in the list.
Remove a connection property - Select the connection property in JDBC Connection Properties.
- Click Remove.
To clear the entire list of connection properties, click Clear All.
- Click Reset to Defaults to set the properties to the default values.
-
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.
- Repeat these steps to add multiple properties.
-
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.
- Select Connect every time the workbench is started to automatically connect to the database when the application is started.
- Click Finish to close the wizard and connect to your database.