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.
Answers
-
Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 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
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,124 Neuron
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
-
@MiguelangelC
@Turribeach
Thank you for the response, I have edited the question and made it bit more clear. -
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,124 Neuron