CM System Data Packaging Overview

CM System Data Packaging Tools allow implementers to extract and package Customer Modification ('CM') system data from their databases and deliver it to their customers.

Oracle and MS SQL Server are both supported. The example below utilizes the Oracle database platform to illustrate the extract and upload process. MS SQL Server requires a different ODBC connection for the extract and upload processes. A description of the ODBC setup is in the extract and upload bat files provided as samples.

As a standard release process, the implementers can add the CM system and Meta data records to the base product database or change base product system and Meta data records according to the specific rules (see "System Table Guide" document in the Installation Guide of the product). Implementers can then choose to migrate the CM data to a customer database as a full extract of CM data, or incremental differences between the current version of the system data on the customer site and the new version of the implementation development database.

Untitled: image116

Packaging CM system data starts by creating a copy of the project dev database into a project release database. A blueprint file of the system data is then created by executing the OraSDBP tool.

Untitled: image117

To apply the latest changes to a QA or production database, execute OraSDUp with the blueprint file as input and then specifying the target database.