Processing Inventory Information › Tenancy Collection › Data Synchronization from an MDB to a Separate Target MDB (SQL Bridge and Oracle Bridge) › How Tenancy Collection Works (SQL Bridge and Oracle Bridge)

How Tenancy Collection Works (SQL Bridge and Oracle Bridge)

The SQL Bridge and Oracle Bridge synchronization replicates asset and inventory data from the CA Client Automation database to the database used by another CA Technologies product, such as CA APM or CA Service Desk Manager. This asset and inventory data can include tenancy data. CA Client Automation can collect tenancy data and make the data available for other products. However, CA Client Automation cannot populate the ca_tenant database table, which other products use to define tenancies.

Therefore, if you are using SQL Bridge and Oracle Bridge synchronization, first synchronize the ca_tenant table in your product with the CA Client Automation database before tenancy data can be available for use in asset collection. Tenancy collection with SQL Bridge and Oracle Bridge synchronization uses the following general process:

• The administrator configures the tenants in the product (for example, CA APM or CA Service Desk Manager).
• The administrator synchronizes tenant information between the ca_tenant table and the CA Client Automation database.
• The SQL Bridge and Oracle Bridge synchronization supplies asset and inventory data (including tenant data) for use in asset collection.