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 Formor contact sales@layer2.de directly.

Office 365 Integration: How to connect on-premise SharePoint to the Microsoft Office 365 cloud?

You can connect lists in your local on-premise SharePoint 2010 in your corporate network to native SharePoint lists in the cloud using the Cloud Connector add-on and the Layer2.SharePoint.Provider installed with the connector. For example you can add an additional column "cloud = Yes/No" to your contacts list in the corporate intranet, create a view ExportToCloud that only displays that contacts, and replicate all this contacts with cloud=Yes to Microsoft Office 365 into a contacts list myContacts.

Please use the following configuration file:

<?xml version="1.0" encoding="utf-8" ?>
<connection xmlns="http://www.layer2.de/schemas/cloudConnections"
interval="60"
enabled="true"
version="1.2">

</dataEntity>

</dataEntities>

<fieldMappings autoMapping="true">
    <fieldMapping>
      <field entity="MySharePointSource" name="ID"/>
      <field entity="MyCloudDestination" name="SourceID"/>
    </fieldMapping>
</fieldMappings>

</connection>

Please note:

Please note the additional column SourceID in the data destination list that will contain the item IDs of the source items for save update. Thsi column should be mapped in the field mappings section.
All other columns are automatically mapped with autoMapping enabled.
That works for all types of lists, e.g. news or custom lists.
In this sample the update interval is 60 min.
If your destination url is not xyz.sharepoint.com you have to use the additional "realm" attribute in connection string (see documentation).

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

Frank Daske, Business Development Manager

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...

Cloud Connector for Microsoft SharePoint 2010

Related Downloads

Flyer: Layer2 Partner Program

Partner with us as a software reseller or SharePoint service provider. There is a free partner program with up to 30% discount. Download as PDF.

Get in the Cloud – With your corporate data sources connected

Download this step-by-step instruction to connect your corporate or cloud data sources bi-directional to any Microsoft SharePoint Server 2010 in the cloud, including Microsoft Office 365.