can be integrated codelessly and in just minutes with 100+ other data sources (on-premises or in the cloud) using the Layer2 Cloud Connector
via SAP NetWeaver and OData. Please take a look here
for supported systems and applications, e.g. Microsoft Office 365, SharePoint, Dynamics, Azure, SQL and others.
SAP Integration with Office 365, SharePoint and 100+ others
Fig. SAP can be directly connected to 100+ data sources, on-premises and in the cloud, codeless lyand with no-touch in just minutes using the Layer2 Cloud Connector.
Fig. Please take a look at the video to connect SAP to Office 365 (as an example).
SAP Integration Specific Configuration Settings
To connect to SAP data the data source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:
Fig. Example connection configuration to directly connect to SAP demo data in their Devcenter via OData
Please note the following specific settings.
- Select the Layer2 Data Provider for OData to connect. The provider is part of the Layer2 Cloud Connector ADO.NET provider package and should be already installed. You will find a OData Provider specification here.
- You can use a connection string like this to connect:
url=https://mysapportal.mydomain.com/pathtomycollection; Collection=TravelAgencies; User=myDomain\myUser; Password=myPassword; Authentication=Windows.
- If you want to write to SAP, in some cases a CSRF Token is required to additionally secure the connection. Please use the following authentication method for this: Authentication=Windows,SAPCsrfHeader
- Several other authentication methods are generally supported. See provider specification linked above for more information.
- You can make use of OData to query your data as supported by the data provider and source system. For any specification of supported queries see SAP documentation. You can browse OData collections in the web browser. Simply paste your url from there.
- You can map your data fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
- Please enter an appropriate primary key (column with unique values), depending on query (see data preview for this).
- You can use the connection for uni- or bi-directional synchronization. In case of inserts (full CRUD) via external systems please take care of the primary key. SAP-side IDs will not work in his case.
- No installation or changes are required at the SAP data source or data destination.
- Data synchronization can be started manually in the Connection Manager, per command line or scheduled in background by the Layer2 Cloud Connector Windows Service. Only data changes are processed (no delete / bulk import).
- No programming required for setup a connection and sync.
- No need to open your local network for access from outside.
- Depending on requirements there are some steps on the SAP-side to connect to specific data entities. Please find more here.
- If you don't have OData access to your SAP data yet, you can alternatively connect and sync via database queries or intermediate text / csv files created by scripts.
Step-by-Step Intros About SAP Integration and Data Synchronization
You will find some step-by-step articles here:
Just some other ideas:
- Sync with Microsoft Exchange (on-premises or online) for notifications, tasks, calendar events, mobile access and offline availability on any device (e.g. for BYOD).
- Sync contacts with Microsoft Dynamics CRM or project data with Microsoft Project Server.
- Sync with 3rd party tools based on SQL databases like Oracle, mySQL or Microsoft SQL Server.
- Sync with Microsoft SharePoint or Office 365 for better collaboration (for example with customers or partners) or for intranet publishing.
Next Steps For Evaluation
You can register to download and evaluate the Layer2 Cloud Connector here