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

AllwinJayapal

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

Mike Durran-Oracle

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

 

AllwinJayapal

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.

Marcelo Finkielsztein

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
Marcelo

AllwinJayapal

That's a good idea Marcelo.