What are the connection options available on OAC for Sharepoint or Onedrive. I want to automate the upload of the files to Sharepoint/Onedrive, which can be picked by OAC. What are the best solution options
Hi, thank you for your question and welcome to the community!
The connectors for Sharepoint and Onedrive will be available in the near future. This is being developed and planned as part of the product roadmap available in the community knowledge base.
Thanks for the update. What are the other options to automate file upload and refresh the reports?
You can refer to the Microsoft help on Automating File Uploads to Sharepoint using Power Automate.
Hi @User_X7U2V , do you mean automate file upload and refresh reports in OAC?
Do you mind if we take a step back to understand your situation/case and be able to answer based on that instead of guessing?
You have some OAC content, probably DV workbooks built on top of one or more dataset, right?
And now you would like to know how you can refresh the content of those dataset so that, when your users open the workbooks, they see fresh data and not the same old copy all the time?
What is your source?
Hi @Gianni Ceresa ; That is correct. Our data comes from multiple data sources - Oracle DB ( Onprem), ADW, etc. But we also have a good number of CSV/Excel as sources. Instead of the developer manually uploading/reloading these files into Datasets, I am looking at options to have the end user upload to a shared folder with OAC refreshing the data from there. I am ruling out OCI storage and custom ETL to load to tables etc for now. OAC to access CSV files in storage and report based on the latest data in CSV/Excel
This feature is still not available in FDI
Is there a timeline for this feature? Was hoping to see it this year with the collaboration between MS and Oracle
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?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
