About Database Assets

The type of database endpoint you use determines the assets that must be generated. The following table shows the assets that are generated for each supported database:

Note: In Cast Iron, asset tables are created with the identifier size of 30 characters. For asset tables, the format that Cast Iron follows is: CI_CT_<respective-table-name> (for Control Table), and CI_BT_<respective-table-name> (for Buffer Table). So you must use tables with names having a maximum of 24 characters.
Database Assets Generated
  • DB2® AS/400

  • Informix®

  • Microsoft SQL

  • Sybase

  • Buffer tables

  • Control tables

  • Triggers

Local Staging Database
  • Buffer tables

  • Control tables

  • Index tables

  • Triggers

Oracle
  • Buffer tables

  • Control tables

  • Triggers

  • Sequences

Assets are only generated for starter activities and non-starter activities that specify the Exactly Once delivery option. Assets are not generated for non-starter activities that specify At Least Once or At Most Once delivery options.

Note: Control table names are appended with an activity ID to ensure all assets have unique names. This number does not distinguish multiple endpoints in an orchestration using the same control table.

Validating Database Assets

About this task

Before you generate database assets, validate the assets. When you validate an asset, the integration environment verifies whether the buffer table or control table exists in the source database and verifies that table structures are correct.

Note:

Triggers and sequences are not validated .

Procedure

  1. In the navigation pane, select Repository > Configurations. The Project Configuration page is displayed.
  2. Click the project configuration that requires database assets. The Configuration Details page is displayed.
  3. Verify the project configuration is in the undeployed state.
  4. In the Assets section, click Database. The Database Assets page is displayed.
  5. Select all the assets you want to validate and click Validate.
  6. The results returned determine the next step. The following table tells you how to interpret the feedback and how to proceed.
    • A green check mark - valid
    • A yellow warning sign = warning

Database Asset Validation Feedback

Exists? Valid? Action
valid valid The asset exists in the database and the asset structure matches the project configuration you created in Studio.You can now deploy the project configuration.
valid warning The asset exists in the database, but the asset structure is incorrect. Check that the database script contains the appropriate columns and that the columns are in the correct order. If there is an error, recreate the asset.
warning warning The asset does not exist in the source database table. You must create the asset before you can deploy the project configuration.

Warning: Constraint names ending in a unique ID are generated. However, if the size of the database table name is greater than 18 characters, the constraint name is truncated resulting in a naming conflict. If the database table name is greater than 18 characters, edit the database assets script generated and make the constraint names unique.

Generating Database Assets

About this task

The project configuration must be undeployed before you can validate or generate assets. Validate assets before you generate them.

Procedure

  1. In the navigation pane, select Repository > Configurations. The Project Configuration page is displayed.
  2. Click the project configuration that requires database assets. The Configuration Details page is displayed.
  3. Verify the project configuration is in the undeployed state.
  4. In the Assets section, click Database. The Database Assets page is displayed.
  5. Select all the assets you want to generate. You can select all the assets by selecting the top-most check box.
  6. Click Create.
  7. Review and modify the database script as needed.



Feedback | Notices


Timestamp icon Last updated: Thursday, 2 June 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.appliance.doc/ApplianceHelp/Managing_Projects/generatingDBAssets.html