Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 314 Oracle Analytics and AI News
- 58 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Exporting data from REST API OAC to CSV/XML/JSON or similar format
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.
Best Answers
-
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.htmlRegards
Mike3 -
If you have not already, please file an Ideas Lab request for features that are not currently present in the product.
2
Answers
-
-
Did you also consider a DV dataflow? It can write the resulting dataset into a database table.
3 -
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:
- A native file type within Iceberg
- Typed columns (Integer, Decimal, Floating Point, Date, Datetime, etc.), plus null handling
- automatically compressed on save (similar to 7zip's native compression) without the separate step
- Supported as a data source by most major BI tools (i.e., Power BI - http://learn.microsoft.com/en-us/power-query/connectors/parquet)
- Well supported with the Python ecosystem (Polars, DuckDB, Pandas, etc.)
2 -
@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!
2 -
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
0 -
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
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)
0 -
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.1 -
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 :)
0
