Microsoft Office 365 Groups Connectors via Layer2 Cloud Connector for SQL/ERP/CRM

Office 365 Groups connections to 100+ widely used IT-systems and apps can be created codelessly using the Layer2 Cloud Connector. SQL, ERP, CRM - local or cloud-based - all are supported to notify Group members about any changes in the connected enterprise backend systems. You can also sync your local file server documents with the Office 365 Groups document library.

Office 365 Groups Connectors for SQL/ERP/CRM and 100+ more

Connector for Office 365 Groups
 
Office 365 Groups brings together people, conversations, and content across Microsoft Office 365. By providing an integrated experience that link together emails, conversations, document storage, and calendar events, Groups create a better experience for teams to focus on group activity. Groups can be public to enable information sharing within your company, or private for teams that deal with sensitive subjects. Group members are able to find all information in one place - without the need to switch from email to e.g. Yammer or Skype (for conversations) or to SharePoint (for lists and documents). Although the Microsoft Office 365 Groups feature by default comes with Office Groups Connectors to integrate external systems and apps, many typically used applications are still missing. The Layer2 Cloud Connector can now close this gap. 100+ enterprise systems and apps are supported to connect to Office 365 Groups codeless via the Layer2 Data Provider for Office 365 Groups.

Office 365 Groups Connector Specific Settings

​To connect to an existing Microsoft Office 365 Group the data destination entity must be configured as follows in the Layer2 Cloud Connector Connection Manager. To configure a specific data source see here.

 

Sample Image: Office 365 Groups data entity connection via Groups WebHook  

 

Fig.: Sample Office 365 Groups data entity connection via Groups WebHook 
 

Please note the following specific settings.

  • Select the Layer2 Data Provider for Office 365 Groups to connect. The provider is part of the Layer2 Cloud Connector ADO.NET provider package and should be already installed.
  • You can use a connection string like this to connect:

    WebHookUrl=<url of the webhook to the Office 365 group>; CardTitle=MyCardTitle
  • The WebHookUrl is created in the Office 365 Group you want the Cloud Connector to send Group Cards to. When opening the Office 365 Office Group, you can find an option at the top menu bar called Connectors. Click on that to start configuring your Webhook Connector. You need to create a connector by choosing the "Incoming Webhook" Connector and then click Add.
     
    Office365 Groups Conrnectos Incoming Webhook Layer2.jpg 
     
    Fig.: The “Incoming Webhook” generic Connector in Office 365 Groups is used by the Layer2 Cloud Connector to integrate 100+ external apps and systems with the Groups feature.
     
    To configure the Incoming Webhook, you need to give it a name and optionally add an image for the Connector. Once that is done you need to click on Create to create the Webhook. When it is created you will see an input box with an URL in it. This is the Webhook and you need this URL in the connection string of the Cloud Connector. The URL is unique to this Group and Webhook. If you remove the Webhook, you will disable the connection.
  • Using the Webhook "Group Cards" are posted to notify the team about any changes in the connected systems. For better processing you can give a Card Title in the connection string. It is recommended to use the Cloud Connector connection name so that you can immediately see which connection sent this card.
  • Additionally you have to provide a symbolic data query to provide data fields to map with your specific data source. Those fields are tracked for data changes and listed in your Group Card later on.
  • No password is required as WebHooks are used via the WebHook url.
  • A primary key (unique column) is required to process updates. You can also add multiple columns like Col1,Col2, Col3 that are unique together.
  • No installation or changes are required at the data source or data destination, e.g. on your connected ERP/CRM or SQL database.
  • This is a one-way data "sync" used for creating Group Cards for data change notifications. If you want to change your source data, please connect e.g. to a SharePoint list.
  • Group documents can also be synchronized with a local file server or another SharePoint.
  • Data updates can be started manually in the Connection Manager, per command line or scheduled in background by the Layer2 Cloud Connector Windows Service. Only data changes are processed.
  • No programming required to setup a connection. No need to open your local network for access from outside.
  • For more detailed setting options please take a look at the Layer2 Cloud Connector User's Guide.

Office 365 Groups Connectors - Known Issues and Workarounds

  • Group Cards are created on data change using fixed templates that follows the Microsoft Guidelines. It is planned to add custom templates with future releases.
Group Cards Screenshot 
  • You can use the field names in the symbolic data query and the Cloud Connector data mapping feature to provide user-friendly column names (different from data source) in the card. Important: The data query is not optional. A data query with field names must be provided for mapping. Select * does not work in this case.
  • With the current version it is not possible to provide a link to newly added or changed data items in the source system. This is planned for future releases.
  • Currently the Layer2 Cloud Connector is not specifically listed in the Microsoft Office 365 Groups connectors list. It is planned to add it to the Microsoft Store later on.
  • The Webhook URL in the connection string will validate even if it is incorrect as it cannot be checked without sending a card to post. If during a sync attempt you get the error "Could not write Office 365 card", then check to make sure the URL for the Webhook is correct.

Step-by-step Samples to Connect Data Sources to Office 365 Groups

Next Steps For Evaluation

You can register to download and evaluate the Layer2 Cloud Connector here.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

One of the best things about this product is its broad compatibility. The vendor is one of the quickest to reply to an email, and all of my dealings with them so far have been professional and pleasant.

 

 Download & Evaluation

 
Please register now to receive your free personal download link via email to your valid company email address.
Name: 
Company: 
Country: 
Phone: 
E-mail: 
Yes, I accept the licensing terms and conditions
How to buy this product

With the free Shareware Edition you can manage a limited number of items per connection. To order a license for the full version please click the shopping cart below.

Layer2 Cloud Connector
License List price Buy Now
FREE Shareware Edition * $0.00
FREE App Edition *
App Store only
$0.00 Go to App Store
Personal Edition
1 Single Server
License (one-time fee)
$499.00 Add to Shopping Card
1 Annual Software Assurance
for Personal Edition
$99.00 Add to Shopping Card
Professional Edition
1 Single Server
License (one-time fee)
$1,407.00 Add to Shopping Card
1 Annual Software Assurance for Professional Edition $281.00 Add to Shopping Card
Enterprise Edition **
1 Single Server
License (one-time fee)

$6,390.00

$1,290.00

Prepaid Remote Support
1 Hour
$176.00 Add to Shopping Card
Please contact [email protected] in case you want to order directly via Layer2 based on quote, invoice and bank transfer to Germany.

 

* The Shareware Edition and App Edition is limited to sync 25 items per connection.

** Starting with January 2015 all features of the Enterprise Edition are already included in the Professional Edition.

Related Contacts
Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
[email protected]

Please note that the 011 exit code must be dialed first for all international calls made from the USA, Canada and Australia.

Related News

New Microsoft Teams Connectors: Layer2 adds 100+ typically used backend systems

​The Layer2 Cloud Connector is now able to connect to Microsoft Teams to quickly integrate more than 100 IT backend systems including local SQL, ERP/CRM.

Layer2 Office 365 and SharePoint integration now compatible to FIPS

The newest Layer2 Cloud Connector release is compatible to the Federal Information Processing Standards (FIPS) of the United States federal government regarding strong encryption.
Related Downloads
PDF Image

Feasibility Study: Connecting local SQL Server to SharePoint Online

The study compares different approaches for SharePoint Online data integration regarding performance, features, security and investment.
PDF Image

Flyer: Layer2 Partner Program

Partner with us as a software distributer, reseller or SharePoint, Office 365 or Azure service provider. We are offering a free Partner Program with up to 30% Discount, free NFR licenses etc. Please download for more.
PDF Image

Get in the Cloud – With your corporate data sources connected

Download this step-by-step instruction to connect and sync your corporate or cloud data sources bi-directional to any native SharePoint 2010 / 2013 list or library, including Microsoft Office 365.
PDF Image

Layer2 Case Study: Cloud Connector helps ChemWerth to integrate the Microsoft Office 365 Cloud

"The Cloud Connector’s interface is easy to understand and use. Anyone familiar with utilities in the Microsoft stack will be productive immediately. Our recommendation: The Layer2 Cloud Connector is a no brainer.”
NoDoc Image

Layer2 Cloud Connector PAD File

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

Office 365: How to sync with local SharePoint?

You can replicate selected parts of your SharePoint intranet portal to the Office 365 / SharePoint Online cloud.
PDF Image

Office 365: How to sync with MS Dynamics CRM

You can sync any CRM data with native lists in SharePoint on-prem or online to make it available offline with Outlook.
PDF Image

Office 365: How to sync with MS SQL Server

You can sync any Microsoft SQL Server data codeless with SharePoint or Office 365 to make it available for collaboration, search and workflows.
PDF Image

Office 365: How to sync with PowerShell script output?

You can connect PowerShell script output with native SharePoint lists for improved reporting and workflows.
PDF Image

Office 365: How to sync with SAP?

You can connect SharePoint and Office 365 with SAP via NetWeaver and OData.
PDF Image

Office 365: How to sync with XML data?

Almost any system is able to expose data as XML file or web request. You can simply connect and sync to the Office 365 cloud.
PDF Image

Office 365: How to sync your local file share?

When you are moving to the cloud, there are a lot of reasons to keep your local file system. But you don't have to miss the benefits of the cloud.
PDF Image

Product Flyer: Cloud Connector for Microsoft SharePoint & Office 365

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

Product Flyer: SharePoint Online Local File Server Sync

You can centrally migrate, synchronize, or backup your local file server department shares and home drives very flexible with SharePoint Online to close known gaps and overcome limitations of the Microsoft OneDrive for Business client.
PDF Image

Solutions Flyer: Data Integration with SharePoint, Office 365 and 100+

FileMaker can be integrated with 100+ other sources codeless using the Layer2 Cloud Connector.
PDF Image

Solutions Flyer: Dynamics AX Data Integration

You can integrate and sync Dynamics AX data with Office 365, SharePoint and 100+ more.
PDF Image

Solutions Flyer: Dynamics NAV Data Integration

Integrate Microsoft Dynamics NAV (Navision) with Office 365, SharePoint and 100+ more codeless via Layer2 Cloud Connector.
PDF Image

Solutions Flyer: Project Online Data Integration

The Cloud Connector can be used to integrate and sync Project Online & Server data with 100+ other data sources.
PDF Image

Solutions Flyer: SQL Server Analysis Services SSAS OLAP Integration

You can integrate and sync SSAS / OLAP data with Office 365, SharePoint and 100+ other systems for better reporting.
Related Links

Layer2 Cloud Connector Community Group @ LinkedIn

​Are you already @ LinkedIn? Please join the Cloud Connector Community Group to share your experience.

Microsoft Partner Story Book for Office 365 about Cloud Connector

​Know more about a Layer2 Cloud Connector customer reference at the Microsoft Office web site.

Purchase Layer2 Cloud Connector via ComponentSource

​ComponentSource has offices in the USA, UK and Japan supporting over 125,000+ Customers, in over 180 Countries. They are also an approved Federal Government supplier through the GSA Schedule.

 

cs-award-top-100-publisher-2014-15-large.gif

Sign Up for Layer2 Product Newsletter

We keep you up-to-date about new Layer2 product releases, added features and fixed issues.