This documentation supports the 20.02 version of BMC CMDB.To view an earlier version, select the version from the Product version menu.

Federation of data outside the CMDB: Calbro Services example

This use case describes how while critical configuration item (CI) data is store in the CMDB, other data that is detailed and related to the CIs can be federated to external data store. This helps maintain the efficiency of the CMDB while having the advantage of being able to view the federated data through the CMDB Explorer.


Scenario

Calbro Services needs to store service and maintenance records of their printers in a Microsoft SQL database.

Allen Allbrook, a BMC Configuration Management Database (BMC CMDB) administrator at Calbro Services, knows that only core data for a configuration item (CI) should be stored in BMC CMDB. Detailed and related data for those CIs should be federated to help organize CIs and make BMC CMDB more efficient.

Allen determines that the service and maintenance database stores information that is related to CIs in the CMDB, and makes that data available using the retrieval method of federation. The federated data is then available for viewing from within BMC CMDB through CMDB Explorer.

For example, a data store can represent data from databases (retrieval type) or launch in context links. Allen uses the Federation Manager to federate external data through a data store, making that data available to view and query with BMC Configuration Management Database (BMC CMDB) tools, such as the CMDB Explorer.

Allen performs the following broad steps in the Federation Manager to make the data available to view and query in BMC CMDB:

  1. Create a federated data store.
  2. Create a federated data class.
  3. Create a federated relationship.

Federation workflow

image2019-9-25_15-38-32.png


Product | Component | Console

User

Action

Reference

Federation Manager



CMDB administrator

Create a data store and define a federated link to cross launch the CI.

Class Manager

Define a federated class

Federation Manager in the old UI

Link the CI to the federated data class using federated relationship class.

Federation results

Calbro Services can now access federated data related to CIs from the CMDB Explorer.

image2020-8-17_12-34-7.png

Federation benefits

You can maintain an efficient CMDB by federating non-critical data outside the CMDB. 

Related topics

Learning-about-federated-data-which-is-stored-outside-the-CMDB

Accessing-external-data-through-CMDB-by-using-Federation