Repository Database in Sybase ASE

Since v6.1.5/4

Fivetran HVR 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 username
grant create procedure to username

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 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.	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 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. The Kerberos security mechanism services options are displayed only if AUTHENTICATION METHOD is set to Kerberos.	Sybase_Kerberos_Security_Services