CMDB federation method and management system

A non-transitory computer usable medium having computer readable program code embodied therein, wherein the computer readable program code is adapted to be executed to:

• receive information from a configuration management database (CMDB) client, the information comprising:
• a selection of a federated data class,
• interface connection information for one or more Management Data Repositories (MDRs) that contain information associated with the federated data class, wherein the interface connection information comprises information that is used by a CMDB to connect to the one or more MDRs, and
• a selection of one or more join conditions, wherein the one or more selected join conditions are used to relate the federated data class to one or more classes residing in the CMDB;
• define a new federated data class using the one or more join conditions;
• send a query to the one or more MDRs based on the new federated data class;
• receive a query result set;
• and
• provide at least a portion of the query result set to the CMDB client.