Location Connection for Sybase ASE

This section lists and describes the connection details required for creating Sybase ASE location in Fivetran HVR. 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 HVR 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 HVR'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 HVR 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, HVR 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 HVR. 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 HVR 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 HVR 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. The Kerberos security mechanism services options are displayed only if AUTHENTICATION METHOD is set to KERBEROS.	Sybase_Kerberos_Security_Services
Mutual Client/Server Authentication	Both HVR and the Sybase server are required to authenticate themselves.
Encrypted Connection	Enables encrypted connection between HVR 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.