​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 and libraries 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.

​You can use the Cloud Connector Connection Manager to select your data provider from the list of providers installed in the connection properties.

• Please note that the Connection Manager 32-bit possibly shows providers different from Connection Manager 64-bit version. If your provider is not available for 64-bit, please use the 32-bit version.
• If your provider is not listed, please install on computer where the Cloud Connector runs (e.g. Oracle client for .NET Framework).

If you want to configure the Cloud Connector manually using XML configuration files directly please note:

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.