Get data from the sharepoint to the Dataiku

vinayk
Level 2
Get data from the sharepoint to the Dataiku

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.

 

0 Kudos
4 Replies
MiguelangelC
Dataiker

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

 

0 Kudos
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

0 Kudos
vinayk
Level 2
Author

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

0 Kudos
Turribeach

Have a look at this Python package:

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

 

0 Kudos