I just want to share how I was able to connect Cognos Analytics to Azure synaps database. My challanges was I need to use ActiveDirectoryServicePrincipal insted of a database user.  This took me quite a while as I don't think many people have done this before me

I started with download DBeaver (Free SQL tool) for making a connection.  

I need to change authentication settings in driver properties to ActiveDirectoryServicePrincipal

DBeaver downloads all the requied jar files need for the connection.  These are placed in \Users\[username]\AppData\Roaming\DBeaverData\drivers\maven\maven-centralI copied the the following jar files from the folders into the drivers folder for the

dispatcher.

Then I downloaded JDBC driver version 12.8 Download - JDBC Driver for SQL Server | Microsoft Learn  from this download I used mssql-jdbc-12.8.0.jre8.jar. The dispatcher driver folders included these files :(db2jcc4.jar is DB2 and odbj7.jar is Oracle)

After restart of the dispacther I could set up  the connection in Cognos Analytics.

using Microsoft SQL server  my JDBC connection string was : jdbc:sqlserver://;serverName=[servername];databaseName=[databasename];encrypt=true;trustServerCertificate=true;authentication=ActiveDirectoryServicePrincipal;

The apptID and password was entered as normal signon. 

 Then connection was successful :