0 / 0

Microsoft SharePoint connection

Last updated: Jun 09, 2025
Microsoft SharePoint connection

To access your data in Microsoft SharePoint, create a connection asset for it.

Microsoft SharePoint is a web-based application for you to organize, share, and access data.

Prerequisite

Before you can connect to Microsoft SharePoint connection, you will need to enable the AppConnect connection. This will enable the connection to appear in the list of available connectors for you to use.

Important: You will need to peform the following prerequisites in the pod configuration for the cluster where Cloud Pak for Data is running.

Enabling Microsoft SharePoint connector

To enable the connector, you will need to run the following:

  1. Login to the cluster and enable AppConnect:
    oc login -u <username> -p <password> <host:port>
oc project cpd
oc edit datasift datasift-cr
    Then in the spec section:
    set enableAppConnect: true
  2. Login to the cluster and edit the configmap auto-register-custom-datasource-types with the following details:
    oc login -u <username> -p <password> <host:port>
oc project cpd
oc edit cm config-wdp-connect-connection
    Then in the data section:
    set auto-register-custom-datasource-types: appconnect_mssharepoint:grpc+tls://wdp-connect-adapter-appconnect:443,appconnect_filenet:grpc+tls://wdp-connect-adapter-appconnect:443
    Alternatively, you can manually register by running:
    curl --request POST \
  --url '<API_HOST>/v2/datasource_types' \
  --header 'Authorization: Bearer <TOKEN>' \
  --header 'Content-Type: application/json' \
  --data '{
   "flight_info": {
   	 "flight_uri": "grpc+tls://wdp-connect-adapter-appconnect:443",
   	 "ssl_certificate_validation": "false"
   },
   "origin_country": "us"
}'

Create a connection to Microsoft SharePoint

To create the connection asset, you need these connection details:

  • SharePoint online URL: The SharePoint online URL provides a direct sign-in to the Microsoft SharePoint service. For example: https://anyorganization.sharepoint.com

  • Site path: The path to the site that has stored files.

  • Authentication method:

    • BASIC_SAML:
      • Username and paswword: The username and password for your Microsoft SharePoint account.

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Connect to a data source. See Adding a connection to a project.

In a catalog
Click Add to catalog > Connection. See Adding a connection asset to a catalog.

In a deployment space
Click Import assets > Data access > Connection. See Adding data assets to a deployment space.

In the Platform assets catalog
Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

Microsoft SharePoint setup

Microsoft SharePoint can be set up in various deployments, see Getting started with SharePoint server.

Restriction

You can use this connection only for reading data. You cannot write data or export data with this connection.

Learn more

Parent topic: Supported connections