Skip to main content
Version: 2023 R2

SharePoint Site Collection

The source allows you to establish connection and retrieve data from the SharePoint site collection.

SPSiteConnection.png

1. ID​

The data source identifier (if the value is smaller than 0, the source has not been saved in the database yet).

2. Name​

Name of the data source entered by the user.

3. Connection type​

The field allows you to specify a connection type. You can choose from: MSSQL Database, Oracle Database, Exchange Server, OneDrive, SharePoint Site Collection, REST Web Service, and SOAP Web Service.

4. Description​

Description of the data source entered by the user.

5. Environment​

Defines the behavior of the data source in particular environments. The Common tab sets the default parameters that are to be used across all three environments (DEV/TEST/PROD). The tabs dedicated to the individual environments can be used to enter custom parameters. In such case, it is necessary to check the Break inheritance checkbox (this will override the settings specified in the Common tab) and then enter the desired connection settings.

6. Sharepoint environment​

The parameter defines what type of SharePoint environment you will be connecting to. Each SharePoint environment uses different authentication methods for connecting to the site collection. Therefore, the authentication methods that are available will depend on the chosen environment type.

  • SharePoint On-Premises – connects to a SharePoint server installed on any server. Available authentication methods:
    • service account (authentication based on the SharePoint application pool account);
    • custom (authentication based on the provided username and password).
  • SharePoint Online – connects to a SharePoint Online server. Available authentication method:
    • custom (authentication based on the provided username and password)

7. Server and site collection​

Server and Sharepoint site collection addresses.

8. Credentials​

Credentials options.

9. User​

A SharePoint user. For the Windows authentication the field is grayed out.

10. Password​

A Sharepoint user's password. For the Windows authentication the field is grayed out.

11. Test​

Testing the connection to the SharePoint database.