Tutorial: Adding content managed resources to the Catalog service module

This tutorial demonstrates how to add workspace support to the Catalogs tool.This tutorial continues the Warranty scenario, and uses the schema and Management Center customizations you have performed as part of Tutorial: Extending a BOD service to manage UserData with the Data Service layer and Tutorial: Adding fields in the Catalogs tool.

To make the Warranty schema customization content managed, you need to enable workspace support for the two new tables. Using workspaces prevents the same object from being edited by users in different task groups within the same workspace. Workspaces in the Management Center use BOD service modules, which support workspaces by allowing you to customize what aspects of the physical and logical layers are under change control. This change control data is passed back to the presentation layer where you can show it in Management Center workspaces.

The XWARRANTY and XCAREINSTRUCTION data are passed back to the Management Center as part of the userdata element in the Get service you customized in Tutorial: Extending a BOD service to manage UserData with the Data Service layer. Because you are using the userdata element, you only need to register the custom tables as managed resources in an XML file, and then run a script to update the workspace schema. You do not need to provide any Java code or additional XML customization.

Learning objectives

After completing this tutorial, you should be able to:

Enable workspace support for a customized WebSphere Commerce service module
Update the write schema with your custom table information
Create a workspace with task groups and tasks by using workspace admin tool

Time required

This tutorial is expected to take 1 hour to complete.

Skill level

Advanced

Audience

This tutorial is intended for developers customizing the Management Center.

System requirements

Before you begin, ensure that you have:

Installed WebSphere Commerce Developer Version 7.
Installed DB2 V9.1
Verified that your WebSphere Commerce Developer installation is using a DB2 database.
Enabled workspaces.

Set the value of StagingEnable to true in the file, WC_eardir\xml\config\wc-server.xml. An example follows:

<Staging
ContentMgmtEnable="false"
DBName=""
DBServerName=""
DBServerPort=""
DBUserID="" DBUserPwd=""
DataSourceName=""
DatabaseType=""
NumWorkspaces="5"
ReadPrefix="WCR"
StagingEnable="true"
WritePrefix="WCW" display="false"/>

Prerequisites

This tutorial uses the schema and Management Center customizations from the Warranty scenario. Complete the following tutorials before proceeding with this one:

You also need to create the following users:


User ID	Organization	Roles
ConMgr	Root Organization	Workspace Manager
ProMgrA	Root Organization	Product Manager, Workspace Content Contributor
ProMgrB	Root Organization	Product Manager, Workspace Content Contributor
ProMgrApp	Root Organization	Product Manager, Workspace Task Group Approver

To complete this tutorial, be familiar with the following terms and concepts:

Workspaces
Relational databases
XML
Management Center
Data service layer
Content managed table

You should also be familiar with the techniques for improving the performance of SQL queries under workspaces in the Data Service Layer.