The Cloud Connector for Microsoft Office 365 and SharePoint 2010 connects almost any on-premise data source, e.g. ODBC, OLEDB, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists in the Microsoft Cloud - or any other Microsoft SharePoint 2010 installation - in just minutes without any programming. For any questions please use the FAQ Web Form or contact sales@layer2.de directly.

How to identify the required provider / driver names?

You have to use the so called invariant name to declare a provider in the configuration file as data entity property. Typically the following providers are used:

Layer2.SharePoint.Provider ... comes with the Cloud Connector to connect to SharePoint 2010 via CSOM (Client Side Object Model).
System.Data.Odbc ... the .NET Framework Data Provider for Odbc used to connect via ODBC.
System.Data.OleDb ... the .NET Famework Data Provider for OleDb used to conenct via OLEDB.
System.Data.SqlClient ... the .NET Famework Data Provider for SqlServer used to connect to Microsoft SQL Server
System.Data.OracleClient ... the .NET Framework Data Provider for Oracle used to connect to Oracle database

See your machine.config for other installed providers.

"Please support us to improve our products and solutions. Give us your feedback."

Frank Daske, Business Development Manager, Layer2

News

Microsoft Office 365 Business Connectivity Services now available with Layer2’s Cloud Connector V2.0

Layer2 today has announced V2.0 of its Cloud Connector replication service to integrate corporate on-premise data - e.g. files, SQL databases, ERP/CRM, Microsoft Dynamics CRM or NAV, SAP etc. - with the Office 365 cloud.

Office 365 and SharePoint: Layer2 Awarded Microsoft Gold ISV Partner Status

A Microsoft Gold Partner since 2009, Layer2 has again achieved the highest level of Microsoft certification as ISV partner and met the Microsoft Partner Network requirements with new SharePoint 2010 and Office 365 web parts and extensions for the Cloud.

More...