2. Connect any type of native SharePoint list to the defined SAP data subset
First you have to create your data destination list directly in SharePoint. You
can use any type of list, e.g. contacts, tasks, events - or simply a custom
list. Then go to list settings and click "Connect to external data source".
Please note: This step requires the "Business Data List Connector for SharePoint" installed and activated.
Fig.: To connect a list go to list settings and select "Connect to external data
For connection settings the following setup screen is shown:
Fig.: Connection setup screen on the SharePoint side.
Please select the "Xtract Universal ADO.NET Provider" as a
driver to access your pre-modeled data subsets from the Xtract
Universal Designer. If not installed you can download here:
Please note that the driver is built for "any CPU", that means it
suipports 32-bit and 64-bit. Please
validate the provider.
The Xtract Universal Windows Service can run as a Windows
Service on any machine, locally in this sample only. It is accessed per HTTP
using the following connection string:
host=http://localhost:8065. Please validate the connection string.
To select your data as a select statement simply input the
previously defined extraction name, T001W in this case. SQL syntax is not
supported here at this time, but planned for next versions. At this time please
use the Xtract Universal Designer to form your data query. Please validate and
preview the first rows of your data.
Take a look at the data and paste your primary key (a unique
field) into the configuration. Please note: A primary key is not required. But
if not available, SharePoint list items cannot be updated, but deleted and
re-inserted on update. For best performance please use primary keys whenever
possible. Please validate the primary key.
The SharePoint list structure is created in the next
step. Simply press "Add Columns" in this case. Existing columns are mapped with
fields by internal column names. Not existent columns are created automatically.
You can delete or modify column type if required. Please check mapping until the
mapping meets your requirements.
To insert the data first time or update later on for
testing, please press "Update". It can take a while, depending on data amount
and configuration. When it is finished, simply save / close and enter the list
Please note: you can enable background update here (via
timer job, e.g. every hour) or update manually via ribbon or action menu. Only
changed data is updated!
Fig.: List view of the SAP connected native SharePoint list.
Please see BDLC product page for more
details and options for background update, bi-directional write-back, API