Exchange Online Integration

Microsoft Exchange Server data (on-premise or Outlook in the Microsoft Office 365 Cloud) can be integrated and synchronized codeless with various other data sources using the Layer2 Cloud Connector via the Layer2 Data Provider for Exchange. Please take a look here for supported systems and applications.​​​​​​

Exchange Online Integration with Office 365, SharePoint and 100+

Exchange Online Office 365 and SharePoint Integration,


To connect to Microsoft Exchange Server or Exchange Online / Outlook data like contacts, calendar data, tasks, emails and notes the data source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

 
connectionconfiguration Microsoft Exchange Online  
 

Fig.: Sample connection configuration to connect to Visual Studio Team Foundation Server data.

Please verify the connection settings and display sample data in the data preview.

Exchange Integration And Synchronization Specific Settings

​Please note the following specific settings.
  • You can connect to both, Exchange on-premises or Exchange Online.
  • Select the Layer2 Data Provider for Exchange to connect. The provider is part of the Layer2 Cloud Connector ADO.NET provider package and should be already installed. You will find a specification of the Layer2 Data Provider for Exchange here.
  • You can use a connection string like this to connect:
    url=outlook.office365.com; [email protected]; Password=myPassword; NamingScheme=myNamingScheme. Please see provider documentation for more.
  • If you have appropriate access rights, you can also connect to mailboxes of other users or site mailboxes. Please make use of the parameter email, e.g. [email protected] a site mailbox bound to a site mySiteName.
  • If you are using impersonation to access different mailboxes, you will neeed to add the following to the connection string: Impersonation=true;
  • Several different authentication methods are generally supported. See provider specification linked above for more.
  • You can make use of specific data queries to select your data as supported by the data provider and source system. For any specification of supported queries see the provider documentation.
  • You can map your data fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
  • No primary key should be givne - the Exchange Item-ID is set automatically.
  • You can use the connection for uni- or bi-directional synchronization. In case of inserts (full CRUD) via external systems please take care of the primary key. Exchange-side IDs will not work in his case.
  • No installation or changes are required at the Exchange Server data source or data destination.
  • Data synchronization 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 delete / bulk import).
  • No programming required for setup a connection and sync.
  • No need to open your local network for access from outside.
​​

Layer2 Exchange Data Provider Known issues and limitations

Depending on provider version there are some known limitations and issues:
  • ​Calendar items: Full-day events also regular events are currently not supported.
  • Contact items: Outlook aggregates contact information from several sources and can merge it for display. A contact synchronization manages information only as stored in Exchange Server (not in Outlook).
  • Email / inbox items: Attachments are not managed.
  • TimeZone fields are not supported.
  • Contact items: Contact Groups/Distribution lists are currently not supported.
  • Task items: Attachments are not managed. Dependencies are not managed.
  • Binary blobs are not supported, e.g. images.
  • User Defined Fields (e.g. added in Outlook) are not supported by the Layer2 Exchange Data Provider.
  • Depending on configuration and data amount performance of first sync can be slowly.
  • Please format multi-line text fields as text only, not HTML/RTF. Otherwise it possibly leads to recurring field updates on each sync. Will be fixed with next versions by providing an additional Body.Plaintext field.
  • Sub-fields like CompleteName.GivenName, CompleteName.SurName are read-only. In some cases there are related fields available for write like GivenName, or SurName. Unfortunately for CompleteName.Title and CompleteName.Suffix no related fields are available at this time.
  • Wildcards are not supported in scopes.
  • No recursive / traversal option.
  • Max item count is limited to 1000 items in Exchange by default. Please use e.g. Select Top 5000 from myScope to increase.
  • Documents in public folders are not synced.
  • Be careful with select *. In some cases large attachments can slow down performance and end up in timeouts.
  • The GAL cannot be synced using this provider.

Use Cases For Exchange Data Integration and Synchronization

Just some ideas:
  • Sync your enterprise data with Microsoft Exchange on-premises or Online for change notifications, contacts, tasks, calendar events, mobile access (BYOD) and offline availability on any device (e.g. tablets, phones).
  • Sync Exchange data with local SQL or SQL Azure for better reporting or business processes.
  • Sync with 3rd party tools like ERP/CRM/CMS based on SQL databases like Oracle, mySQL or Microsoft SQL Server.
  • Sync Exchange with Microsoft SharePoint or Office 365 for better collaboration (for example with customers or partners), for intranet publishing or search.
  • Aggregate calendar entries from Exchange to SharePoint, e.g. to better share vacations or meeting rooms.
Can't find what you are looking for? Please contact [email protected] for any help.

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

This product actually opened up new possibilities to achieve a coherent integration of data sources and data collection processes spanning different technologies and on-premises / cloud infrastructures. The Exchange Connector is extremely promising.

 

 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

File Sync Edition***
1 user annual subscription
$150.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.

*** The File Sync Edition is limited to local file synchronization with any specific Office 365, SharePoint or OneDrive4B. The license is per user annually with a minimum of 50 licenses. Not yet available for online order. Please contact [email protected] if interested.

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

Oracle now fully integrated with Microsoft Office 365 via Layer2 Cloud Connector

​100+ most common IT-systems and apps like SQL, ERP/CRM are supported for Oracle data integration and sync, as well as Microsoft Office 365, SharePoint, Dynamics, Exchange, Office Groups, and Azure.
Related Downloads
PDF Image

Product Flyer: Business Data List Connector for SharePoint

SharePoint on-premises external data integration with 100+ sources: Product flyer (PDF) in English for download.
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: Layer2 Knowledge Management Suite for SharePoint

Assign accurate managed metadata automatically to SharePoint items and documents.
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

Solution Flyer: Microsoft Exchange Data Integration

Microsoft Exchange Codeless Data Integration and Synchronization via Layer2 Cloud Connector.