Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Planned

Reporting

Data Modelling and Datasets

Analysis and Data Visualization

Developers

Status: Planned

Comments

Manav Purohit

There are a lot of data sets in one drive and sharepoint and having a way to extract this data would be very helpful

Marcelo Finkielsztein

That would be useful.

Same goes for Amazon, etc.

Jeff Jordan

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.

Branden Pavol

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.

Parag Hiremath

Upvoted - will be a useful feature. Thanks

Benjamin Arnulf-Oracle

Planned in the product roadmap: https://community.oracle.com/products/oracleanalytics/kb/articles/32-product-roadmaps

Brett Wist

Like others have stated, there is an uptick in the use of M365 Lists (and other SharePoint "data") and some of our business analysts are gravitating to PowerBI for connecting to the SharePoint data. It would be helpful to be able to keep those users in the OAC world and to be able to easily integrate the SharePoint data with the rest of the OAC/OCI infrastructure.

Joseph Thomas

https://community.oracle.com/products/oracleanalytics/discussion/comment/51436#Comment_51436

Was this implemented?

Benjamin Arnulf-Oracle

@Joseph Thomas Please check our idea lab rules: https://community.oracle.com/products/oracleanalytics/kb/articles/93-idea-labs-rules

Bhaskar Konar

It'll be a very useful feature to have. Upvoted.