Oracle Analytics Cloud and Server Idea Lab

Products Banner

Ability to use OAC Analysis as an API endpoint for external application (like webpages)

Submitted
194
Views
4
Comments

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&parameter2=value2&parameter3=value3&parameter4=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&parameter2=value2&parameter3=value3&parameter4=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&parameter2=value2&parameter3=value3&parameter4=value4

 

 

 

Original Idea Number: 5230457039

OAC API flowchart.png

7
7 votes

Submitted · Last Updated

Comments