Requirements for Azure SQL Data Warehouse
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.
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.
This section lists and describes the connection details required for creating Azure SQL Data Warehouse location in HVR.
|Server||The fully qualified domain name (FQDN) name of the Azure SQL Data Warehouse server. |
|Database|| The name of the Azure SQL Data Warehouse. |
|User||The username to connect HVR to the Azure SQL Data Warehouse (Database). |
|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