Automatic configuration of data invocation from one or more sources based on metadata mappings
The present disclosure relates to computer-implemented methods, software, and systems for automatic database configuration. One example method includes receiving, at a database associated with a data warehouse application, a request to generate a configuration to acquire data objects based on executing calls to corresponding programming interfaces provided by a source application, wherein the programming interfaces are identified in the received instructions and are associated with acquiring the data objects associated with metadata entities defined at the database; in response to the received instructions, configuring the database to automatically execute one or more calls to acquire relevant data for a metadata entity defined at the database, wherein the metadata entity is associated with a section of a first programming interface; and invoking the first programming interface at the source application, wherein invoking the first programming interface results in acquiring the relevant data.
1. A computer implemented method for configuring automatic invocation of data from one database to another database, the method comprising:
receiving, at a database, a request to generate a configuration for the database to automatically acquire a plurality of data objects from one or more source applications, the plurality of data objects being associated with a first set of metadata entities defined at the database, the request defining the first set of metadata entities, wherein the plurality of data objects are acquirable based on executing calls to programming interfaces provided by the one or more source applications;
in response to the received request, configuring the database to automatically execute calls to acquire, from a source application, data associated with a first data object of the plurality of data object, the first data object being associated with a first metadata entity of the first set of metadata entities defined at the database, wherein configuring the database comprises:
deploying a data model at the database that defines mappings between an entity of the first set of metadata entities and one or more corresponding programing interfaces at the source application, wherein each entity of the first set of metadata entities is associated with a scope function to determine related entities to the respective entity from the first set of metadata entities, wherein the data associated with the first data object of the plurality of data objects is acquired through invoking one or more programming interfaces determined as associated with a set of entities of the first set of entities according to the mappings of the data model, wherein the set of the entities is identified as related to the first metadata entity according to a first scope function defined for the first metadata entity,
wherein when the first scope function is executed at the database, the set of entities is determined as related to the first metadata entity, wherein at least one of the entities of the set of entities is determined as associated with a data object different from the first data object; and
invoking the one or more programming interfaces at the one or more source applications to acquire the data associated with the first data object of the plurality of data objects.
2. The method of claim 1 , further comprising:
obtaining identifiers defined for metadata entities; and
querying, by a data warehouse application associated with the database, a service at the one or more source applications to identify the programming interfaces associated with the metadata entities for acquiring data objects corresponding to the obtained identifiers,
wherein the request received at the database are generated at the data warehouse application based on querying the service to identify the set of programming interfaces.
3. The method of claim 1 , wherein the database is associated with a data warehouse application that is a data warehouse cloud platform that accumulates metadata for entities from a set of source applications based on a common metadata exposure service that defines a structure of metadata entities.
4. The method of claim 1 , wherein the programming interfaces are application programming interfaces.
5. A non-transitory, computer-readable medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations, the operations comprising:
receiving, at a database, a request to generate a configuration for the database to automatically acquire a plurality of data objects from one or more source applications, the plurality of data objects being associated with a first set of metadata entities defined at the database, the request defining the first set of metadata entities, wherein the plurality of data objects are acquirable based on executing calls to programming interfaces provided by the one or more source applications;
in response to the received request, configuring the database to automatically execute calls to acquire, from a source application, data associated with a first data object of the plurality of data object, the first data object being associated with a first metadata entity of the first set of metadata entities defined at the database, wherein configuring the database comprises:
deploying a data model at the database that defines mappings between an entity of the first set of metadata entities and one or more corresponding programing interfaces at the source application, wherein each entity of the first set of metadata entities is associated with a scope function to determine related entities to the respective entity from the first set of metadata entities, wherein the data associated with the first data object of the plurality of data objects is acquired through invoking one or more programming interfaces determined as associated with a set of entities of the first set of entities according to the mappings of the data model, wherein the set of the entities is identified as related to the first metadata entity according to a first scope function defined for the first metadata entity,
wherein when the first scope function is executed at the database, the set of entities is determined as related to the first metadata entity, wherein at least one of the entities of the set of entities is determined as associated with a data object different from the first data object; and
invoking the one or more programming interfaces at the one or more source applications to acquire the data associated with the first data object of the plurality of data objects.
6. The computer-readable medium of claim 5 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to perform operations, the operations comprising:
obtaining identifiers defined for metadata entities; and
querying, by a data warehouse application associated with the database, a service at the one or more source applications to identify the programming interfaces associated with the metadata entities for acquiring data objects corresponding to the obtained identifiers,
wherein the request received at the database are generated at the data warehouse application based on querying the service to identify the set of programming interfaces.
7. The computer-readable medium of claim 5 , wherein the database is associated with a data warehouse application that is configured to automatically acquire data from a set of source application based on deployed data models at the database, wherein the deployed data models are based on metadata and mappings between the metadata and corresponding programing interfaces at the set of source application.
8. A system comprising
one or more processors; and
a computer-readable storage device coupled to the one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations, the operations comprising:
receiving, at a database, a request to generate a configuration for the database to automatically acquire a plurality of data objects from one or more source applications, the plurality of data objects being associated with a first set of metadata entities defined at the database, the request defining the first set of metadata entities, wherein the plurality of data objects are acquirable based on executing calls to programming interfaces provided by the one or more source applications;
in response to the received request, configuring the database to automatically execute calls to acquire, from a source application, data associated with a first data object of the plurality of data object, the first data object being associated with a first metadata entity of the first set of metadata entities defined at the database, wherein configuring the database comprises:
deploying a data model at the database that defines mappings between an entity of the first set of metadata entities and one or more corresponding programing interfaces at the source application, wherein each entity of the first set of metadata entities is associated with a scope function to determine related entities to the respective entity from the first set of metadata entities, wherein the data associated with the first data object of the plurality of data objects is acquired through invoking one or more programming interfaces determined as associated with a set of entities of the first set of entities according to the mappings of the data model, wherein the set of the entities is identified as related to the first metadata entity according to a first scope function defined for the first metadata entity,
wherein when the first scope function is executed at the database, the set of entities is determined as related to the first metadata entity, wherein at least one of the entities of the set of entities is determined as associated with a data object different from the first data object; and
invoking the one or more programming interfaces at the one or more source applications to acquire the data associated with the first data object of the plurality of data objects.
9. The system of claim 8 , wherein the computer-readable storage device further stores instructions which, when executed by the one or more processors, cause the one or more processors to perform operations, the operations comprising:
obtaining identifiers defined for metadata entities; and
querying, by a data warehouse application associated with the database, a service at the one or more source applications to identify the programming interfaces associated with the metadata entities for acquiring data objects corresponding to the obtained identifiers,
wherein the request received at the database are generated at the data warehouse application based on querying the service to identify the set of programming interfaces.
10. The system of claim 8 , wherein the database is associated with a data warehouse application that is configured to automatically acquire data from a set of source application based on deployed data models at the database, wherein the deployed data models are based on metadata and mappings between the metadata and corresponding programing interfaces at the set of source application.
11. The computer-readable medium of claim 5 , wherein the other metadata entities are identified as relevant to the first metadata entity based on invoking a scope function defining dependencies between entities at the source application.
12. The computer-readable medium of claim 5 , wherein the programming interfaces are application programming interfaces.
13. The system of claim 8 , wherein the other metadata entities are identified as relevant to the first metadata entity based on invoking a scope function defining dependencies between entities at the source application.
14. The system of claim 8 , wherein the programming interfaces are application programming interfaces.