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
Do NOT use the schema dbo for the UMS database tables!
Changing the name of the schema of an existing productive database is not supported, and doing so in a live database will result in a corrupt database. If you need to move off the dbo schema, you will need to perform a full backup and restore of the schema to a new database and schema with the correct name, or use the IGEL Administrator to copy the data to a new database and schema, see Copying a Data Source.
JDBC Parameter (double-click):
sendStringParametersAsUnicode: falsetrustServerCertificate: true
Configuring Entra ID Authentication
→ Follow the steps described in the document Microsoft Entra authentication - Azure SQL Database & Azure SQL Managed Instance & Azure Synapse Analytics.