Overview

SharePoint Connection Manager is SSIS Connection Manager for establishing SharePoint connections. Use the API to build components based on SharePoint Connection Manager.


Setup

Use the SharePoint Connection Manager dialog to specify parameters for connecting to SharePoint service.

Server Parameters

Specify deployment type. This parameter has the options listed in the following table.

Value Description
Premise Connect to on-premise SharePoint server.
Online Connect to SharePoint Online (Office 365) service.

Specify the name or IP address of the SharePoint server.

Specify user name to access SharePoint. If not specified, the connection will be established using Windows authentication.

Specify password to access SharePoint.

Specify the number of seconds before timing out session connect. The default value of this parameter is 100 seconds.

Specify if all clients should use the same connection. This parameter has the options listed in the following table.

Value Description
True All clients use same connection (default).
False Every client use different connection.
Test Connection

Confirm connection manager configuration by clicking Test Connection.


Proxy Parameters

Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Specify the port number on the proxy server to use for the connection.

Specify user name to access the proxy server.

Specify password to access the proxy server.


FAQ

  • We recommend using the Fiddler tracing application. Make sure you enable HTTPS tracing option before you start your trace.

  • You have to configure the client machine accessing the server to use by default Windows authentication. For more information, check the following article.


Related documentation