Location Connection for Azure Synapse Analytics
This section describes the connection details required for creating Azure Synapse Analytics location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Azure Synapse Analytics location, see Azure Synapse Analytics 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 | Fully qualified domain name (FQDN) of the Azure Synapse Analytics server. The format for this field is:
| SqlServer_Server |
| DATABASE | Name of the database in Azure Synapse Analytics. Example: mytestdw | Database_Name |
| USER | Username for connecting HVR to the Azure Synapse database. Example: hvruser | 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 |
| 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 Azure Synapse Analytics. | ODBC_Driver |