Categories
Ability to use OAC Analysis as an API endpoint for external application (like webpages)
Organization Name
Rogers Communications Canada Inc.
Description
Ability to use OAC report (Analysis/DV) as API endpoint with filtering capabilities. Many times we see a need to use the data present in an analytics system to be available in other systems but if we need to send that data, the process of integration needs to happen all over again similar to ETL (ODI).
If we have a tab in OAC which says "Publish Analysis as API", which reads the report structure and creates filters present in the report as parameters for API call (e.g. month eq 'Jan - 2021' & dept eq 'HR' ...)
OAC URL : https://<service>-<tenant>.analytics.ocp.oraclecloud.com/analytics/
Report name: Headcount
Path: /shared/HR Reports/Dashboard Reports/Drills/Headcount
API: https://<service>-<tenant>.analytics.ocp.oraclecloud.com/analytics/api/v2/Headcount?parameter1=value1¶meter2=value2¶meter3=value3¶meter4=value4
Use Case and Business Need
If we have a tab in OAC which says "Publish Analysis as API", which reads the report structure and creates filters present in report as parameters for API call (e.g. month eq 'Jan - 2021' & dept eq 'HR' ...)
OAC URL : https://<service>-<tenant>.analytics.ocp.oraclecloud.com/analytics/
Report name: Headcount
Path: /shared/HR Reports/Dashboard Reports/Drills/Headcount
API: https://<service>-<tenant>.analytics.ocp.oraclecloud.com/analytics/api/v2/Headcount?parameter1=value1¶meter2=value2¶meter3=value3¶meter4=value4
More details
Adding capability to send data out will take OAC to new heights. REST API capability will be a big asset in this era of integrate-everything.
If we have a tab in OAC which says "Publish Analysis as API", which reads the report structure and creates filters present in report as parameters for API call (e.g. month eq 'Jan - 2021' & dept eq 'HR' ...)
OAC URL : https://<service>-<tenant>.analytics.ocp.oraclecloud.com/analytics/
Report name: Headcount
Path: /shared/HR Reports/Dashboard Reports/Drills/Headcount
API: https://<service>-<tenant>.analytics.ocp.oraclecloud.com/analytics/api/v2/Headcount?parameter1=value1¶meter2=value2¶meter3=value3¶meter4=value4
Original Idea Number: 5230457039
Comments
-
There are some existing SOAP endpoints that may let you programmatically access the data - described in this doc - https://docs.oracle.com/middleware/12213/biee/BIEIT/index.html
Navigate to https://<instance>-<tenancy>-ia.analytics.ocp.oraclecloud.com/analytics-ws/saw.dll/wsdl/v7
0 -
You are correct Mike. SOAP and GO URL integration does exist.
This post use case is to have an endpoint created for data publishing in a way its intuitive. The current SOAP-based integration is a considerably difficult task to accomplish. There are few superstars in this space who have performed this but is not a straightforward activity for the general development community.
Oracle recently released an API gateway, a report acting as an endpoint that could serve as the source to the API gateway.
Thanks for your time in sending documentation. Appreciate it.
0 -
Hi,
IMHO, passing parameters using "get" after the ? on a URL is bound to create problems.
- The url request string may get too long.
- Invalid or special characters in the request string may provoke errors if not treated correctly.
I would like to suggest using POST, as an alternative to GET.
HTH
Marcelo0 -
That's a good idea Marcelo.
0
