Location Connection for SQL Server

This section describes the connection details required for creating SQL Server location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating SQL Server location, see SQL Server 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
SERVER	Name of the server (host) on which SQL Server is running and the Port number or the instance name of SQL Server. The following formats are supported for this field: server_name : Specify only the server name and HVR will automatically use the default port to connect to the server on which SQL Server is running. Example: myserver server_name,port_number : Specify the server name and port number separated by a comma (,) to connect to the server on which SQL Server is running. If the HVR version is 6.1.5/8 (or older) or when using a MSODBC driver older than 17.8, this format is required when using custom port for connection or when SQL Server Native Replicator Connection is defined. Example: myserver,1435 server_name\server_instance_name : Specify the server name and server instance name separated by a backslash (\) to connect to the server on which SQL Server is running. This format is not supported on Linux. Example: myserver\HVR6048	SqlServer_Server
DATABASE	Name of the SQL Server database.	Database_Name
USER	Username for connecting HVR to the SQL Server database. The login/user account used for connecting HVR to SQL Server database engine should be defined with SQL Server Authentication or Windows Authentication. If Windows Authentication is used for connecting to SQL Server database, the USER and PASSWORD field should be left blank (empty).	Database_User
PASSWORD	Password for the USER.	Database_Password

Advanced Settings

Field	Description	Equivalent Location Property
LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH	Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system. For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib.	ODBC_DM_Lib_Path
LINUX / UNIX ODBCSYSINI	Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system. For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc.	ODBC_Sysini
ODBC DRIVER	Name of the user defined (installed) ODBC driver used for connecting HVR to the SQL Server database. It is recommended to leave this field empty, HVR will automatically load the correct driver for your current platform. Otherwise, select one of the available SQL Server Native Client options.	ODBC_Driver
SQL Server Native Replicator Connection	If selected, disables the firing of database triggers, foreign key constraints and check constraints during integration if those objects were selected with not for replication. This is done by connecting to the database with the SQL Server replication connection capability. If the HVR version is 6.1.5/8 (or older) or when using a MSODBC driver older than 17.8, when this field is selected, the database connection string format in SERVER must be server_name,port_number, the other two formats of the connection string are not supported. This port_number must be configured in the Network Configuration section of the SQL Server Configuration Manager. If the HVR version is 6.1.5/8 (or older) or when using a MSODBC driver older than 17.8, when this field is selected, encryption of the ODBC connection is not supported.	SqlServer_Native_Replicator_Connection