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-central
I 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 :
