BCS Connector for SharePoint

2010 · Theobald Software · .NET · C# · WPF · SharePoint

In 2010 I started designing and developing the BCS Connector for SharePoint, part of the ERPConnect Services product suite. It connects SharePoint lists with SAP objects or tables without any programming.

The connector generates and publishes SAP data as external content types in SharePoint 2010 and 2013 and creates the external lists. The user picks the SAP object, a table or a function module, and the columns the list shows. Lists can be read-only or writeable; all CRUD methods are supported. Deployment is one click.

Videos

Two videos by a colleague at Theobald Software show the connector in use:

Screenshots

The screenshots follow one data model from the SAP connection to the external SharePoint list.

The SAP connection dialog: client, language, user and application server.
The SAP connection dialog: client, language, user and application server.
A new entity starts with the object type, a table or a function.
A new entity starts with the object type, a table or a function.
Searching the SAP function module SD_RFC_CUSTOMER_GET.
Searching the SAP function module SD_RFC_CUSTOMER_GET.
The function parameter CUSTOMER_T becomes the entity structure.
The function parameter CUSTOMER_T becomes the entity structure.
The entity with its properties, taken from the SAP structure.
The entity with its properties, taken from the SAP structure.
A new operation of type finder, specific finder, creator, updater or deleter.
A new operation of type finder, specific finder, creator, updater or deleter.
The Read Data finder with its input parameters and a limit filter.
The Read Data finder with its input parameters and a limit filter.
The Read Data Record specific finder, mapped to KUNNR.
The Read Data Record specific finder, mapped to KUNNR.
The published BDC model in SharePoint Central Administration.
The published BDC model in SharePoint Central Administration.
Creating the external list Customer List from the entity.
Creating the external list Customer List from the entity.
The external list in SharePoint with live SAP customer data.
The external list in SharePoint with live SAP customer data.

Posts about the connector