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
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"}]
Was this topic helpful?
Document Information
Modified date:
24 March 2023
UID
ibm16444153