Destination SharePoint location

To specify a SharePoint URL of a site, in which you wish to integrate data from an external data source, perform the steps given below:

1. The Destination SharePoint location step appears as shown below:
2. Specify a valid SharePoint URL in the URL textbox. External Data Connector will load all the lists from the specified SharePoint site, if the site URL and authentication is valid.
3. Specify the Authentication type and user credentials to connect to the SharePoint URL using the options given below :
a. Specify the Authentication Type
  • Windows Authentication
  • Forms Authentication
  • Office 365 Cloud based identity
  • Federated Authentication
b. Specify the user credentials

Specify the user context stored in the user profile (OR) Enter the user name in any ONE of the following formats: \,UserName@DomainName, UserName and its corresponding password. External Data Connector will initiate Windows authentication or Forms authentication depending on configuration in the destination SharePoint site. Click Next button to proceed.

External Data Connector will store the user credential to connect to SharePoint in the Microsoft Windows Stored User Names and Passwords applet / Credential Manager for security reasons. The stored user profile is tied to the user context (currently logged on user account) in which the profile is created.

Click ... button to create new user profile. Click here to view the details about Profile Manager dialog.

Select Federated Identity in Authentication Type combo to connect to a SharePoint site (SharePoint On-premise or SharePoint Online) using federated identity configured using ADFS. Also, select this option to connect to Office 365 SharePoint Online configured using federated identity provider.

To connect to Office 365's SharePoint Online environment, you can use Web Single Sign-on option for both Cloud Identity (Office 365 Online User Credential e.g., and Federated Identity (configured via ADFS e.g.,
Upon clicking Next button to proceed, you will be prompted for credential (username and password) as shown below:
Provide ID and Password in the respective textboxes and click Sign in button to proceed.