IBM watsonx.data SharePoint connection

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

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

Prerequisite

Before you can connect to IBM watsonx.data 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.

Enabling IBM watsonx.data 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 IBM watsonx.data 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 IBM watsonx.data 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 IBM watsonx.data SharePoint account.

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Federal Information Processing Standards (FIPS) compliance

This connection cannot be created in a FIPS environment.

IBM watsonx.data SharePoint setup

IBM watsonx.data SharePoint can be set up in various deployments, see Getting started with SharePoint server.

Supported file types

The IBM watsonx.data SharePoint connection supports structured and unstructured file formats.

The connection supports the following structured file types: Avro, CSV, Delimited text, Excel, JSON, ORC, Parquet, SAS, SAV, SHP, and XML.

The connection supports modes for reading and writing binary data. These modes can be used to read and write the unstructured data formats such as: DOC, DOCX, MD, PDF, PPT, PPTX, and TXT.

Restriction

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

Learn more