More data server connections that support JWT authentication

Cognos Analytics 11.2.2 provides an expanded list of data servers to which you can create connections using JSON Web Token (JWT) authentication.

For JWT authentication, data server connections use the associated JDBC driver to pass a JWT when authenticating to the database. In release 11.2.2, support for JWT authentication is new for these connection types:

• Azure SQL and Synapse

  Use the Microsoft SQL Server JDBC driver. The connection automatically passes the token via the SQL Server driver accessToken property.

  Note: When you use Azure Active Directory and Azure SQL or Azure Synapse, you must include additional scope details by specifying the following name-value pair: ibmcognos.oidc.scope=https://database.windows.net/.default. For more information, see ibmcognos.oidc.scope.
• Denodo

  Use the Denodo JDBC driver. A connection must include the Denodo name-value pair useOAuth2=true.

• Exasol

  Use the Exasol JDBC driver. A connection must include the Exasol name-value pair authmethod=accesstoken. Exasol JDBC driver version 7.1.2 or higher is required.

• Google Bigquery

  Use the Bigquery JDBC driver. A connection must include the Bigquery name value pair OAuthType=2.

• Progress DataDirect Autonomous REST

  Use the Autonomous REST JDBC driver. A connection must include the Autnomous REST name-value pair AuthenticationMethod=OAuth2.

• Teradata

  Use the Teradata JDBC driver. The URL must include the Teradata LOGMECH=JWT name-value pair. Teradata JDBC driver version 17.10.00.14 or higher is required.

For a complete list of data server types for which Cognos Analytics supports authentication via JSON Web Tokens, see Connections that support JWT authentication.