Processing cloud services and intelligence cloud services integration
Various embodiments provide for integrating process cloud services (PCS) with intelligence cloud service (ICS). PCS analytics data is obtained using one or more PCS analytics data export application programming interfaces (APIs). A semantic model is provided to a predefined ICS system. The PCS analytics data is transferred to an ICS integration service. The PCS analytics data is converted into a format for a target intelligence system. The converted PCS analytics data is transferred to a service for later distribution as star schema data, for use by Representational State Transfer (REST) Application Programming Interfaces (APIs). The PCS analytics data is transferred from the ICS integration service to the predefined ICS system, for use by the ICS integration service to integrate PCS with the ICS system.
1. A tangible processor-readable storage device comprising instructions executable by one or more processors, that when executed by the one or more processors perform a method of integrating process cloud services (PCS) with an intelligence cloud service (ICS), wherein the method comprises:
obtaining PCS analytics data using one or more PCS analytics data export application programming interfaces (APIs);
providing a semantic model to a predefined ICS system;
transferring the PCS analytics data to an ICS integration service;
converting the PCS analytics data into a format for a target intelligence system;
transferring the converted PCS analytics data to a service for later distribution as star schema data, for use by Representational State Transfer (REST) Application Programming Interfaces (APIs); and
transferring the converted PCS analytics data from the ICS integration service to the predefined ICS system, for use by the ICS integration service to integrate PCS with the ICS system.
2. The tangible processor-readable storage device as recited by claim 1 , wherein the method further comprises:
publishing the REST APIs.
3. The tangible processor-readable storage device as recited by claim 2 , wherein the publishing of the REST APIs further comprises:
publishing the REST APIs with query parameters for listing archives from the star schema data after a start date and for listing archives from the star schema data till an end date.
4. The tangible processor-readable storage device as recited by claim 2 , wherein the method further comprises:
receiving a request, from the target intelligence system, for a portion of the PCS analytics data from the star schema data, wherein a published REST API is used for the request; and
providing the portion of the PCS analytics data from the star schema data to the target intelligence system in response to the request from the published REST API.
5. The tangible processor-readable storage device as recited by claim 1 , wherein the target intelligence system is outside of an analytics archive and export service system that includes the PCS and the predefined ICS system.
6. The tangible processor-readable storage device as recited by claim 1 , wherein the method further comprises:
creating the semantic model in the predefined ICS system as part of synchronizing the PCS analytics data to the predefined ICS system, wherein the semantic model includes tables with a format <PREFIX>_<DATAOBJECT_NAME>.
7. The tangible processor-readable storage device as recited by claim 1 , wherein the predefined ICS system is a business intelligence cloud service (BICS).
8. The tangible processor-readable storage device as recited by claim 1 , wherein the format is JAVA SCRIPT® object Notation (JSON) format.
9. The tangible processor-readable storage device as recited by claim 1 , wherein the method further comprises:
providing stored archives by storing incremental archives of the PCS analytics data to the star schema data; and
regularly purging old data from the star schema data that is not updateable.
10. The tangible processor-readable storage device as recited by claim 9 , wherein the method further comprises:
periodically exporting the incremental archives of the star schema data, wherein the star schema data was updated between a last archive time stamp and a current time stamp.
11. A method of integrating process cloud services (PCS) with an intelligence cloud service (ICS), the method comprises:
obtaining PCS analytics data using one or more PCS analytics data export application programming interfaces (APIs);
providing a semantic model to a predefined ICS system;
transferring the PCS analytics data to an ICS integration service;
converting the PCS analytics data into a format for a target intelligence system;
transferring the converted PCS analytics data to a service for later distribution as star schema data, for use by Representational State Transfer (REST) Application Programming Interfaces (APIs); and
transferring the converted PCS analytics data from the ICS integration service to the predefined ICS system, for use by the ICS integration service to integrate PCS with the ICS system.
12. The method as recited by claim 11 , wherein the method further comprises:
publishing the REST APIs.
13. The method as recited by claim 12 , wherein the publishing of the REST APIs further comprises:
publishing the REST APIs with query parameters for listing archives from the star schema data after a start date and for listing archives from the star schema data till an end date.
14. The method as recited by claim 12 , wherein the method further comprises:
receiving a request, from the target intelligence system, for a portion of the PCS analytics data from the star schema data, wherein a published REST API is used for the request; and
providing the portion of the PCS analytics data from the star schema data to the target intelligence system in response to the request from the published REST API.
15. The method as recited by claim 11 , wherein the target intelligence system is outside of an analytics archive and export service system that includes the PCS and the predefined ICS system.
16. The method as recited by claim 11 , wherein the method further comprises:
creating the semantic model in the predefined ICS system as part of synchronizing the PCS analytics data to the predefined ICS system, wherein the semantic model includes tables with a format <PREFIX>_<DATAOBJECT_NAME>.
17. The method as recited by claim 11 , wherein the predefined ICS system is a business intelligence cloud service (BICS).
18. The method as recited by claim 11 , wherein the format is JAVA SCRIPT® object Notation (JSON) format.
19. The method as recited by claim 11 , wherein the method further comprises:
providing stored archives by storing incremental archives of the PCS analytics data to the star schema data; and
regularly purging old data from the star schema data that is not updateable.
20. An apparatus comprising:
one or more processors; and
a tangible processor-readable storage device including instructions for:
obtaining process cloud services (PCS) analytics data using one or more PCS analytics data export application programming interfaces (APIs);
providing a semantic model to a predefined ICS system;
transferring the PCS analytics data to an intelligence cloud service (ICS) integration service;
converting the PCS analytics data into a format for a target intelligence system;
transferring the converted PCS analytics data to a service for later distribution as star schema data, for use by Representational State Transfer (REST) Application Programming Interfaces (APIs); and
transferring the converted PCS analytics data from the ICS integration service to the predefined ICS system, for use by the ICS integration service to integrate PCS with the ICS system.