Flexible adoption of base data sources in a remote application integration scenario
A data source integration architecture is provided for integrating application systems with an analytics system for user querying and data retrieval. The integration includes flexibly configuring base data sources as defined by an analytical model of an application system, such as an OEM application. In response to a query, metadata is fetched from an application server, where the metadata may contain a description of underlying artifacts of the structural part of the analytical model. During query generation, these specific views are injected into a query view and a parametrization is added for data source modulation. In addition, a flexible configuration of the final shape of the base data source specifically allows for the requirements of the OEM application to be addressed.
1. A computer-implemented method, comprising:
responsive to a command initiated at a browser, providing, by a processing component of an application system and to a browser interface coupled to the application system, a data model metadata comprising a structural definition of the application system;
generating, by the processing component and in response to a query initiated at the browser, a query view description including a data source and parameter description, the data source and parameter description provided by the browser;
executing, by the processing component, the query received by the application system from the browser interface, the executing of the query comprising generating modified data sources by injecting parameters defined in the parameter description into base data sources of the application system to create a partial database query that is executed based on the modified data sources; and
providing, by the processing component and to the browser interface, results of the execution of the query.
2. The computer-implemented method of claim 1 , wherein the base data sources comprise metadata.
3. The computer-implemented method of claim 2 , wherein the metadata comprises a JavaScript object notation format definition of analytical metadata.
4. The computer-implemented method of claim 1 , wherein the structural definition of the application system comprises one or more of database tables, calculation views, structured query language views, table functions, and core data services.
5. The computer-implemented method of claim 1 , wherein the application system is integrated with an analytics application, wherein execution of the query comprises retrieving data from the application system based on permissions from the analytics application.
6. The computer-implemented method of claim 1 , further comprising:
identifying additional parameters from the query.
7. The computer-implemented method of claim 1 , wherein the parameters comprise predefined functions from an analytics application.
8. A system, comprising:
at least one data processor; and
at least one memory storing instructions which, when executed by the at least one data processor, result in operations comprising:
responsive to a command initiated at a browser, providing, to a browser interface coupled to the application system, a data model metadata comprising a structural definition of the application system;
generating, in response to a query initiated at the browser, a query view description including a data source and parameter description, the data source and parameter description provided by the browser;
executing the query received by the application system from the browser interface, the executing of the query comprising generating modified data sources by injecting parameters defined in the parameter description into base data sources of the application system to create a partial database query that is executed based on the modified data sources; and
providing, to the browser interface, results of the execution of the query.
9. The system of claim 8 , wherein the base data sources comprise metadata.
10. The system of claim 9 , wherein the metadata comprises a JavaScript object notation format definition of analytical metadata.
11. The system of claim 8 , wherein the structural definition of the application system comprises one or more of database tables, calculation views, structured query language views, table functions, and core data services.
12. The system of claim 8 , wherein the application system is integrated with an analytics application, wherein execution of the query comprises retrieving data from the application system based on permissions from the analytics application.
13. The system of claim 8 , wherein the at least one memory storing instructions which, when executed by the at least one data processor, result in further operations comprising:
identifying additional parameters from the query.
14. The system of claim 8 , wherein the parameters comprise predefined functions from an analytics application.
15. A non-transitory computer-readable storage medium including program code, which when executed by at least one data processor, causes operations comprising:
responsive to a command initiated at a browser, providing, to a browser interface coupled to the application system, data model metadata comprising a structural definition of the application system;
generating, in response to a query initiated at the browser, a query view description including a data source and parameter description, the data source and parameter description provided by the browser;
executing the query received by the application system from the browser interface, the executing of the query comprising generating modified data sources by injecting parameters defined in the parameter description into base data sources of the application system to create a partial database query that is executed based on the modified data sources; and
providing, to the browser interface, results of the execution of the query.
16. The non-transitory computer-readable storage medium of claim 15 , wherein the base data sources comprise metadata.
17. The non-transitory computer-readable storage medium of claim 16 , wherein the metadata comprises a JavaScript object notation format definition of analytical metadata.
18. The non-transitory computer-readable storage medium of claim 15 , wherein the structural definition of the application system comprises one or more of database tables, calculation views, structured query language views, table functions, and core data services.
19. The non-transitory computer-readable storage medium of claim 15 , wherein the application system is integrated with an analytics application, wherein execution of the query comprises retrieving data from the application system based on permissions from the analytics application.
20. The non-transitory computer-readable storage medium of claim 15 , wherein the parameters comprise predefined functions from an analytics application.