Create CSM Database Views

Database views combine data from different database tables. In CSM, Views allow Users to view or import data using external connections.

To create a CSM Database view:

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 .

   The Database Server Object window opens.

4. On the General page:
   1. Specify a Name.
   2. Select View in the Server Object drop-down list.
   3. Select the Business Object in the Dependent Business Object in the drop-down list.
   4. Select Save.
5. Select the SQL to Create Object tab.
   1. Specify a SQL script or select Import to import a script.
   2. Select Check Syntax to validate the SQL script.
   3. Select Save.
6. Select the SQL Drop Object tab.
   1. Specify a SQL drop script.
   2. Select the Drop and Recreate Behavior radio button.
      1. Table Dropped: Drops and recreates the server object whenever the table for the Business Object is dropped and recreated.
      2. Table Changed: Drops and recreates the server object whenever the Business Object table is changed.
      3. Only When Function Changes: Creates an object in the database when the Blueprint is published. Use this option to keep view with the CSM database when it is moved.
      4. Select Save.
7. Publish the Blueprint.