Connector Dialog for SharePoint
Enter values into the dialog box to connect and fetch data from your SharePoint server. Note that this connector abstracts the underlying SharePoint site into tables and views. It does not retrieve the contents of your SharePoint site.
Options
Field |
Description |
URL |
The base URL for the SharePoint site. Note that the URL must be a base URL of the site/sub-site of the SharePoint site. The following are examples of valid URLs:
You may encounter errors if you include more than the base URL. |
User ID |
A valid User ID required to log-on to the data source. |
Password |
A valid Password required to log-on to the data source. This password must match the User ID above. |
Authentication Scheme |
Select the appropriate scheme from the drop-down list.
|
IP Version |
Select the appropriate IP Version from the drop-down list. Select:
By default Autodetect is selected. |
SharePoint Edition |
Select if SharePoint is On-Premise (e.g. hosted on-site) or Online (e..g. hosted on the cloud). Select Online if you want to connect to a SharePoint source using Single Sign On (SSO). |
Other Connection Options |
Connection options required to connect to the data source. If you need multiple string connection options, separate these by a semi-colon. However, you can only enter up to a maximum of 512 characters into this text box. Important Note: This version of the connector does not currently support Multi-Factor Authentication (MFA). You can use the Altair ODBC Driver for Sharepoint to connect to instances of Sharepoint that use MFA. To connect using the ODBC Driver, use OAuth as the Authentication Scheme:
|
Use SSO |
When selected, instructs Data Prep Studio to connect to SharePoint via SSO. |
Tables and Views Section |
Allows you to load, and then select, the tables from your database by manually selecting from a list. To load tables and views via search and select:
Note: If you wish to add a duplicate column, select this column from the Add a duplicate column drop-down list provided.
To select a column: Check the boxes beside the columns you want to use. If you want to use all columns check the Column box on the header.
To aggregate columns:
If the data returned are to be aggregated, check the Aggregate box on the header, then select the aggregation method you want to use for each column. The following aggregation methods are possible for each data type:
To filter columns:
If the data returned are to be filtered, check the Apply Filter on the header. Then, for each column, select a filter method from the filter drop down and then enter the filter value in the Filter Value box. Note that some data sources require case-sensitive filter values. Refer to this list to check which data sources have case-sensitive filters. To load tables and views using an SQL Query, select the Query tab |
Query |
Allows you to load, and then select, the tables from your database by entering a SQL Statement. If you already selected Tables and Views, this box is updated to show the corresponding SELECT * FROM TABLE query. If you want to define the query, enter the SELECT, EXEC, and/or WITH statements to execute. Notes
|
Preview Data |
Click to fetch data using the credentials and criteria you have specified. This allows you to confirm your connection, ensure you have connected to the correct table, check your query, and verify the information that will be loaded. Notes:
|