Understanding staging tables

You can add data from external systems or sources to BMC IT Business Management Suite using staging tables. These staging tables are a set of database tables that provide a temporary repository for data before it is loaded into the BMC IT Business Management Suite database. As a general rule, each object in the application that has data in a table in the database has a corresponding staging table. For example, the data for asset information is held in the ITT_ASSET table, while the corresponding staging table for assets is called IDD_ASSET.

The actual import process takes the data in the staging table, validates it, and loads it into the BMC IT Business Management Suite repository. If there are errors with the data, the system records it and notifies the administrator. The administrator can then take action to correct the issue and re-import the data.

Note

BMC recommends that you use the list of staging tables to import data into BMC IT Business Management Suite.

For more details on staging tables, see the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*