Define Database Properties for a Relationship

Use the Database page in the Relationship Properties window to create and enable foreign keys for the Relationship. Foreign keys establish and enforce a link between tables in a relational database, and are required by SQL Reporting Services.

The Relationship Properties window is available in the Relationship Editor (accessed from within a Blueprint in CSM Administrator).

It is recommended that you do not use foreign keys unless you have a specific need to do so.

To define database properties for a Relationship:

  1. Open the Relationship Properties window:
    1. In the CSM Administrator main window, click the Blueprints category, and then click the Create a New Blueprint task.

      If working on a saved Blueprint, open the existing Blueprint.

      The Blueprint Editor opens, showing the Object Manager in its Main Pane. The Object Manager lists the existing Business Objects.

    2. In the Object Manager, click a Business Object in the Object tree, and then click the Edit Relationships task in the Structure area.

      The Relationship Editor opens.

      You can also click the Edit Relationship button Relationship Icon on the Blueprint Editor Toolbar to open the Relationship Editor.

    3. Click Add to add a new Relationship, or Edit to edit an existing Relationship.
  2. Click the Database page.
  3. Define database options:
    • Use Blueprint Defaults for Foreign Key: Select this check box to use the global database options defined for Blueprints.
    • Create Foreign Key for Relationship: Select this check box to create a foreign key for the Relationship.
      1. Not Enforced/Enforced: Select whether or not to enforce foreign keys.
      2. If enforced, define whether to cascade updates and/or deletes:
        • Cascading Update: Select this check box to cascade updates. This means that if row in a related Business Object table containing a key referenced by the foreign key is updated, all rows that contain the Foreign Keys are also updated with the new value.
        • Cascading Delete: Select this check box to cascade deletes. This means that if row in a related Business Object table containing a key referenced by the foreign key is deleted, all rows that contain the foreign keys are also deleted.

  4. Select OK.

  5. Publish the Blueprint (File>Publish Blueprint) to commit the changes, or save the Blueprint (File>Save Blueprint) to continue making other changes.