To connect to SharePoint Online we are using the Layer2 Data Provider for SharePoint (CSOM). Note that this is an example only. You can also connect to almost any other corporate data sources like databases, web services, cloud-or on-premises based systems like SharePoint (on-premises), Exchange (on-premises and Online), SAP, Salesforce etc.
Fig.: Smaple connection to Office 365 to synchronize Microsoft Access data.
Please select the data provider as shown above. If it does not appear in the list, please install from the Layer2 Cloud Connector distribution package. The connection string depends on authentication method. Here you will find more information and detailed specification to connect to SharePoint.
You can connect to an existing SharePoint list or create a new one. In the case we are using a contact list. It already comes with some appropiate fields. Additionally it provides some useful built-in features, like offline synchronization with Microsoft Outlook.
You don't have to take care about primary keys in this case (item IDs are used automatically).
Please verify all settings and display the data preview (right hand side actions menu).