Wiki Admin

Azure SQL Database as Source - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Azure SQL Database as Source - DSS 6 | Data Source Solutions Documentation

Azure SQL Database as Source

<b>Since</b> v6.1.0/3

Since 6.1.5/4, support for Capture from the Azure SQL Database has been deprecated. However, you can still configure it using the CLI or REST API, but not via the DSS UI.

Support for Capture from the Azure SQL Database will be removed entirely in one of the future DSS 6 releases.

Capture

Data Source Solutions DSS allows you to Capture changes from Azure SQL Database. DSS uses SQL Server ODBC driver to capture changes from an Azure SQL Database location. This section describes the configuration requirements for capturing changes from Azure SQL Database location.

Table Types

DSS supports capture from the following table types in Azure SQL Database:

  • clustered (row/page compressed and uncompressed)
  • heap (row/page compressed and uncompressed)

DSS does not support capture from memory optimized tables and temporal tables.

Capture Methods

DSS supports only the following method for capturing (Capture) changes from Azure SQL Database:

Trigger-based Capture

In this capture method (Capture_Method=DB_TRIGGER), DSS capture changes through DBMS triggers generated by DSS.

Grants for Trigger-based Capture

This section lists the grants required for capturing changes from Azure SQL Database using database triggers.

  • The DSS database User must be a database owner (db_owner role).

Compare and Refresh from Azure SQL Database

DSS allows you to perform only Compare and Refresh from Azure SQL Database (without using Capture). This section describes the configuration requirements for performing only Compare and Refresh from Azure SQL Database.

Grants for Compare and Refresh from Azure SQL Database

This section lists the grants required for performing only Compare and Refresh from Azure SQL Database. Based on your requirement, the DSS database User must be granted either of the permissions listed below.

  • DbOwner
    The DSS database User must be granted db_owner role for the source database.

  • Minimal
    In this permission model, the DSS database User does not need to be a database owner.

If the DSS database User needs to select from tables in another schema (for example if action TableProperties is defined with parameter Schema), then the following <b>select</b> privileges should be granted.

grant select to <em>username</em>; -- Let DSS read all tables

grant select on schema::dbo to <em>username</em>; -- Let DSS only read DBO tables