15.12 - Aster Database Connection Properties - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
15.12
created_date
August 2016
category
User Guide
featnum
B035-2042-086K

The Aster Database Connection Properties dialog details the JDBC information required to connect to an instance of an Aster database. The dialog shows the connection properties that make up the Connection Profile definition.

Properties include:
  • Database server name, port, and name of database to which to connect
  • User name and password required to access the Aster database defined in the profile
  • JDBC connection properties
  • Options for caching database files and deleting cache files
  • Option to create an SSO (Single Sign On) connection and KDC (Key Distribution Center), domain name, service name, and location of the JAAS (Java Authentication and Authorization Service) configuration file required to access an SSO-enabled system.

Connection Properties

Option Description
Select a driver from the drop-down The Aster Embedded JDBC Driver template is selected as the default JDBC driver template.
Set Up SSO Connection Enables an SSO connection, which is disabled by default. Checking this option disables the User Name and Password fields.
Database Server Name Name of the database server that hosts the Aster Database.
User Name Aster database user name used to connect to the database server.
Password Password required to access the Aster database defined in this Connection Profile.
Port Number Port number to use for the Aster database server.
Database Name Name of the default database. Your connection requires that a default database be set when a user logs on.
Save Password Saves a password.

If this option is not selected, you are required to enter a password each time a connection to the database is made. The password you entered in the Password field is valid for each workbench session and is not affected by this check box.

KDC Key Distribution Center required to access an SSO-enabled Aster database server. KDC is disabled by default and is enabled when Set Up SSO Connection is checked.
Domain Name Domain name required to access an SSO-enabled Aster database server. Domain name is disabled by default and is enabled when Set Up SSO Connection is checked.
Service Name Service name required to access an SSO-enabled Aster database server. Service name is disabled by default and is enabled when Set Up SSO Connection is checked.
JAAS Login Configuration The location of the JAAS Login Configuration file required to access an SSO-enabled Aster database server. JAAS Login Configuration is disabled by default and is enabled when Set Up SSO Connection is checked.
If you are connected to the Connection Profile and change the connection properties, when you click OK, you are asked if you want to reconnect to the server.

JDBC Connection Properties

The JDBC Connection Profile list is blank until you add a property. Use the buttons on the right-side to add, remove, clear, save, and reset properties in the list.

Property Actions

You can perform these actions for the JDBC connection properties you define.

Button Description
Add Adds a JDBC connection properties to the list of JDBC Connection Properties.
Remove Removes properties from the list of JDBC Connection Properties.
Clear All Clears the entire list of connection properties.
Save Properties Saves the properties listed in the JDBC Connection Properties list. The Save Properties feature overrides the default connection properties supplied for a new connection profile and saves the list you created.
Reset to Defaults Sets properties to the default values. If you have saved your properties and overridden the system defaults, the Save Properties values are used as your default values.
Cache Properties Configures schema cache properties.
Delete Cache Files Deletes cached files.

Connection Actions

You can verify that the information defined in the Connection Profile connects to the desired Aster database.

Option Description
Test Connection Tests the connection.