Takes your local line-of-business data to SharePoint Online - easy to connect, secure, and always up-to-date.
100% SharePoint-based, codeless, browser-based solution: Connection setup within minutes. Just click “Connect to external data source” in the SharePoint list settings dialog.
Auto-mapping and manual field/ column mapping supported including data type conversions.
Optional use of write-back to data sources feature in real-time, full CRUD (Create/Update/Delete).
Add additional “SharePoint-only” columns, e.g. for ranking, rating, tagging, comments or file attachments. Take external data offline.
No programming or tools required.
Almost data source supported: ODBC, OLEDB, OData, ADO.NET-based providers, files (Excel, XML, CSV), SQL Server, SQL Azure, Oracle, MySQL, IBM DB2, IBM AS/400, Informix, PostgreSQL, OneDrive, SharePoint, Exchange, Office 365, Active Directory, Navision, Notes, SAP, ERP/CRM/CMS systems, RSS Feed, XML Web Requests and Web Services, etc.
Known SharePoint BCS issues completely solved: ALL SharePoint list features available now.
Large data sets supported with high performance. No problems with SharePoint List View Threshold.
Data synchronization manually on demand or automatically in background using timer jobs with flexible settings for scheduling.
Data Provider for OData (Dynamics, SAP etc.), CSOM (SharePoint/Office 365), Exchange, XML/RSS included. Others can be connected via 3rd party.
Start SharePoint list workflows or send RSS / email notifications on external data change.
Save license costs for LOB systems while using native SharePoint lists to expose enterprise data.
Layer2 have major focus on SharePoint external data integration, Office 365 / SharePoint Online migration, integration and synchronization, SharePoint collaborative knowledge management and social networking.