Custom data
A technique of obtaining update data from a database includes accessing configuration data associated with a particular entity in a plurality of entities. The configuration data includes a specification of how to extract a set of entity generated data records from a remote data store associated with the particular entity. The remote data store associated with the particular entity comprises common data elements shared by the plurality of entities and entity-specific data elements specified by the particular entity. It further includes determining whether values for a data field specified in the configuration data have been previously extracted from the remote data store. It further includes generating, according to the specification included in the configuration data, a query for values associated with the data field. Generating the query comprises determining a range indicator that indicates a time period of data values to be extracted. The range indicator is determined based at least in part on the determination of whether values for the data field have been previously extracted. It further includes, based at least in part on the generated query, extracting, from the remote data store, values for the data field corresponding to the determined range indicator. It further includes storing the extracted values to a data store of a central host component that provides services to the plurality of entities.
1. A system, comprising:
a processor configured to:
access configuration data associated with a particular entity in a plurality of entities, wherein the configuration data includes a specification of:
how to extract a set of entity-generated data records from a remote data store associated with the particular entity, wherein the remote data store associated with the particular entity comprises common data elements shared by the plurality of entities and entity-specific data elements specified by the particular entity; and
how the set of entity-generated data records is to be used by a hosted application;
according to the specification included in the configuration data, transmit, over a network, a set of query parameters to a client component associated with the particular entity, wherein the client component is configured to generate a query for extracting values associated with an entity-specific data field, and wherein generating the query comprises modifying, by the client component, a template query using the set of query parameters;
based at least in part on the generated query, receive a set of values for the entity-specific data field extracted from the remote data store; and
execute the hosted application, including using at least some of the extracted values for the entity-specific data field according to the specification included in the configuration data; and
a memory coupled to the processor and configured to provide the processor with instructions.
2. The system recited in claim 1 , wherein the processor is further configured to use the entity-specific data field to define a metric that is used in the hosted application.
3. The system recited in claim 1 , wherein executing the hosted application comprises using the entity-specific data field as a filter.
4. The system recited in claim 1 , wherein the hosted application comprises a comparison application.
5. The system recited in claim 1 , wherein the entity-specific data field is available for use by a plurality of hosted applications.
6. The system recited in claim 1 , wherein the processor is further configured to store the extracted values to a data store of a central host component that provides hosted applications to the plurality of entities.
7. The system recited in claim 6 , wherein at least one extracted value is associated with a timestamp.
8. The system recited in claim 1 , wherein the processor is configured to:
receive a modification to the specification included in the configuration data to request extraction of values for the entity-specific data field; and
generate a column in a data store of a central host component, wherein the extracted values for the entity-specific data field are stored in the generated column.
9. The system recited in claim 1 , wherein the query comprises a query for extracting, from the remote data store, all values for the entity-specific data field.
10. The system recited in claim 1 , wherein the query comprises an incremental query for incremental extracting of values for the entity-specific data field from the remote data store.
11. A method, comprising:
accessing configuration data associated with a particular entity in a plurality of entities, wherein the configuration data includes a specification of:
how to extract a set of entity-generated data records from a remote data store associated with the particular entity, wherein the remote data store associated with the particular entity comprises common data elements shared by the plurality of entities and entity-specific data elements specified by the particular entity; and
how the set of entity-generated data records is to be used by a hosted application;
according to the specification included in the configuration data, transmitting, over a network, a set of query parameters to a client component associated with the particular entity, wherein the client component is configured to generate a query for extracting values associated with an entity-specific data field, and wherein generating the query comprises modifying, by the client component, a template query using the set of query parameters;
based at least in part on the generated query, receiving a set of values for the entity-specific data field extracted from the remote data store; and
executing the hosted application, including using at least some of the extracted values for the entity-specific data field according to the specification included in the configuration data.
12. The method of claim 11 , further comprising using the entity-specific data field to define a metric that is used in the hosted application.
13. The method of claim 11 , wherein executing the hosted application comprises using the entity-specific data field as a filter.
14. The method of claim 11 , wherein the hosted application comprises a comparison application.
15. The method of claim 11 , wherein the entity-specific data field is available for use by a plurality of hosted applications.
16. The method of claim 11 , further comprising storing the extracted values to a data store of a central host component that provides hosted applications to the plurality of entities.
17. The method of claim 16 , wherein at least one extracted value is associated with a timestamp.
18. The method of claim 12 , comprising:
receiving a modification to the specification included in the configuration data to request extraction of values for the entity-specific data field; and
generating a column in a data store of a central host component, wherein the extracted values for the entity-specific data field are stored in the generated column.
19. The method of claim 11 , wherein the query comprises a query for extracting, from the remote data store, all values for the entity-specific data field.
20. The method of claim 11 , wherein the query comprises an incremental query for incremental extracting of values for the entity-specific data field from the remote data store.
21. A computer program product embodied in a tangible computer readable storage medium and comprising computer instructions for:
accessing configuration data associated with a particular entity in a plurality of entities, wherein the configuration data includes a specification of:
how to extract a set of entity-generated data records from a remote data store associated with the particular entity, wherein the remote data store associated with the particular entity comprises common data elements shared by the plurality of entities and entity-specific data elements specified by the particular entity; and
how the set of entity-generated data records is to be used by a hosted application;
according to the specification included in the configuration data, transmitting, over a network, a set of query parameters to a client component associated with the particular entity, wherein the client component is configured to generate a query for extracting values associated with an entity-specific data field, and wherein generating the query comprises modifying, by the client component, a template query using the set of query parameters;
based at least in part on the generated query, receiving a set of values for the entity-specific data field extracted from the remote data store; and
executing the hosted application, including using at least some of the extracted values for the entity-specific data field according to the specification included in the configuration data.