Microsoft SharePoint

This page shows how to set up and use the Microsoft SharePoint destination. The Microsoft SharePoint destination loads data into a custom list on a SharePoint server.

Requirements

To extract data into a SharePoint Custom list, you need either your own SharePoint server or access to a SharePoint Online system as part of Office365.

SharePoint On-Premises

Configure your SharePoint server for remote access. Go to Central Administration -> Application Management -> Configure alternate access mappings and add an appropriate mapping for the zone "Internet".

For more information, see Microsoft Documentation: SharePoint - Configure alternate access mappings for SharePoint Server.

SharePoint Online

Set up Service Principal authentication with Microsoft Entra ID (formerly Azure Active Directory), e.g., using the Azure AD Apps-Only approach or the SharePoint AppRegNew.aspx page as shown below:

1. Make sure to have a SharePoint Administrator or Site Collection Administrator role to register an app in SharePoint Online. The app runs within the context of a SharePoint site, and appropriate permissions for that site are necessary to complete the registration process.
2. Access https://{sharepoint-domain}/sites/{site-name}/_layouts/15/appregnew.aspx and enter an app title, the app domain (www.localhost.com) and a redirect URI (https://localhost.com).
   Example URL: https://myorganization.sharepoint.com/sites/MARA/_layouts/15/appregnew.aspx.
3. Save the app and copy the displayed Client ID and the Client Secret. Note that the secret can only be viewed immediately after creation, so make sure to store it in a safe location.
4. Access https://{sharepoint-domain}/sites/{site-name}/_layouts/15/appinv.aspx and paste the Client ID into the field App ID to lookup the properties of the app.
   Example URL: https://myorganization.sharepoint.com/sites/MARA/_layouts/15/appinv.aspx.
5. Paste the following permissions into the field Permission Request XML:

   <AppPermissionRequests AllowAppOnlyPolicy="true">
   <AppPermissionRequest Scope="http://sharepoint/content/sitecollection/web"
   Right="FullControl" />
   </AppPermissionRequests>
   

6. Click [Create] and confirm trust when prompted.

Once authentication is set up, you can create Microsoft SharePoint destinations in Xtract Universal.

Create a new Microsoft SharePoint Destination

Follow the steps below to add a new Microsoft SharePoint destination to Xtract Universal:

1. In the main window of the Designer, navigate to Server > Manage Destinations. The window “Manage Destinations” opens.
   
2. Click [Add] to create a new destination. The window "Destination Details" opens.
   
3. Enter a Name for the destination.
4. Select the destination type Microsoft SharePoint from the drop-down menu. A list of connection details opens.
5. Fill out the destination details to connect to the destination.
6. Click [OK] to confirm your input.

The destination can now be assigned to extractions.

Destination Details

The destination details define the connection to the destination.

Site URL

Enter the URL of your SharePoint server. To write data to a specific site on the server, include the sub-directories in the URL. The URL uses the following format:

• SharePoint Online: https://<your-tenant>.sharepoint.com/sites/<your-site-name>
• SharePoint On-Premise: http(s)://<your-server-name or domain>/<site-path>

SharePoint On-Premise / SharePoint Online

Select the type of SharePoint environment to write data to. When SharePoint On-Premise is selected, the data is written to a SharePoint server. When SharePoint Online is selected, the data is written to a SharePoint Online list.

Test connection

Click [Test connectiom] to test the connection.

Assign the Microsoft SharePoint Destination to an Extraction

Extractions write data to their assigned destination. Follow the steps below to assign a destination to an extraction:

1. In the main window of the Designer, select an extraction.
2. Click [ Destination]. The window “Destination Settings” opens.
   
3. In the “Destination Settings” window, select your Microsoft SharePoint destination from the dropdown list.
   
4. Optional: edit the destination settings.
5. Click [OK] to confirm your input.

When running the extraction, the extracted SAP data is now written to the destination.

Destination Settings

The destination settings only affect the extraction that the destination is assigned to. To open the destination settings, select an extraction in the main window of the Designer and click [ Destination]. The window "Destination Settings" opens.

File Name

Determines the name of the target table. The following options are available:

Append timestamp

Add the timestamp in the UTC format (_YYYY_MM_DD_hh_mm_ss_fff) to the file name of the extraction

Column Name Style

Defines the style of the column name. Following options are available:

Mode

Max. threads

Sets the number of threads for communication with the SharePoint server. It is recommended to use the default value 2.