Wiki Admin

Repository Database in Sybase ASE - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Repository Database in Sybase ASE - DSS 6 | Data Source Solutions Documentation

Repository Database in Sybase ASE

Since v6.1.5/4

Data Source Solutions DSS allows you to create a repository database in Sybase ASE. The Repository Database section in Capabilities (6.1.5) lists the supported Sybase ASE versions that can be used as a repository database.

Grants for Repository Database

The following grants are required for the repository database in Sybase ASE:

grant create table to <em>username</em>
grant create procedure to <em>username</em>

Repository Database Connection

This section describes the details required for connecting to the repository database in Sybase ASE:

Field Description Equivalent Location Property
SYBASE Directory path where the Sybase ASE database is installed. Sybase
SYBASE CT LIBRARY Directory path where the Sybase Open Client (CT library) is installed. Sybase_CT_Library
NODE

Hostname or IP-address of the server on which the Sybase ASE database is running.

This field is enabled only if NETWORK TRANSPORT SOURCE is set to Direct.		 Database_Host
PORT

Port number on which the Sybase ASE database server is expecting connections.

This field is enabled only if NETWORK TRANSPORT SOURCE is set to Direct.		 Database_Port
DATABASE Name of the Sybase ASE database. Database_Name
AUTHENTICATION METHOD

Authentication method for connecting DSS to Sybase ASE server.

Available options are:

  • User Name and Password default
  • Kerberos

For more information about using Kerberos authentication, see section Kerberos Authentication in Sybase ASE Requirements.

 Sybase_Authentication_Method
USER

Username for connecting DSS to the Sybase ASE database.

 Database_User
PASSWORD

Password for the USER

This field is enabled only if the AUTHENTICATION METHOD is set to User Name and Password.		 Database_Password
SECURITY MECHANISM

Name of the security mechanism that performs security services for this connection. Security mechanism names are defined in the Sybase libtcl.cfg configuration file.

If value is not entered in this field, the default mechanism defined in the libtcl.cfg file will be used.

This field is enabled only if AUTHENTICATION METHOD is set to Kerberos.		 Sybase_Kerberos_Security_Mechanism
SERVER PRINCIPAL

The Kerberos Service Principal Name (SPN) of the Sybase ASE server.

This field is enabled only if AUTHENTICATION METHOD is set to Kerberos.		 Sybase_Kerberos_Server_Principal
KEY TAB

Directory path where the Kerberos keytab file is located. This keytab file contains the security key for the specified USER.

This field is enabled only if AUTHENTICATION METHOD is set to Kerberos.		 Sybase_Kerberos_Keytab
SECURITY SERVICES

Kerberos security mechanism services. It only defines how the connection behaves.

  • Mutual Client/Server Authentication: Both DSS and the Sybase server are required to authenticate themselves.
  • Encrypted Connection: Enables encrypted connection between DSS and the Sybase server.
  • Data Integrity Checking: Enables data integrity checking.
  • Replay Transmission Detection: Enables data replay detection.
  • Data Out-Of-Sequence Detection: Enables out-of-sequence detection.
  • Data Origin Verification: Enables data origin stamping service.
  • Channel Binding: Enables channel binding.
The Kerberos security mechanism services options are displayed only if AUTHENTICATION METHOD is set to Kerberos. 		Sybase_Kerberos_Security_Services