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 SOURCESince 6.1.5/7 | Source of the network transport information required to connect HVR to the Sybase ASE database server. Available options are:
| Sybase_Net_Trans_Source |
ASE SERVER NAMESince 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 SSLSince 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 NAMESince 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:
| 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. You can choose one or more of the following options:
| Sybase_Kerberos_Security_Services |