Using CSV files in Sharepoint or Onedrive

Joseph Thomas

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

Benjamin Arnulf-Oracle

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.

Joseph Thomas

Thanks for the update. What are the other options to automate file upload and refresh the reports?

Benjamin Arnulf-Oracle

You can refer to the Microsoft help on Automating File Uploads to Sharepoint using Power Automate.

Gianni Ceresa

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?

Joseph Thomas

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