JDBC Driver for SharePoint

Build 21.0.8137

SharePoint アプリを使用したクレデンシャルの作成

Follow the steps below to create a custom OAuth app and obtain the connection properties for the OAuth authentication using Sharepoint App.

Steps to Create a Sharepoint App

Follow the steps below to obtain the OAuth values for your app.

Register Add-In

  1. Navigate to the Register Add-In page by entering the url as : https://{sitename}.SharePoint.com/_layouts/15/appregnew.aspx .
  2. On App Information section, click Generate button next to the Client Id and Client Secret textboxes to generate the respective values.
  3. Set Title, App Domain and Redirect URI by filling respective text boxes.
  4. Click Create button, which registers the add-in and returns the success message with created information.

Grant Permissions to Add-In

  1. Navigate to the SharePoint site.
  2. Enter the URL: https://{sitename}.sharepoint.com/_layouts/15/appinv.aspx in the browser. This will redirect to Grant permission page.
  3. Enter the Client ID(which we have generated earlier), in AppId textbox and click Lookup button. That will populate the value to other textboxes in Title, App Domain and Redirect Url.
  4. Now enter the below permission request in XML format.
        AppPermissionRequests AllowAppOnlyPolicy="true"
         AppPermissionRequest Scope="http://sharepoint/content/tenant" Right="FullControl"
        AppPermissionRequests
  5. When you click on Create you'll be presented with a permission consent dialog. Press Trust It to grant the permissions.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137