894 WebSphere Commerce V5.4 Handbook, Architecture and Integration Guide
4. Right-click Remote Data Sources and select Change Userid and
Password
.
5. Select the
Change Password check box and enter the password for the
WebSphere Commerce database user in the password and verify password
fields. Make sure that the user ID for which you are changing the password is
that of the user of WebSphere Commerce. Click
OK.
6. Expand
Warehouse Targets.
7. Right-click
Target Data Sources and select Change Userid and Password.
8. Select the
Change Password check box and enter the password for the
Commerce Analyzer administrator in the password and verify password
fields. Make sure that the user ID for which you are changing the password is
that of the administrator of WebSphere Commerce Analyzer. Click
OK.
Update password for the Start Brio Agent
1. In the Data Warehouse Center, expand Administration -> Agent Sites.
2. Right-click
Start Brio Agent and select Change Userid and Password.
3. Select the
Change Userid check box and enter a user ID that fits the
following conditions:
On the WebSphere Commerce Analyzer server, the user ID must have
administrator privileges.
On the WebSphere Commerce server, a user ID must exist with the same
name, password, and privileges.
On the WebSphere Commerce server, this user ID must have read and
change permission to the shared directory specified in the WebSphere
Commerce HTML Document Root field of the Prepare Datamart step in
the Configuration Manager.
4. Select the
Change Password check box and enter the password for the user
in the password and verify password fields. Click
OK.
Schedule the extraction process to run daily
1. In the Data Warehouse Center, expand Subject Areas -> Data Mart
Processes -> Processes
.
2. Select
Start Daily Data Extraction Process.
3. In the right side of the window, right-click
Start Daily Data Extraction
Process
and select Schedule.
4. Select
Daily in the Interval field and Everyday in the Frequency field. Select
a date and time to start running the extraction process daily.

Get WebSphere Commerce V5.4 Handbook: Architecture and Integration Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.