Azure SQL Managed Instance Requirements

This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using Azure SQL Managed Instance for replication.

Supported Platforms

• Learn about the Azure SQL Managed Instance versions compatible with DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Supported Capabilities

• Discover what DSS offers for Azure SQL Managed Instance on our Capabilities for Azure SQL Managed Instance page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Data Management

• Learn how DSS maps data types between source and target DBMSes or file systems on the Data Type Mapping page.

ODBC Connection

Microsoft SQL Server Native Client ODBC driver must be installed on the machine from which DSS connects to Azure SQL Managed Instance. For more information about downloading and installing SQL Server Native Client, refer to Microsoft documentation.

DSS uses the SQL Server Native Client ODBC driver to connect, read and write data into Azure SQL Managed Instance during Capture, Continuous Integrate, and Row-wise Refresh. The connection to the Azure SQL Managed Instance is encrypted by default (DSS will always add the “ENCRYPT=YES” to connection string for any Azure SQL connection).

Authentication Methods

DSS supports the following authentication methods for connecting to Azure SQL Managed Instance databases:

• User and Password: Use SQL authentication with a username and password to connect to Azure SQL Managed Instance. The location properties required for this authentication method are Database_User and Database_Password.

• Access Token: Use OAuth 2.0 to obtain an access token from Azure Entra ID. DSS then uses this token to authenticate with Azure SQL Managed Instance. The location properties required for this authentication are Azure_OAuth2_Endpoint, Azure_OAuth2_Client_Id, and Azure_OAuth2_Client_Secret.

  This method is useful for applications that need to authenticate programmatically. For more information, refer to Application and service principal authentication in Microsoft's documentation.

This method is only available in the DSS UI as of 6.2.5/10. For earlier versions, you can define it using the CLI or REST API.