Hi,
I'd like to export data from an OAC analysis or workbook via the REST API to CSV, XML,JSON, or another format that's easy to import into a database.
If this isn't possible via the OAC REST API, perhaps there's another similar solution.
Please could you log this as an idea in the ideas lab - it's something we'd like to implement for the REST API.
Currently, you'd need to use the SOAP APIs: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/c_xmlviewservice_service.html https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/to_analysisexportviews_service.html
Regards Mike
@Ambient
If you have not already, please file an Ideas Lab request for features that are not currently present in the product.
Try following these examples
https://docs.oracle.com/en-us/iaas/Content/Identity/api-getstarted/Exporting.htm
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/export-data-csv-and-tab-delimited-files-text.html
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/examples-system-setting-rest-apis.html#GUID-27E789A9-7E46-4BB9-A99B-1C27DEAD1726
https://medium.com/oracledevs/get-to-know-the-oracle-analytics-rest-apis-e547fa0bf575
Did you also consider a DV dataflow? It can write the resulting dataset into a database table.
I'd also like to lobby for adding Parquet to the list of supported output formats, given that Oracle now officially supports the Iceberg Metadata/Catalog standard (https://www.oracle.com/news/announcement/ai-world-oracle-introduces-autonomous-ai-lakehouse-2025-10-14/).
Parquet Benefits:
@User_6WR9W , Welcome to the Oracle Analytics Community!
While there is not REST API support yet, have you considered extracting data from source instead of OAC. It might be faster provided you can come up with the query. Hope it helps!
Hello,
Thank you for all the responses above. I have looked into the topic and, unfortunately, there is currently no perfect solution for us. We decided to send data files via the OAC agent to email, but unfortunately this is not sufficiently automated, as someone still needs to load the data into the target system.
Since some of you suggested creating an idea in Idea Lab, I have created one. I kindly ask everyone interested in extending the OAC REST API functionality to vote for this idea — this will increase the likelihood of extending the REST API capabilities:
Link to the idea: Extend OAC REST API for Data Export in Machine‑Readable Formats — Oracle
Hi @K Nowak ,
I'm not fully sure where the idea was posted, as it has a Cloud Customer Connect link (a separate forum, not in charge of Oracle Analytics products).
The right place for it would be https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server
Your idea doesn't show in this location, even if that's where the link on top of your posted idea takes me. That's why I don't know where exactly your idea currently landed.
You may want to just repost it in the link I posted here, so it is in the right location for the Oracle Analytics product management team to see it and consider it.
Out of curiosity, what is your target database? (To better understand how nothing existing can do the job in a fully automated way based on a schedule)
Hi
Thanks for pointing that out @Gianni Ceresa - I've reposted my idea and changed the link to the idea in the post above to Community Idea Lab. The number of Oracle sites is a bit confusing. Answering Your question: The target database currently consists of Oracle and MS SQL Server. Data can be transferred from both databases using ETL, but our organization needed to minimize the amount of ETL and enable users to create reports themselves in OAC and automatically retrieve data via the OAC REST API. This minimizes work for our department when new reports from existing areas of interest are required or changes are needed to the reports being sent – the user can make all changes on their own. We only provide pre-built areas.
Ok, I better see your case and how the current options aren't fully helping you much.
I believe that what you would like is the "classic" SOAP webservice able to execute LSQL queries but in the new OAC REST API. There still isn't such a method documented in the REST API of OAC (but I believe there is an undocumented internal API able to do that).
With such a method, your users could just provide the LSQL (they can easily copy/paste it from their "classic" analysis or take it from the execution logs of their workbook etc.), and a simple REST call later you get a json with your data.
Good thing is Mike is in this thread already :)
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
