IBM Support

Possible ways to change the authentication alias of IBM Cognos Business Intelligence in IBM Business Monitor

Technical Blog Post


Abstract

Possible ways to change the authentication alias of IBM Cognos Business Intelligence in IBM Business Monitor

Body

 

Because IBM Business Monitor keeps the user name and password for the IBM Cognos BI content store database in a Java Authentication and Authorization Service J2C authentication data alias (Cognos_JDBC_Alias), you can maintain all database credentials in one place. Whenever you start the IBM Business Monitor server, the current values are passed to the IBM Cognos BI configuration to allow IBM Cognos BI access to the content store. Because of this integration, you cannot change the content store user name and password using the IBM Cognos BI Configuration application.

 

Similarly, IBM Business Monitor keeps the user name and password for the IBM Cognos BI administrative access in the Cognos_Admin_Alias file, and the names of the authentication alias and the namespace are stored in the IBM Cognos BI Resource provider for endpoint information custom properties.

 

Rather than running the IBM Cognos BI Configuration application on each server, you need to update the authentication alias only once. You can maintain all system passwords from the administrative console.  Alternatively, you can use the AdminTask commands to set the passwords from a scripting environment. Below are detailed steps for different Cognos BI users' password setting.

 

Changing the IBM Cognos BI content store password

1st way: You can use the administrative console to change the IBM Cognos BI content store password.

To use the administrative console to change the IBM Cognos BI content store password, complete the following steps:

  1. From the administrative console, click Security > Global security.
  2. Click JAAS - J2C authentication data and enter the new password.

Please refer to below screens for reference.

image

 

image

 

2nd way: You can use the scripting wbmSetCognosDatabaseUser command to change the content store password.

The wsadmin tool is located under <WAS_INSTALL_DIR>/bin and <WAS_PROFILE_DIR>/bin. Use one of the following commands to launch it:

  • For Jython:
    • For Windows operating systemwsadmin -lang jython
    • For Linux operating systemFor UNIX operating system./wsadmin.sh -lang jython
  • For Jacl:
    • For Windows operating systemwsadmin
    • For Linux operating systemFor UNIX operating system./wsadmin.sh

 

It is recommended that you run the wsadmin tool in disconnected mode (that is, with the server stopped). To do this, use the -conntype NONE parameter:

  • For Jython:
    • For Windows operating systemwsadmin -lang jython -conntype NONE
    • For Linux operating systemFor UNIX operating system./wsadmin.sh -lang jython -conntype NONE
  • For Jacl:
    • For Windows operating systemwsadmin -conntype NONE
    • For Linux operating systemFor UNIX operating system./wsadmin.sh -conntype NONE

The wbmSetCognosDatabaseUser command sets the user name and password for the Cognos_JDBC_Alias.

 

The following example uses Jacl to set the user name and password.

$AdminTask wbmSetCognosDatabaseUser {-dbUserName myName -dbUserPassword myPassword}

 

The following example uses Jython to set the user name and password.

AdminTask.wbmSetCognosDatabaseUser ('-dbUserName myName -dbUserPassword myPassword')

 

Note: The wbmSetCognosDatabaseUser command accepts the parameters listed in the following table.

Parameter and valueRequired?Description
-dbUserName user_nameRequiredThe name of the database user for the content store.
-dbUserPassword passwordRequiredThe password of the database user for the content store.

 

Changing the IBM Cognos BI administrative password

1st way: You can maintain all system passwords from the WebSphere administrative console.

To use the administrative console to change a IBM Cognos BI password, complete the following steps:

  1. From the administrative console, click Security > Global security.
  2. Click JAAS - J2C authentication data and enter the new password.

Please refer to below screens for reference.

image

 

image

 

2nd way: You can use the scripting wbmSetCognosAdminUser command to change a IBM Cognos BI password.

First you need to launch wsadmin tool located under <WAS_INSTALL_DIR>/bin and <WAS_PROFILE_DIR>/bin then you can use wbmSetCognosAdminUser command to set the user name and password for the Cognos_Admin_Alias.

 

The following example uses Jacl to set the user name and password.

$AdminTask wbmSetCognosAdminUser {-adminUserName myUserName -adminPassword myPassword}

 

The following example uses Jython to set the user name and password.

AdminTask.wbmSetCognosAdminUser('-adminUserName myUserName -adminPassword myPassword')

 

The wbmSetCognosAdminUser command accepts the parameters listed in the following table.

Parameter and valueRequired?Description
-adminUserName user_nameRequiredThe user name of the IBM Cognos BI administrator.
-adminPassword passwordRequiredThe password of the IBM Cognos BI administrator.

 

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"","label":""},"Component":"","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}}]

UID

ibm11080327