Requirements for Azure Synapse Analytics

Last updated on Mar 09, 2021

Contents

Azure SQL DW
Capture Hub Integrate

This section describes the requirements, access privileges, and other features of HVR when using Azure Synapse Analytics (formerly Azure SQL Data Warehouse) for replication. Azure Synapse Analytics is the Platform as a Service (PaaS) data warehouse and big data analytics of Microsoft's Azure Cloud Platform. HVR supports Azure Synapse Analytics through its regular SQL Server driver. For information about compatibility and supported versions of Azure Synapse Analytics with HVR platforms, see Platform Compatibility Matrix.

For information about the Capabilities supported by HVR on Azure Synapse Analytics, see Capabilities for Azure Synapse Analytics.

For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.

ODBC Connection

Microsoft SQL Server Native Client must be installed on the machine from which HVR connects to Azure Synapse. For more information about downloading and installing SQL Server Native Client, refer to Microsoft documentation.

For information about the supported ODBC driver version, refer to the HVR release notes (hvr.rel) available in hvr_home directory or the download page.

Location Connection

This section lists and describes the connection details required for creating Azure Synapse location in HVR.

Field

Description

Database Connection

Server

The fully qualified domain name (FQDN) name of the Azure Synapse server.
Example: tcp:hvrdw.database.windows.net

Database

The name of the Azure Synapse database.
Example: mytestdw

User

The username to connect HVR to the Azure Synapse Database.
Example: hvruser

Password

The password of the User to connect HVR to the Azure Synapse Database.

ODBC Driver

The user defined (installed) ODBC driver to connect HVR to the Azure Synapse.

Integrate and Refresh

HVR uses the following interfaces to write data into an SQL Server location:

  • SQL Server ODBC driver, used to perform continuous Integrate and row-wise Refresh
  • SQL Server BCP interface, used for copying data into database tables during bulk Refresh and loading data into burst tables during Integrate with /Burst.

Grants for Compare, Refresh and Integrate

The HVR User requires the following privileges:

 grant create table to hvr_user
 grant select, insert, update, delete on replicated tables to hvr_user

If the HVR User needs to bulk refresh or alter tables which are in another schema (using action TableProperties /Schema=myschema) then the following grants are needed:

 grant control on schema :: myschema to hvr_user

When HVR Refresh is used to create the target tables, the following is also needed:

 grant create table on schema :: myschema to hvr_user

HVR's internal tables, like burst and state-tables, will be created in the user's default_schema. The default_schema can be changed using:

 alter user hvr_user with default_schema = myschema