Microsoft SharePoint ADFS Connector
Intro
Microsoft SharePoint enables an organization to easily create and manage custom team-focused and project-focused sites for collaboration. Use Domo's Microsoft SharePoint ADFS Connector to get the data from an organization-wide intranet portal in different aspects based on their sites. This connector uses ADFS (Active Directory Federation Service) for authentication.
To learn more about the SharePoint API, visit their page (https://msdn.microsoft.com/en-us/lib.../jj860569.aspx).
You connect to your SharePoint account in the Data Center. This topic discusses the fields and menus that are specific to the Microsoft SharePoint ADFS connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.
Prerequisites
To connect to your SharePoint account and create a DataSet, you must have the following:
-
Your SharePoint username and password.
-
The host URL and domain of your SharePoint account. For example, if your SharePoint site was https://my-sharepoint.sample.com, the host URL would be https://my-sharepoint.sample.com and the domain would be sample.
-
Your ADFS host name and realm. Your administrator sets up the ADFS for the SharePoint. The ADFS host name is the server where ADFS is running.
The ADFS realm is set up at the time of SharePoint configuration by the administrator. The realm should in the following format: urn:sharepoint:<WebAppName>
Connecting to Your SharePoint Account
This section enumerates the options in the Credentials and Details panes in the SharePoint ADFS Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.
Credentials Pane
This pane contains fields for entering credentials to connect to your SharePoint account. The following table describes what is needed for each field:
Field |
Description |
---|---|
Username |
Enter your SharePoint username. |
Password |
Enter your SharePoint password. |
Host URL |
Enter the host URL for your SharePoint account. |
Domain |
Enter the domain for your SharePoint account. |
ADFS Hostname |
Enter your ADFS hostname. |
ADFS Realm |
Enter your ADFS realm. |
For more information about these credentials, see "Prerequisites," above.
Once you have entered valid SharePoint credentials, you can use the same account any time you go to create a new SharePoint ADFS DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.
Details Pane
This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.
Menu |
Description |
||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Report |
Select the SharePoint report you want to run. The following reports are available:
|
||||||||||||||||||||||||||||||||||||||||||
Server-Relative URL |
Enter the relative URL for the server containing files or folders you want to retrieve information for. |
||||||||||||||||||||||||||||||||||||||||||
List Title |
Enter the title of the list you want to retrieve information for. |
||||||||||||||||||||||||||||||||||||||||||
List Item ID |
Enter the ID of the list item you want to retrieve information for. |
||||||||||||||||||||||||||||||||||||||||||
Decode Fields (Optional) |
Check this box if you want to decode the column names imported from SharePoint. |
Other Panes
For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.