WebSphere Commerce EnterpriseWebSphere Commerce Professional

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



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:
    DBUserID="" DBUserPwd=""
    WritePrefix="WCW" display="false"/>  


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.