QIE does support connecting to a Azure SQL db that is setup using Managed Identity for authentication.
This is how you connect to a DB in the Database Connection:
1. Select the Microsoft SQL Server as the Driver
2. Enter the Client ID from the managed Identity in the Username field
3. Check the "Manullay set the Connection URL" box
4. Use the following template for the connection URL:
jdbc:sqlserver://{sqlServerName}.database.windows.net;databaseName={dbName};encrypt=false;;Authentication=ActiveDirectoryManagedIdentity
This is the setup for using the managed identity as the QIE Database (Requires version 25.2 or higher):
1. Update the qie service manager or qie.service with the following java options. Note: spaces have been added for page formatting. These need to be removed when pasted into qie.service or start.sh:
-Dconnection.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver \
-Dconnection.url=jdbc:sqlserver://{serverName}.database.windows.net:1433; databaseName{dbName};Authentication=ActiveDirectoryManagedIdentity; encrypt=true;trustServerCertificate=true; \
-Dhibernate.dialect=com.qvera.qie.persistence.SQLServer2022UnicodeDialect \
-Dconnection.username={clientIdFromManagedIdentity} \
-Dconnection.ignorePassword=true \
