Wiki Admin

Location Connection for Sybase ASE - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Location Connection for Sybase ASE - DSS 6 | Data Source Solutions Documentation

Location Connection for Sybase ASE

This section lists and describes the connection details required for creating Sybase ASE location in Data Source Solutions DSS. For information about the pre-requisites, access privileges, and other configuration requirements for creating Sybase ASE location, see Sybase ASE Requirements.

If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.

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
NETWORK TRANSPORT SOURCE
Since 6.1.5/7		 Source of the network transport information required to connect DSS to the Sybase ASE database server.
Available options are:
  • Interfaces File: Use the SAP Open Client’s interfaces file to get network transport information.
  • Direct: Use the network transport information specified directly in the DSS's location definition for Sybase ASE.
 Sybase_Net_Trans_Source
ASE SERVER NAME
Since 6.1.5/7		 Name of the Sybase ASE database server.
The interfaces file contains an entry for each SAP Sybase server on the network, identified by a server name. It enables the Open Client library used by DSS to locate the correct entry within the file.
This field is enabled only if NETWORK TRANSPORT SOURCE is set to Interfaces File. 		Sybase_ASE_Server_Name
NODE Hostname or IP-address of the server on which the Sybase ASE database is running. Database_Host
PORT Port number on which the Sybase ASE database server is expecting connections. Database_Port
Enable SSL
Since 6.1.5/7		 Enable/disable (one-way) SSL. If enabled, DSS authenticates the Sybase ASE database server by validating the SSL certificate shared by the Sybase ASE database server.
This field is enabled only if NETWORK TRANSPORT SOURCE is set to Direct.

For Interfaces File, the SSL connectivity requirement must be specified in the interfaces file used by DSS. Additionally, the Sybase runtime environment must include the necessary trusted root files, certificates, and keys. For more information, refer to the SAP SSL documentation.
SSL COMMON NAME
Since 6.1.5/7		 ASE server name for SSL certificate validation.
The name specified in this field should match the Sybase ASE database server name as specified in the command used to start ASE. For more information, see section Common Name Validation in an SDC Environment in SAP documentation.
This field is enabled only if Enable SSL is selected. 		Sybase_SSL_Common_Name
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 Passworddefault
  • 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 (mentioned in the DATABASE field).

This field is enabled only if the AUTHENTICATION METHOD is set to User Name and Password.		 Database_User
PASSWORD Password of the USER. 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 .

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. You can choose one or more of the following options:

  • 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