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 :)
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
We have a requirement to embed OAC reports within the OCC Marketplace for both Organization and Non-Organization users. Currently, Organization users can access the reports through Oracle Analytics Cloud. However, the requirement is to make these reports available as embedded content within OCC Marketplace. When a user…
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
The difference column is a calculation, and I would like to average that row.
