You can translate the question and the replies:

Cannot connect and model data from Sharepoint Online Lists.

There is no apparent way to connect Denodo to Sharepoint Online (O365). The article below details how to connect to sharepoint, but I believe it only pertains to Sharepoint on-premise. We currently utilize Denodo 6, but we are looking to move to Denodo 7. If it's not possible to do this in Denodo 6, is it possible with 7? https://community.denodo.com/answers/question/details?questionId=9060g0000000BL3AAM&title=Connect+to+Office+365+Sharepoint+List
user
19-08-2019 14:58:40 -0400

4 Answers

Hi, Virtual DataPort can connect to Sharepoint online using OData Custom Wrapper with OAuth 2.0 authentication. I would follow the steps mentioned in the below Knowledge Base article for a successful connection. * [Connecting to Sharepoint Online from Denodo](https://community.denodo.com/kb/view/document/How%20to%20connect%20Denodo%20to%20Sharepoint%20Online%20using%20OData%20with%20OAuth%20authentication?category=Security) Though the document mentions that its applicable for Denodo 7.0, I have seen cases where it works successfully in Denodo 6.0 as well. If you are a user with support access and have troubles in configuring the connection, I would suggest you to raise a support case in the [Denodo Support Site](https://support.denodo.com/). Hope this helps!
Denodo Team
20-08-2019 08:11:22 -0400
We ran into numerous issues when trying to configure Sharepoint Online. It turned out we need to "allow" a large number of URLs in our firewall in order to make this work. Unfortunately, the error messages makes it appear as though it's a Denodo or Permissions issue, when in fact we weren't able to connect to the necessary MSFT urls to get token information. We ended up performing packet captures to identify all of the URLs in question.
user
22-08-2019 12:01:34 -0400
Hello "user" - Were you finally able to connect? We are expriencing the same issue, even after 2 session with Support. Difficulty was getting access token and refresh token values.
user
22-08-2019 17:31:57 -0400
we did. it was a long painful process, but we eventually got it working. Ill try to find our notes on all the steps we took to make it work
user
22-08-2019 17:50:01 -0400
You must sign in to add an answer. If you do not have an account, you can register here