Configuring a Database Server Object

Licensing Note: Database Server Objects cannot be configured within CSM if the User environment is run in a SaaS or CSM-hosted environment.

  1. In CSM Administrator, create a Blueprint.
  2. Select Managers > Database Server Objects.

    This option is not available for SAAS systems or non-licensed evaluation systems.

    The Database Server Object Manager opens.

  3. Select Create New Create New Button to open the Database Server Object window.

General Page

  1. Specify a Name.
  2. Select a Server Object type in the drop-down list.
  3. Select a Dependent Business Object in the drop-down list.
  4. Select the Show all check box to display all possible Business Objects in the drop-down list.
  5. Specify the SQL script in the text box to create the replication script.
  6. Choose the object to import and select OK.
  7. Select the Check Syntax button to validate that the SQL script is correct.
  8. Select Save.

SQL to Create Object Page

  1. Specify a SQL script or click Import to import a script.
  2. Select Check Syntax to validate the SQL script.
  3. Select Save.

SQL to Drop Object Page

  1. Specify a SQL drop script.
  2. Select a Drop and Recreate Behavior radio button.
    Option Description
    Table Dropped Drops and recreates the server object whenever the table for the Business Object is dropped and recreated.
    Table Changed Drops and recreates the server object whenever the CMS Business Object table is changed.
    Only When Function Changes Creates an object in the CMS database when the Blueprint is published. Use this option to keep stored procedures, triggers, etc. with the CSM database when it is moved.
  3. Select Save.