Get data from the sharepoint to the Dataiku

vinayk

Hello Team,

Kindly help how can I get the data from the sharepoint(file uploaded to onedrive) to the dataiku and use it, the sharepoint data which is excel file uploaded to onedrive is updated daily and I have to get the updated information as well from the file in onedrive.

Kindly let me know how this can be done.

Thanks in advance.

Miguel Angel

Hi Vinayk,

There are different ways this can be achieved:

1) You can use a plugin: https://www.dataiku.com/product/plugins/sharepoint-online (Only valid if you are using Sharepoint Online)

2) Connect directly to Sharepoint's backend database

3)Download the data in CSV, Excel or XML format and reimport it in DSS

4) Use python to extract the information, using for example the sharepoint module: https://pypi.org/project/sharepoint

Turribeach

Sharepoint is a vast collaborative platform and as such has many different ways of storing data. Exactly how is your data stored in Sharepoint? Is it a Sharepoint List? Is it a document? etc etc etc

vinayk

@MiguelangelC
@Turribeach
Thank you for the response, I have edited the question and made it bit more clear.

Turribeach

Have a look at this Python package:

https://pypi.org/project/sharepy/#description