Google Calendar Integration

Google Calendar Integration and Synchronization can be codeless with various other data sources using the Layer2 Cloud Connector via 3rd party data providers. Please take a look here for supported target systems and applications like SQL, Office 365, SharePoint, Exchange, Dynamics and other.

Google Calendar Integration with Office 365, SharePoint and 100+

To connect to Google Calendar, the source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

Google-Calendar-Integration-Synchronization.PNG

 
 
Fig. Example connection configuration to connect to Google Calendar and sync to various other systems and apps without code.

Google Calendar Specific Integration Settings

​Please note the following Google Calendar specific settings.

  • Install the CData ADO.NET Provider for Google Apps. This provider is not part of the Layer2 Cloud Connector ADO.NET provider package and should be installed separately from the vendor's product page. It requires extra licensing.
  • Choose “CData ADO .NET Provider for Google Apps 2015” (exact name might vary) as “Data Provider” for your data entity (source and / or destination).
  • Follow the vendor instructions for setting up the connection string and select statement (see below for samples).
  • Set the connection string as required:
    OAuthClientId=myClientId; OAuthClientSecret=myClientSecret; InitiateOAuth=GETANDREFRESH; [email protected]
  • This Provider uses OAuth to connect to the Google Calendar API. The vendor has instructions on how to set up the OAuth clientIDs and Client Secrets, if you do not have one already set.
  • A Google client ID looks like mytoken.apps.googleusercontent.com.
  • A client secret looks like one encoded string of numbers and characters.
  • Note: The first time new credentials are used, your default browser will open a web page where you are asked to authorize access to your Google account. That then should no longer need to be done for later manual or automatic scheduled syncs.
  • Set the data query as required:
    SELECT * FROM CalendarEvents
  • By default, the query will take data from the main calender for the user given as the Email=; parameter in the connnection string. You can define other calendars with a WHERE clause and the CalendarId. For example:
    SELECT * FROM CalenderEvents WHERE CalendarId='<IDcode>@group.calendar.google.com'
  • You need to set a primary key as the Provider does not pass one automatically.
  • You can map your Google calendar data fields (as shown in the data preview) to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
  • No installation or changes are required at the Google Calendar 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.
  • Bi-directional sync is supported - please take care to use an appropriate primary key.

Known Issues and Workarounds with Google Calendar Data Integration

  • The Start and End Date fields, when used with the reoccurring or 'all day' event markers, may require that the date contain the time zone information as part of the data.

Step-by-Step Intros For Codeless Google Calendar Data Integration and Synchronization

​Just some ideas what to connect next:
  • Sync with Microsoft Exchange (on-premises or online) for calendar events and appointments, mobile access and offline availability on any device. Public folders also supported.
  • Sync with 3rd party tools like ERP/CRM/CMS based on SQL databases like Oracle, mySQL or Microsoft SQL Server.
  • Sync with Microsoft SharePoint or Office 365 for better collaboration (for example with customers or partners) or for intranet publishing. Change notofications and workflows fully supported.
  • Integrate with Microsoft Dynamics CRM/ERP/NAV etc.
  • Connect to SAP via NetWeaver and OData or Hana.

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

Layer2 offer powerful tools for integration with Office 365. Through the use of these tools we have been able to move many of our customers over to using SharePoint Online seamlessly.

 

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

Solution Flyer: Google Data Integration and Synchronization

Google data from Google Drive, Google Calendar, Google Contacts, Google Spreadsheet, Google BigQuery or Google Analytics can be integrated and synchronized with other apps via Layer2 Cloud Connector.
PDF Image

Solution Flyer: Microsoft Dynamics CRM Data Integration

Microsoft Dynamics CRM Codeless Data Integration and Synchronization via Layer2 Cloud Connector.
PDF Image

Solution Flyer: Microsoft Exchange Data Integration

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

Solution Flyer: SOAP Web Services Data Integration

SOAP Web Services data can be integrated and synchronized codeless with various other data sources, on-premise or in the cloud, using the Layer2 Cloud Connector.
PDF Image

Solution Flyer: XML & XPath Data Integration

XML & XPath Data Integration and Codeless Synchronization via Layer2 Cloud Connector.