REST API to create a new dataset in OAC

DeepaliG-Oracle

I know there is an REST endpoint to Reload the data for an existing dataset. Is there an API or any other way to create a new dataset too? 

Gianni Ceresa

https://community.oracle.com/products/oracleanalytics/discussion/19998/rest-api-to-create-a-new-dataset-in-oac

There is an API, because that's what DV does use: an API. It simply isn't documented... Therefore it depends how badly you need/want it ;-)

Open your browser developer tool, looks at the network calls the UI generate and you easily see how you can automate and script things.

Documented? No. Supported? Not officially, but that's how the UI does it, therefore implicitly it is supported.

You just have to evaluate if the efforts and risks are worth the benefits you get from it.

Mallikarjuna Kuppauru-Oracle

Hi ,

Reload data for a dataset (Preview) is an preview feature. As per documentation , we don't have any API call for RESET dataset creation.

How To Refresh Data Sets Automatically in Oracle Analytics (Doc ID 2578915.1)

You can submit can Idea's Lab Request -

How to Submit an Enhancement Request for Your Oracle Cloud Application through Idea Labs on Cloud Customer Connect (Doc ID 2254478.1)

Any Other comments are welcome

Regards,

Arjun

SteveF-Oracle

@DeepaliG-Oracle see: Connect to Data from REST Endpoints (Preview)

It needs to be enabled by an Admin in the console --> system settings

Michal Zima

@SteveF-Oracle I guess, you didn’t get the essence of this query (I judge by your recommendation).

@DeepaliG-Oracle There are already plenty of Ideas for the same (rich Rest API, allowing manipulation of different DV objects, including data sets) see for example:

https://community.oracle.com/products/oracleanalytics/discussion/18832/api-for-programmatically-manipulating-dv-objects-data-visualization-and-automate-dv-tasks-in-oas

or (which is wrongly set in Delivered status):

https://community.oracle.com/products/oracleanalytics/discussion/9976/api-for-data-visualization-in-oracle-analytics-server-oac

So you don’t have to create new one, you can vote for one of them.

As @Gianni Ceresa pointed, there is internal , very rich (in opposite to one which is public in OAC) REST API for DV used internally in product, the only drawback is that Oracle is not making it public, so the usage is not supported and is also not documented.

For this public REST API - this is according to me most overlooked area , new extensions are created very slowly, and the worst thing for us OAS customers is, that so far it is not even available in OAS (just OAC).

GayathriAnand-Oracle

If you see the FY24 Roadmap link posted by Ben, you will find the following features in the upcoming release :

OAC Catalog API

OAC Connections API

Not sure if OAC Connections API will also include enriched APIs for Dataset Management, maybe PMs in this forum can comment on that.

Thanks

Gayathri

SteveF-Oracle

@Michal Zima - Yes, I got the gist. This is an Oracle employee that had already posted to an internal channel (multiple requirement), appreciate the catch. I can see how my comment could be confusing in this context. ;-)

Enjoy your day, and thanks for your helpful comments in the community!

@Bret Grinslade - Oracle Analytics-Oracle - Let us know if you have any further public comments about the roadmap.

Michal Zima

@SteveF-Oracle . Got it, thanks for explaining me the internals.