OAS API

User_MDL0O · Oct 19, 2020 8:53AM

Organization Name

CSE Consorzio Servizi Bancari

Description

OAS API to run DataFlow from an external application. The goal is to centralize the schedule of new DataFlow thorugh an API.

Use Case and Business Need

The goal is to centralize the schedule of new DataFlow thorugh an API.

Original Idea Number: 901495af00

Michal Zima · Oct 20, 2020 6:15AM

Official (published and documented) Oracle Analytics Server API is definitelly a must requirement.
Not only for running DF, but also for manipulating DV Data Sets - like for example:

creating DS
re-uploading file DS
purging BI Server cache entries, connected with particular DS
changing definition of DS
etc...

Mrudula · Apr 4, 2022 10:49AM

We have a similar requirement to invoke the dataflows from an external application like ODI. It would be much helpful if this enhancement is addressed by the development team.

User_0THLM · Aug 16, 2024 5:06AM

It is indeed a very important requirement for us as well. We would need to have REST API end points (Preferably) and/or SOAP end points to handle DV related Artefacts especially to migrate DV workbooks, Datasets, Data Flows, Connections etc. Migrations can also ease out if there are provisions to do it programmatically.

Many a times we need Data flow to run in an event-based manner. We would want to programmatically run the Data flow with our ETL loads or some other event-based activities. Access provisioning is also an impediment most of the times as Data flow does not currently support access provisioning and is very much at user level right now.

Also, the API end points may also help us in managing the DV artefacts, like removing duplicated objects (Datasets, Data Flow, Workbooks, Connections, jobs etc.). We can also possibly perform better quota management.

Michal Zima · Aug 16, 2024 6:29AM

@User_0THLM If you are missing DV API for OAS, pls vote for this my idea:

API for programmatically manipulating DV objects Data Visualization and automate DV tasks in OAS

Michal Zima

Apr 12, 2023

We are striving for more than 3 years (and unfortunately there is no change in newest release of OAS 2023 - this OAS release does not even have first features of REST API introduced during 2022 in OAC - we just learned that this REST API is "bounded" to cloud deployment, thus will not be available in OAS) with inability to programmatically "manipulate" DV objects and automate repetitive DV task (connected with DevOps operations and governance).
Particularly we are missing in OAS following API :
1) Manipulation of data sets
Modification/Creation of data set
Change connection objects for tables in data set
Change data set ownership
Upload/Refresh file based data sets
Refresh cached data sets (based on DB connection)
Possibility to purge BI Server cache, connected with particular data set
Getting data set definitions (get different properties of data sets)
Setting/Getting ACL for data set
2)Manipulation of DV workbooks
Listing DV projects and their key properties (for example data sets used by DV workbook)
Ability to change key properties
3) Data Flows
Ability to run/monitor data flows
Ability to monitor/change jobs for data flows
4) System Settings
programmatically change system setting (showing up in System Settings in DV console )
It can seem, that this Idea is duplicate to existing ones (for example this one: https://community.oracle.com/products/oracleanalytics/discussion/9976/api-for-data-visualization-in-oracle-analytics-server-oac), but it is not - I again stress, that this functionality is required for Oracle Analytics Server (on-premise version of Oracle Analytics platform).
I hope, that this Idea will get Product Management attention.

Thanks

BrandonH · Aug 22, 2024 3:53PM

I would not support this. The maturity level of Data Flows within DV doesn't seem to be enterprise grade at this time. Utilizing them within and enterprise scheduling system would be a bad architecture choice compared to other products on the market for transforming data eg ODI.

Michal Zima · Aug 22, 2024 7:28PM

@BrandonH It is not very much clear, what you would not support ? Just API for manipulating data flows or API for DV as such (for manipulating other DV objects as well - connections, data sets, workbooks….) ? I hope the first option is correct. You are right, that data flows are not at the same level of maturity as dedicated ETL tools (like ODI) and I don’t think it has such ambition. It could just help analytics user with limited knowledge or without access to dedicated ETL tool with simple data manipulations/transformation directly within Analytics suite.

BrandonH · Aug 26, 2024 3:21PM

@Michal Zima My comment was specific to the OP's post / enhancement request (API for dataflows)

Mike Durran-Oracle · Mar 10, 2025 6:37PM

OAS 2025 introduces REST APIs that are configurable using details in the Enterprise Deployment Guide.

https://docs.oracle.com/en/middleware/bi/analytics-server/oasri/index.html

https://docs.oracle.com/en/middleware/bi/analytics-server/enterprise-deploy-oas/installing-and-configuring-oracle-http-server.html#GUID-355836D6-377B-46A2-A4FB-51CCC9B2BACD
(see bi_vh.conf)

Oracle Analytics Cloud and Server Idea Lab

Welcome!

Quick Links

Categories

OAS API

Delivered · Last Updated Mar 10, 2025 6:39PM

Welcome!

Comments

API for programmatically manipulating DV objects Data Visualization and automate DV tasks in OAS

Welcome!