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.
- 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. |
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. |