16.00 - Aster Connection Properties - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K

The Aster Database Connection Properties and Aster AX Database Connection Properties dialogs detail the JDBC information required to connect to an instance of an Aster Database or Aster Execution Engine. The dialogs show 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 or Aster Execution Engine instance 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 Default template is selected as the default JDBC driver template for an Aster Database connection, and the Aster AX Embedded JDBC Driver Default template is selected as the default for an Aster Execution Engine instance connection.
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 or Aster Execution Engine instance.
User Name Aster user name used to connect to the database server.
Password Password required to access the Aster Database or Aster Execution Engine instance defined in this Connection Profile.
Port Number Port number to use for the Aster 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 results in a successful connection.

Option Description
Test Connection Tests the connection.