Using an Azure SQL Managed Instance Database with IGEL UMS
This article describes how to connect an Azure SQL Managed Instance database to the IGEL Universal Management Suite (UMS).
For details on the supported database systems, see the "Supported Environment" section of the release notes. Details of the requirements when installing and operating the database can be found in the documentation for the particular DBMS.
Creating Your Azure SQL Managed Instance
→ Follow the steps described in the document Getting started with Azure SQL Managed Instance.
Connecting Your Azure SQL Managed Instance Database to Your UMS
→ In the UMS Administrator > Data Source, create a new data source with the following parameters:
DB type: Microsoft SQL Server
Host: The hostname or IP address of the Managed Instance
Port: The port on which the Managed Instance listens for requests. (Default: 1433)
User: The login name for connecting to the database
Database / SID: The database name
Schema: The database schema
JDBC Parameter (double-click):
sendStringParametersAsUnicode: false
trustServerCertificate: true
Configuring Entra ID Authentication
→ Follow the steps described in the document https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql .