Skip Navigation Links

​​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 MS SQL Server, SQL Azure, 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.

Native SharePoint lists as SQL Azure Web Frontend with full CRUD

​It's easy to connect native Microsoft SharePoint 2010 lists to SQL Azure tables and queries codeless and in just minutes. Optionally the connection can be bi-directional with two-way data replication. Full CRUD operation supported: create, update, delete. That means for example, you can use SharePoint on-premise or in the cloud as web frontend for SQL Azure. Please follow this instructions:

First create any data table in SQL Azure. In our sample this table will host announcement items from the SharePoint list with title, body and an expiration date. Please be sure to have some database-side primary key in your table.

Fig.: Create a data table in SQL Azure
 
In our sample we use a GUID field of type uniqueidentifier and set a new GUID when a new record is created. In this way any record has an unique primary key.
 
Additionally you have to create the Announcement list on the SharePoint side. We use the Announcement template to create. It's also available for Office 365 or SharePoint Online.
 
Fig.: A SharePoint Announcement list named AzureCRUD is connected to SQL Azure
 
To connect the created SQL Azure table with the SharePoint Announcements list we use the Cloud Connector with the following connection definition file:
 
<?xml version="1.0" encoding="utf-8" ?>
<connection xmlns="http://www.layer2.de/schemas/cloudConnections"
interval="10" version="1.2" enabled="true">
 
<conflictResolution mode="warnAndContinue" /> 
 
<dataEntities>
<dataEntity name="Azure" 
provider="System.Data.SqlClient" 
connectionString="Server=tcp:myserver.database.windows.net; Database=myDB;
User ID=MyUser@myServer.database.windows.net; Password=myPwd;
Trusted_Connection=False; Encrypt=True;"
selectStatement="Select * from Announcements"
>
</dataEntity>
<dataEntity name="Office365"
provider="Layer2.SharePoint.Provider"
connectionString="Data Source=https://myDomain.sharepoint.com/sites/mySite/;
Initial Catalog=AzureCRUD; Authentication=Office365;
User Id=myO365User@myO365Domain.onmicrosoft.com; Password=myO365Pwd;"
selectStatement=""
>
</dataEntity>
</dataEntities>
 
<fieldMappings>
 
 <fieldMapping>
  <conflictResolution mode="winnerLoser">
   <winningEntity name="Office365" />
  </conflictResolution>
  <field entity="Azure" name="Title"/>
  <field entity="Office365" name="Title" />
    </fieldMapping> 
 
 <fieldMapping>
  <conflictResolution mode="winnerLoser">
   <winningEntity name="Office365" />
  </conflictResolution>
  <field entity="Azure" name="Body"/>
  <field entity="Office365" name="Body" />
    </fieldMapping> 
 
  <fieldMapping>
  <conflictResolution mode="winnerLoser">
   <winningEntity name="Office365" />
  </conflictResolution>
  <field entity="Azure" name="Expires"/>
  <field entity="Office365" name="Expires" />
    </fieldMapping> 
 
</fieldMappings>
 
</connection>
 
Please note:
  • An Office 365 SharePoint list is used in this sample as web frontend for the SQL Azure table.
  • Both data entities are described in their DataEntity sections.
  • The data is not replicated in real-time. In this case the interval is set to 10 minutes (see connection section). 
  • Both data entities have primary keys, the GUID on SQL Azure side and the ID column at SharePoint side. The connector automatically recognize and use these PKs for replication settings.
  • Database fields are mapped to SharePoint list columns in the field mapping section.
  • There is a conflict resolution option on field level. If the SQL Azure field and the mapped SharePoint column are both changed, the winning entity defined above will survive.
  • Data types are automatically mapped.

Please contact sales@layer2.de if you have any questions about this sample scenario.

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

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

pdf ImageFlyer: 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.

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

pdf ImageProductflyer: Cloud Connector for Microsoft SharePoint 2010 & Office 365

Flyer with features, benefits & pricing info for download as PDF.

xml ImageSharePoint Cloud Connector PAD File

This XML-based PAD file offers a Cloud Connector product description for resellers to download and publish.

Related Links

Are you looking for resellers & implementation partners?

​Australia:

Web Cloud Solutions (Melbourne)

 

France:

Censio (especially SAP intgration)

 

Netherlands:

Wortell (Lijnden)

 

Spain:

Syntax.es  (Madrid)

 

Sweden:

NetIntegrate Sweden AB

 

United States:

Buchanan & Edwards

Aquilent

 

Cloud Connector @ Microsoft Office 365 Marketplace

Please share your Cloud Connector experience with other customers and rate us at Microsoft Office 365 Marketplace:

Microsoft-Office-365-Marketplace.png