![]() ![]() Value of the Client Secret from step “Client secret key generation”.Application (client) ID which will be the Client Id in the data sources configuration.Īfter having followed those sections, you should have gathered these values: After generating the Client secret, copy the Value.In the Certificates & secrets page select the option New client secret.In the Integration assistance section, select Configure a valid credential.Select Delegated Permissions and select AllSites.Read as the permissions.Īfter the API permissions are set we have to generate a new client secret key.In the Request API permissions pop-up select SharePoint. Click on the icon on Configure API permissions and select Go to page.In order to configure API permissions follow the following steps: There are 2 needed configurations that have to be performed to allow the Denodo Platform to access the data in SharePoint: API permissions and client secret generation. Once the evaluation is done, the Recommended configurations are shown.In the newly registered application, click on Integration assistant (on the left side menu) and select Daemon for What application types are you building and select Evaluate my registration.Once the app is registered we will need to grant permissions for clients to access SharePoint Online using the app: Note that http only can be used with localhost, if you have HTTPS enabled in your Denodo Virtual DataPort, then use your hostname instead of localhost. Azure supports adding more redirect URLs to an app but Sharepoint only supports one.Īlthough Azure allows its later modification, this modification will not be synchronized with SharePoint and will not work. Due to a SharePoint limitation, the value you set at this time will be the only one you can use as a redirect URL for this app. For the purpose of this documentation we are using Accounts in this organizational directory only (Default Directory only - Single tenant). T he type of the application support depends on your requirement. Fill in the Support Account Types field.In order to register an app in Azure, follow these steps: Configuring the application in Azureįirst of all, it is necessary to register an App, provide the correct API permissions and generate a client secret in the Azure Portal in order to allow the app (in this case Denodo) to access SharePoint. In all cases it is necessary to register and configure an app in Azure as described below. *NOTE : NTLM authentication is only an option for SharePoint Server, not for SharePoint Online. Retrieve metadata of Files, Folders, Lists or Items (without using the Denodo Templates for SharePoint). The following table summarizes the possible ways to access SharePoint:Īccess metadata of Files, Folders, Lists or Items and basic OData entities on any Sharepoint site. Also, you can connect to SharePoint online through RSS.Excel, JSON, XML and Delimited File Data Sources : to access SharePoint’s REST API to retrieve resources like Files, Lists or Folders.OData2 Custom Wrapper : to access SharePoint OData entities. ![]() In case you do not want to use the templates or require information not available through them, check the other options. Note that, even using the templates, you have to register and configure the app in Azure as explained in this document. If you want to use the Denodo templates for SharePoint take a look at the Denodo Templates for SharePoint - Quick User Guide. T hese templates allow accessing information like Lists, Items, File and Folder Metadata of any SharePoint site. The fastest way that can be enough for many users is to use the Denodo Templates for SharePoint.This document describes all the possible ways to access SharePoint Online from Denodo Virtual DataPort: ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |