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:
Database | Assets Generated |
---|---|
|
|
Local Staging Database |
|
Oracle |
|
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.
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.
Triggers and sequences are not validated .
Procedure
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
- In the navigation pane, select . The Project Configuration page is displayed.
- Click the project configuration that requires database assets. The Configuration Details page is displayed.
- Verify the project configuration is in the undeployed state.
- In the Assets section, click Database. The Database Assets page is displayed.
- Select all the assets you want to generate. You can select all the assets by selecting the top-most check box.
- Click Create.
- Review and modify the database script as needed.