Federated search of heterogeneous data sources

A system for federated search of a plurality of heterogeneous external data sources from a data analytics tool, comprising:

• an internal data warehouse;
• a processor of a database management system configured to:
• parse a client search call received from the data analytics tool, and as formulated in a first data model to identify one or more data connectors to the heterogeneous external data sources;
• with a mapping of each identified data connector of the one or more identified data connectors, translate the client search call as formulated in the first data model to one or more external search calls formulated in one or more alternate data models of the heterogeneous external data sources;
• from each heterogeneous external data source of the heterogeneous external data sources, receive, as formulated in the alternate data models, at least one response to the one or more external search calls;
• with the mappings of the one or more identified connectors, reformulate the at least one response of the one or more external search calls from the one or more alternate data models to the first data model to yield one or more client search result objects;
• merge the client search result objects to a data warehouse;
• execute the client search call, as formulated in the first data model, against the data warehouse;
• to the data analytics tool, send results of the executed client search call including the merged client search result objects;
• periodically receive from one or more of the heterogeneous external data sources, as formulated in the one or more alternate data models, supplemental responses to the external search calls;
• with the mappings, reformulate the supplemental responses to one or more supplemental client search result objects in the first data model;
• and
• merge the one or more supplemental client search result objects to the data warehouse;
• and
• send an alert to the data analytics tool referring to any newly merged objects resulting from the periodic receipt and the reformulating the supplemental responses.

A computer program product comprising a non-transitory computer readable storage medium having program code embodied therewith, the program code being executable by a processor to perform a method for federated search of a plurality of heterogeneous external data sources from a data analytics tool and the method including:

• parsing a client search call received from the data analytics tool, as formulated in a first data model to identify one or more data connectors to the heterogeneous external data sources;
• with a mapping of each identified data connector of the one or more identified data connectors, translating the client search call as formulated in the first data model to one or more external search calls formulated in one or more alternate data models of the heterogeneous external data sources;
• from each heterogeneous external data source of the heterogeneous external data sources, receiving, as formulated in the alternate data models, at least one response to the one or more external search calls;
• with the mappings of the one or more identified connectors, reformulating each of the at least one response of the one or more external search calls from the one or more alternate data models to the first data model to yield one or more client search result objects;
• merging the client search result objects to a data warehouse;
• executing the client search call, as formulated in the first data model, against the data warehouse;
• to the data analytics tool, sending results of the executed client search call including the merged client search result objects;
• periodically receiving from one or more of the heterogeneous external data sources, as formulated in the alternate data models, supplemental responses to the external search calls;
• with the mappings, translating the supplemental responses to one or more supplemental client search call objects in the first data model;
• merging the one or more supplemental client search call objects to the data warehouse;
• and
• sending an alert to the data analytics tool referring to any newly merged objects resulting from the periodic receipt and the translating the supplemental responses.