Oracle Analytics Cloud and Server
Access OAC data from Rest API
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
Answers
-
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.
-
You can find information on the OAC REST API endpoints here - https://docs.oracle.com/en-us/iaas/api/#/en/analytics/20190331/
-
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.
-
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/532897/rest-api-for-oracle-analytics-cloud
But still nothing specific from Product Development, when this is going to be implemented in OAC (and OAS afterwards).
-
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.
-
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.
-
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
-
Currently I am trying to find a solution of the concern:
- Export CSV data from OSvC
- Import data into OAC and create dataset
- Next day export CSV with new data from OSvC
- 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.
-
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)
-
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.
