Oracle Communities

Oracle Analytics and AI

Child Item

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&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.

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

Find more posts tagged with

Reporting

Data Connectivity

Data Modelling and Datasets

Analysis and Data Visualization

Needs Votes

Status: Needs Votes

Comments

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.