SharePoint

This page shows how to set up and use the SharePoint destination. The 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.

If your SharePoint server isn't configured for remote access already, go to Central Administration -> Application Management -> Configure alternate access mappings and add an appropriate mapping for the zone "Internet".

Create a new SharePoint Destination

Follow the steps below to add a new 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 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.

SharePoint on-premises or SharePoint Online

Select the type of SharePoint environment you are going to export to.

Site URL

Enter the URL of your SharePoint server here (optionally including sub-directories if you want to export into a specific site on the server).
Make sure you only enter the base path, omit page information a browser might show you in the address line like _layouts/15/start.aspx#/ or similar.

User

Enter your SharePoint user name.

Password

Enter the password for your SharePoint user account.

Test connection

Check the database connection.

Assign the 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 a destination from the drop down menu.
   
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 type 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.