Add a Data Connector for Sharepoint Lists in Office 365
Organization Name
State of Maine
Description
State of Maine uses Office 365, and with the COVID-19 Pandemic a proliferation of MS Teams groups is happening. Each team comes with its own Office 365 Sharepoint site, and I am seeing more and more data being collected in Sharepoint Lists. Making a data connector to consume a dataset from an Office 365 Sharepoint List would be an incredible value for the product.
Use Case and Business Need
Data analyst creates a survey using Forms on Sharepoint and saves the data to a list. Data Analyst connects Sharepoint List or DV using Create Data Set function and picks SharePoint list as data source. Data Analyst creates a valuable analysis and shares it with Boss for big wins!
Everyone rejoices!
Original Idea Number: 5e3604103c
Comments
-
There are a lot of data sets in one drive and sharepoint and having a way to extract this data would be very helpful
0 -
That would be useful.
Same goes for Amazon, etc.
0 -
A new use case came forward today. The business has built a low code function using power apps which stores data into a sharepoint list. They have approached us to ingest the data into Oracle Analytics but no good connector is available.
0 -
My company also uses O365. As much as I don't like people creating datasets out of excel, it doesn't look like it's going to stop. We have to use Python to work around this. Having a connector would make it so much simpler.
0 -
Upvoted - will be a useful feature. Thanks
0 -
Planned in the product roadmap: https://community.oracle.com/products/oracleanalytics/kb/articles/32-product-roadmaps
0