0 / 0

Microsoft SharePoint connection

Last updated: Jul 04, 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 perform the following prerequisites in the pod configuration for the cluster where Cloud Pak for Data is running.

Enabling Microsoft SharePoint on Cloud

This connection is only available through the Toronto data center and is only available for a managed cloud service provider (MCSP).

If you have created a platform assets catalog, the Microsoft SharePoint connector should automatically appear in the list of available connectors.

For more information on creating the platform assets catalog, see Creating the Platform assets catalog.

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