Use the Cloud Connector Connection Manager (a MMC console plug-in) to define your connection as shown below.
Fig.: Sample connection settings with an uni-directional connection to push data to the Office 365 cloud.
You have to setup both data entities, the SAP side and the SharePoint side. First you have to select the Data Provider, the Xtract Universal ADO.NET Provider in this case. This provider allows access to SAP data using pre-defined data sources in the Xtract Universal Designer. The connection string simply points to the URL of the Xtract Universal Server. Please note the port selected. As a select statement you can simply refer to your model name, T001W in this case.
Fig.: SAP data source sample configuration as used in Cloud Connector.
As a next step you have to setup the data destination in the cloud. Please use the previously defined SharePoint list for this. As Provider you have to select the Layer2 SharePoint CSOM Provider in this case. To setup a connection string more detailed, please take a look at the Cloud Connector documentation. In short, you have to provide the URL, Authentication method and access data. Please verify all settings using the links provided.
Fig.: Sample SharePoint Online list configuration in Cloud Connector.
Please verify all settings using the links provided. Now you can continue with the field mapping. You can use the auto-mapping feature to automatically map fields of the same name or map manually. Please note the Title field as usual with SharePoint. You can make use of some replication conflict resolution options, if required.
Fig.: Field mapping sample for a SAP to SharePoint connection using the Cloud Connector.
After verifying and saving your settings you should first run the connection manually using the "Run Now" action provided. As a result you have the SAP data in a native SharePoint list in the cloud as shown below.
Fig.: Sample list of SAP data connected to SharePoint Online. Please note: That is no web part but a native list with all features available.
Please take a look at the Logs in the Connection Manager to improve, if there are any issues.