As a Microsoft Gold Certified Partner and ISV based in Hamburg (Germany), Layer2 is one of the leading providers of Microsoft SharePoint, Office 365 and Azure apps in Europe with a major focus on Data Integration, Collaborative Knowledge Management and Social Networking. We are huge fans of Layer2’s Cloud Connector. With Cloud Connector you can synchronize data into Office 365, SharePoint Online, or SharePoint On-Premise from almost any data source: ODBC, OLEDB, OData, .NET-based providers, file content (Excel, XML, CSV), File System Replication, SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, PostgreSQL, Microsoft SharePoint, Dynamics NAV/CRM, Exchange, Active Directory, Navision, Lotus Notes, SAP, Web Services etc.
No programming or tools required: Just select a data provider, enter connection string and data query. No installation or customizing at SharePoint or the external data source required.
100% compatible to ALL SharePoint 2010 / 2013 offerings: On premise, externally hosted, Office 365, OneDrive for Business, or sandboxed.
Reliable architecture: A connection is established only for data exchange –not for user interaction. External data is cached in native SharePoint lists.
Secure data connection and transfer: The connector runs where your data resides today -on any server or client inside your corporate network with Internet connectivity available, or in the cloud. No data is exposed to any 3rdparty.
High performance: Works great with large data sets.
And many more benefits…