Updating existing workspace schemas for IBM Workplace Web Content Management integration for WebSphere Commerce

Only perform the steps outlined here if you have existing workspaces. New workspaces created after installing and configuring IBM Workplace Web Content Management integration for WebSphere Commerce do not require you to perform these instructions.

To update existing workspace schemas for IBM Workspace Web Content Management integration for WebSphere Commerce:

1. Start an SQL session.

2. Determine the names of the read schemas and the write schemas for you existing workspaces.

   To determine the names of the schemas, issue the following SQL command:

   SELECT WRITESCHEMA, READSCHEMA FROM CMWSSCHEMA

3. Determine the name of the schema for the production ready data.

   To determine the names of the schemas, issue the following SQL command:

   SELECT BASESCHEMA FROM CMWSSCHEMA

4. For each workspace schema (read and write), issue the following SQL command:

   CREATE SYNONYM workspace_schema.ARTTOPRODREL FOR base_schema.ARTTOPRODREL where:

   workspace_schema

   This is the read or write schema for the workspace.

   base_schema

   This is the name of the schema for the production ready data.

5. (Oracle) Commit your database updates by issuing the following SQL command:

   COMMIT;

 

Related Concepts

IBM Workplace Web Content Management integration for WebSphere Commerce

 

Related tasks

Overview: Integrating WebSphere Commerce and IBM Workplace Web Content Management