Repository Database in SQL Serverlink
Fivetran HVR allows you to create repository database in SQL Server.
It is recommended to create a new database (schema) for HVR repository. If an existing database is to be used for HVR repository, then the HVR repository tables can be separated by creating a new database schema and associating it with HVR's user as follows:
create schema schemaname;
Grants for Repository Databaselink
The following grants are required for the repository database user in SQL Server:
grant create table to username; grant create procedure to username; grant select, insert, delete, update on schema::schemaname to username; grant control on schema::schemaname to username; alter user username with default_schema=schemaname;
Repository Database Connectionlink
This section describes the details required for connecting to the repository database in SQL Server:
Field | Description | Equivalent Hub Server 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:
| SqlServer_Server |
DATABASE | Name of the SQL Server database. | Database_Name |
USER | Username for connecting HVR to the SQL Server database.
| Database_User |
PASSWORD | Password for the USER. | Database_Password |
Advanced Settingslink
Field | Description | Equivalent Hub Server 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 |