Database application federation
View Patent ↗According to an aspect, a system for assisting a user with configuration management may include a configuration management database (CMDB) system having a plurality of configuration items, and an application external to the CMDB system. The CMDB system may associate an invocation string with a first configuration item and the application external to the CMDB system. The CMDB system may obtain information from the first configuration item, where the information from the first configuration item provides information for launching the application external to the CMDB system. The CMDB system may insert the information from the first configuration item into the invocation string to create an application execution command. The CMDB system may execute the application external to the CMDB system, independently from the CMDB system, based on the application execution command.
1. An information technology (IT) system for automatically invoking external applications that are external to a configuration management database, in response to database queries, the IT system comprising:
a programmable control device; and
a configuration management database storing a plurality of configuration items about resource components within the IT system, wherein the configuration management database is configured to cause the programmable control device to:
receive a database query for one or more configuration items within the configuration management database;
retrieve at least one configuration item from the configuration management database in response to the database query;
determine whether the at least one configuration item is associated with an external application;
in response to the at least one configuration item being determined as associated with the external application, identify an invocation string associated with the external application from an object linked to the at least one configuration item;
obtain at least one variable from the at least one configuration item;
insert the at least one variable from the at least one configuration item into the invocation string to create an application execution command; and
launch the external application based on the application execution command.
2. The IT system of claim 1 , wherein the configuration management database includes a relational database, and the resource components include computing devices and software installed on the computing devices within the IT environment.
3. The IT system of claim 1 , wherein the external application is invoked as an interactive application such that a result is returned to the configuration management database from the external application.
4. The IT system of claim 3 , wherein the programmable control device is configured to transfer the result to an application that issued the database query.
5. The IT system of claim 1 , wherein the programmable control device is configured to:
determine whether the external application is federated to a class of configuration items; and
compare one of more values associated with the at least one configuration item with a specified filter pattern,
wherein the programmable control device is configured to launch the external application only when the comparison identifies a match between the one or more values associated with the at least one configuration item and the specified filter pattern.
6. The IT system of claim 1 , wherein the configuration management database includes at least one federated interface object linked to the at least one configuration item, and a federated product object linked to the at least one federated interface object, the at least one federated interface object including the invocation string associated with the external application, the federated product object including information identifying the external application.
7. The IT system of claim 6 , wherein the programmable control device is configured to determine whether the at least one configuration item is associated with the external application based on at least one of the at least one federated interface object and the federated product object.
8. The IT system of claim 6 , wherein the programmable control device is to identify the invocation string from the at least one federated interface object.
9. The IT system of claim 6 , wherein the at least one federated interface object includes information that indicates a manner in which the target application is to be launched, and information indicating whether the external application returns data to the configuration management database or operates as a stand-alone application.
10. The IT system of claim 6 , wherein the least one federated interface object includes a first federated interface object and a second federated interface object, the second federated interface object having at least one different launch attribute than the first federated interface objection, the first and second federated interface objects being linked to the same configuration item.
11. A computer program product for automatically invoking external applications that are external to a configuration management database, in response to database queries within an information technology (IT) system, the computer program product having a non-transitory computer-readable medium storing executable instructions that when executed cause at least one processor to:
receive a database query at a configuration management database storing a plurality of configuration items, the plurality of configuration items storing information about resource components within the IT system;
retrieve at least one configuration item from the configuration management database in response to the database query;
determine whether the at least one configuration item is associated with an external application;
in response to the at least one configuration item being determined as associated with the external application, identify an invocation string associated with the external application from an object linked to the at least one configuration item;
obtain at least one variable from the at least one configuration item;
insert the at least one variable from the at least one configuration item into the invocation string to create an application execution command; and
launch the external application based on the application execution command.
12. The computer program product of claim 11 , wherein the executable instructions that when executed cause the at least one processor to:
invoke the external application as an interactive application such that a result is returned to the configuration management database from the external application; and
transfer the result to an application that issued the database query.
13. The computer program product of claim 11 , wherein the executable instructions that when executed cause the at least one processor to:
determine whether the external application is federated to a class of configuration items;
compare one of more values associated with the at least one configuration item with a specified filter pattern; and
launch the external application only when the comparison identifies a match between the one or more values associated with the at least one configuration item and the specified filter pattern.
14. The computer program product of claim 11 , wherein the configuration management database includes at least one federated interface object linked to the at least one configuration item, and a federated product object linked to the at least one federated interface object, the at least one federated interface object including the invocation string associated with the external application, the federated product object including information identifying the external application, wherein the executable instructions that when executed cause the at least one processor to:
determine whether the at least one configuration item is associated with the external application based on at least one of the at least one federated interface object and the federated product object; and
identify the invocation string from the at least one federated interface object.
15. The computer program product of claim 14 , wherein the at least one federated interface object includes information that indicates a manner in which the target application is to be launched, and information indicating whether the external application returns data to the configuration management database or operates as a stand-alone application.
16. The computer program product of claim 14 , wherein the least one federated interface object includes a first federated interface object and a second federated interface object, the second federated interface object having at least one different launch attribute than the first federated interface objection, the first and second federated interface objects being linked to the same configuration item.
17. The computer program product of claim 14 , wherein the configuration management database includes a federated key link object that logically couples the at least one configuration item and the federated product object, the federated key link object including a key value, one or more fields that identify the at least one configuration item, and one or more fields that identify the external application.
18. A computer-implemented method for automatically invoking external applications that are external to a configuration management database, in response to database queries within an information technology (IT) system, the method being performed by at least one processor, the method comprising:
receiving a database query at a configuration management database storing a plurality of configuration items, the plurality of configuration items storing information about resource components within the IT system;
retrieving at least one configuration item from the configuration management database in response to the database query;
determining whether the at least one configuration item is associated with an external application;
in response to the at least one configuration item being determined as associated with the external application, identifying an invocation string associated with the external application from an object linked to the at least one configuration item;
obtaining at least one variable from the at least one configuration item;
inserting the at least one variable from the at least one configuration item into the invocation string to create an application execution command; and
launching the external application based on the application execution command.
19. The computer-implemented method of claim 18 , further comprising:
invoking the external application as an interactive application such that a result is returned to the configuration management database from the external application; and
transferring the result to an application that issued the database query.
20. The computer-implemented method of claim 18 , wherein, before receiving the query at the configuration management database, the method further comprises:
registering the external application as a federated application such that the external application is configured to be automatically invoked in response to the database query.