IBM Support

How to create a data server connection to Azure SQL Server using Active Directory Password Authentication

How To


Summary

Information for configuring a Data Server Connection to Azure SQL Server from Cognos Analytics.
Includes information on the required JDBC drivers and dependencies and the JDBC URL connection string format.

Steps

1. Refer to the Microsoft Azure documentation for the required JDBC drivers and dependencies.
 
2. Copy the required JDBC driver and all of the dependencies to the Cognos Analytics <install_location\drivers> directory.  Restart Cognos services.
3. Define the connection string for the data source connection with the following format
URL=jdbc:sqlserver://servername:port;DATABASE=databasename;LOGINTIMEOUT=0;authentication=ActiveDirectoryPassword;DRIVER_NAME=com.microsoft.sqlserver.jdbc.SQLServerDriver
4. Test connection to confirm it connects successfully.

Related Information

Document Location

Worldwide

[{"Type":"SW","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Installation and Configuration-\u003EData Sources"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.7"}]

Document Information

Modified date:
24 March 2023

UID

ibm16444153