Requirements for Azure SQL Data Warehouse

From HVR
Jump to: navigation, search

This section describes the requirements, access privileges, and other features of HVR when using Azure SQL Data Warehouse (DW) for replication. Azure SQL Data Warehouse is the Platform as a Service (PaaS) data warehouse of Microsoft's Azure Cloud Platform. HVR supports Azure SQL Data Warehouse through its regular SQL Server driver. For information about the capabilities supported by HVR on Azure SQL Data Warehouse, see Capabilities for Azure SQL Data Warehouse.

For information about compatibility and supported versions of Azure SQL Data Warehouse with HVR platforms, see Platform Compatibility Matrix.

Azure SQL DW
Capture Hub Integrate
Icon-No.png Icon-No.png Icon-Yes.png

ODBC Connection

HVR requires that the SQL Server Native Client 11.0 ODBC driver is installed on the machine from which HVR will connect to Azure SQL Data Warehouse.

Location Connection

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

SC-Hvr-Location AzureSQLDW.png
Field Description
Database Connection
Server The fully qualified domain name (FQDN) name of the Azure SQL Data Warehouse server.
Database The name of the Azure SQL Data Warehouse.
  Example: mytestdw
User The username to connect HVR to the Azure SQL Data Warehouse (Database).
  Example: hvruser
Password The password of the User to connect HVR to the Azure SQL Data Warehouse (Database).
ODBC Driver The user defined (installed) ODBC driver to connect HVR to the Azure SQL Data Warehouse.

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