Mapping a WebSphere Commerce user name to a IBM Digital Analytics user name for single sign-on

If you have business users with a WebSphere Commerce user name that is different from their user name for IBM Digital Analytics, formerly known as Coremetrics Analytics, you must configure a mapping of these names in the WebSphere Commerce database to support single sign-on.

An example is a business user who logs on to Management Center as johndoe but logs on to IBM Digital Analytics by using a shared user name like ibmanalytics. You can map more than one WebSphere Commerce user name to a single IBM Digital Analytics user name.

If you do not perform this procedure, the business user's WebSphere Commerce user name is assumed to be the same as the IBM Digital Analytics user name. When a business user attempts to launch IBM Digital Analytics from Management Center, if there is no matching user name in IBM Digital Analytics, then the authentication fails and the business user is forced to log on to IBM Digital Analytics separately.

Before you begin

Identify the business users who have WebSphere Commerce user names that are different from their IBM Digital Analytics user name.
Gather the WebSphere Commerce user names for these business users. The user names are stored in the LOGONID column of the USERREG table. Also gather the corresponding IBM Digital Analytics user name for each business user.

Procedure

Connect to the WebSphere Commerce database.
For each WebSphere Commerce user name, issue the following SQL statement. This statement stores the mapping of the WebSphere Commerce user name to a IBM Digital Analytics user name in the MBRATTRVAL table:
```
INSERT into MBRATTRVAL (MBRATTRVAL_ID, MEMBER_ID, ATTRTYPE_ID, MBRATTR_ID, STRINGVALUE) values (
((SELECT MAX(MBRATTRVAL_ID) from MBRATTRVAL) + 1),
(SELECT USERS_ID from USERREG where LOGONID = 'wcsUsername'),
'STRING',
(SELECT MBRATTR_ID from MBRATTR where NAME = 'CMCAnalyticsUsername'), 'coremetricsUsername')
```
Where:

wcsUsername

The WebSphere Commerce user name. This name is the name that the business user uses to log on to Management Center. These user names are stored in the LOGONID column of the USERREG table. You can specify only one user name at a time.

coremetricsUsername

The IBM Digital Analytics user name. This name is the name that the business user uses to log on to IBM Digital Analytics.
Repeat the previous step for each additional WebSphere Commerce user name that requires this mapping.

Results

The next time these business users log on to Management Center and then launch IBM Digital Analytics, they will not have to authenticate separately with IBM Digital Analytics.