Access OAC data from Rest API

ahmad salman

Summary

How we can access OAC data (from classic dashboard or DV) from Rest API

Content

What are the available options to access OAC data (both classic dashboard and DV projects) from webservices/ Rest API? we need to expose the data for Oracle Digital Assistant.

 

Thanks,

Ahmad

Jan Zahradka-Oracle

I am also interesting in such information regarding REST API access to data in OAC. Is somewhere a description of available API endpoints? Thank you.

Joel Acha11111

You can find information on the OAC REST API endpoints here - https://docs.oracle.com/en-us/iaas/api/#/en/analytics/20190331/

Indranil Basak-Oracle

This is interesting. I am also looking such rest API information to access OAC data through REST API and also is this any capability OAC DV connect API for visualization.

Michal Zima

Hi there,

API mentioned by @Joel Acha (as per description) is just for managing OAC instances (creating, deleting, listing etc...), but API for managing DV objects itself (data sets, connections, data flows, DV projects) and also for data access (speaking about DV part, not "classical" OBIEE) as asked by @Jan Zahradka-Oracle is still missing - there are couple of Ideas created for this in Idea Labs :

https://community.oracle.com/customerconnect/discussion/579754/ability-to-use-oac-analysis-as-an-api-endpoint-for-external-application-like-webpages

https://community.oracle.com/customerconnect/discussion/532897/rest-api-for-oracle-analytics-cloud

https://community.oracle.com/customerconnect/discussion/541161/api-for-data-visualization-in-oracle-analytics-server-oac

But still nothing specific from Product Development, when this is going to be implemented in OAC (and OAS afterwards).

SteveF-Oracle

The original post is looking for REST API for ODA specifically.

If the use-case is embedded data externally, then there are some other options.

@Mike Durran has some nice blogs on that topic, just sharing here if readers use-case is not specific to API access for ODA.

https://insight2action.medium.com

Jan Zahradka-Oracle

Thank you all.

The original reason I need to access OAC data is to update some data via API regularly. Because we are getting data from Oracle Service Cloud via API and want to push them in OAC to have a fresh set of data.

Alan Lee - Oracle

For data access from OAC, please see option to use JDBC: https://docs.oracle.com/en-us/iaas/analytics-cloud/doc/query-data-models-remotely-using-jdbc.html

Jan Zahradka-Oracle

Currently I am trying to find a solution of the concern:

1. Export CSV data from OSvC
2. Import data into OAC and create dataset
3. Next day export CSV with new data from OSvC
4. Automatically update dataset in OAC (tried OAC DataSync, JDBC, SQL client,...)

I didn't found how is stored CSV in OAC (table name), if it is accessible via JDBC or Data Sync.

Do you have any idea or hint? Thank you.

Joshua C. Stewart

Is there a reason you can't use a database source?

You could export csv from OSvC

Load .csv to database table

Create OAC Data Set with connection to the table in the database (Live connection)

Jan Zahradka-Oracle

Yes, there is a significant reason: we need to use data which is not accessible via live OSvC Connection (KM data, specifically OKCS tables). Because we need to refresh data daily, we are searching an automatic way how to do it. That's why I use a Java script for run report in OSvC, get data, export data in CSV. Now I am stuck. I need to push data into OSC to replace "old" data loaded from CSV day before.

I appreciate all your help here. Thank you so much.