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:
- From the administrative console, click .
- Click JAAS - J2C authentication data and enter the new password.
Please refer to below screens for reference.
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:
- wsadmin -lang jython
- ./wsadmin.sh -lang jython
- For Jacl:
- wsadmin
- ./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:
- wsadmin -lang jython -conntype NONE
- ./wsadmin.sh -lang jython -conntype NONE
- For Jacl:
- wsadmin -conntype NONE
- ./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}
AdminTask.wbmSetCognosDatabaseUser ('-dbUserName myName -dbUserPassword myPassword')
Note: The wbmSetCognosDatabaseUser command accepts the parameters listed in the following table.
Parameter and value | Required? | Description |
---|---|---|
-dbUserName user_name | Required | The name of the database user for the content store. |
-dbUserPassword password | Required | The 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:
- From the administrative console, click .
- Click JAAS - J2C authentication data and enter the new password.
Please refer to below screens for reference.
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 value | Required? | Description |
---|---|---|
-adminUserName user_name | Required | The user name of the IBM Cognos BI administrator. |
-adminPassword password | Required | The password of the IBM Cognos BI administrator. |
UID
ibm11080327