You can translate the question and the replies:

Error creating share point excel data source connection

Getting the following error while creating a sharepoint excel data source connection in Denodo. Authentication is using OAuth 2.0 "Error while executing custom wrapper method 'getSchemaParameters': Cannot establish the connection"
user
15-08-2023 22:56:33 -0400
code

1 Answer

Hi, It feels like a connectivity issue to me. Please make sure VDP is able to connect to the SharePoint server, you can click the 'Test Connection' button from the Data Source page. Please also review the steps of the following KB article with respect to your environment: [HOW TO INTEGRATE DENODO WITH SHAREPOINT ONLINE](https://community.denodo.com/kb/en/view/document/How%20to%20integrate%20Denodo%20with%20SharePoint%20Online). You should have configured Azure registering an app, providing grant and generating a client secret: [Configuring the application in Azure](https://community.denodo.com/kb/en/view/document/How%20to%20integrate%20Denodo%20with%20SharePoint%20Online#h.nez39bgl6wjk). Later on, also check the steps of the method you are using to retrieve Excel files: * [Connecting to SharePoint using Excel, Delimited File, JSON and XML data source](https://community.denodo.com/kb/en/view/document/How%20to%20integrate%20Denodo%20with%20SharePoint%20Online#h.ho6woaxv5ag1) that allows you to create a single SharePoint resource with an Excel Data Source. * [Denodo Templates for SharePoint](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Templates%20for%20SharePoint%20-%20Quick%20Use%20Guide) which is the best way to navigate SharePoint resources, using a custom Data Source to retrieve OData entities. If you still have the error and have an active support account, you could open a support ticket and the support team will assist you. I hope this helps.
Denodo Team
22-08-2023 02:28:39 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here