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 |
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 |
DATABASE | Name of the Sybase ASE database. | Database_Name |
AUTHENTICATION METHOD | Authentication method for connecting HVR to Sybase ASE server. Available options are:
| 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. |