File Synchronization of Google Drive

Dokuments shared on Google Drive can be integrated and synchronized codeless with various other systems and applications like SharePoint, Office 365 and OneDrive for Business using the Layer2 Cloud Connector via the Layer2 Data Provider for File System with very flexible sync options. The solution can close many gaps with SharePoint and Office 365 out-of-the-box file synchronization, e.g. regarding the number of files, file naming conventions, file types allowed, and more. Please take a look here for more supported systems and applications.​​​​​

Google Drive File Synchronization with Office 365, SharePoint & OneDrive

Your files in Google Drive can be reached from any smartphone, tablet, or computer. So wherever you go, your files follow. You can quickly invite others to view, download, and collaborate on all the files you want–no email attachment needed. ​
 
google-drive-file-integration-synchronization.jpg 
 
Fig.: Documents in Google Drive to sync with SharePoint, Office 365 or OneDrive for Business.
 

But how to integrate your Google Drive documents with other systems like SharePoint, Office 365 or OneDrive for Business. You can do this via a synced local copy of the files. The Layer2 Cloud Connector must be configured as follows:

 

google-drive-integration-synchronization-layer2-cloud-connector.jpg 

 

Fig.: Sample configuration of the Layer2 Cloud Connector to sync files from Google Drive via an intermediate local file share.
 

Google Drive Synchronization Specific Settings

​Please note the following specific settings.

  • Install the Google Drive tool and configure for local synchronization.
  • Synchronize your Google Drive account to a local folder e.g. to C:\Google Drive\.
  • Select the Layer2 Data Provider for File System to connect. The provider is part of the Layer2 Cloud Connector distribution and should be already installed, depending on installation options selected. You can also install separately if required.
  • Note that the driver architecture must fit to the Cloud Connector version installed (32- or 64-bit). 
  • You can use a connection string like this to connect:
    Directory=myDirectory; UID=myUser; PWD=myPassword
    myDirectory can be D:\myDir, \\myServer\myshare, or \\127.0.0.1\c$\myShare (with any valid IP).
    In our sample myDirectory is C:\Google Drive\.
  • SQL-like data queries will be supported with next versions, e.g. only files with specific names, types or age.
  • You can map your source data fields (metadata like created, modified) to specific external source fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
  • No primary key required to enter manually
  • You can use the connection for uni- or bi-directional synchronization. In case of two-way sync changes in SharePoint are synced with the file system by the Cloud Connector. The Google Drive client syncs it back to Google Drive automatically. Note: The first time a file is removed from Google Drive by sync a message box can appear to confirm delete. Deleted files are can be found in and restored from the Google Drive recycle bin.
  • No installation or changes are required at the data source or data destination, e.g. Google Drive, SharePoint etc.
  • 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). Metadata added in SharePoint are kept during updates.
  • No programming required for setup a connection and sync.
  • No need to open your local network for access from outside.
  • Currently supported syncs: File Share to File Share, File Share to SharePoint / Office 365 / OneDrive for Business, SharePoint to SharePoint, e.g. local to cloud).
The Layer2 Cloud Connector has the following advantages compared to Microsoft out-of-the-box file sync offerings (currently named OneDrive for Business client):
  • Can be used with any version or plan of SharePoint (on-premises, externally hosted or cloud-based), Office 365, OneDrive for Business (not SP 2007).
  • Centrally managed server-to-server tool - not just an Office client.
  • Very flexible sync options like support of local directories, file shares, target library subdirectories, additional no-insert / no-update / no-delete options. Uni- or bi-directional sync. Sync files or just metadata.
  • There is no hard limit for the amount of files (e.g. 5.000 / 20.000 list view threshold with OOB). But take care about bandwidth limitations, especially for first sync. Only changes are synchronized later on.
  • SharePoint file name issues solved (requires V5.2 or higher). Special characters are replaced by default.
  • SharePoint path length issues solved (requires V5.2 or higher). Path is shortened if required.
  • SharePoint file type issues solved (requires V5.2 or higher). Forbidden types are zipped automatically.
  • SharePoint empty file issues solved (requires 5.2 or higher).
  • Flexible column mapping, e.g. for mapping of file meta data to custom SharePoint list columns.
  • SharePoint view support during sync to sync several sources into one library.
  • SQL support for file system queries (planned for next releases). You can e.g. sync specific date ranges ("new files") or specific file types only.
  • Several different options to solve replication conflicts. General error management.
  • Flexible authentication options, e.g. with specific Windows accounts or Windows integrated, Office 365, Active Directory Federated (ADFS).
  • Advanced logging options via NLOG (e.g.file, SQL, Windows etc.) with error notifications. Log levels.
  • File synchronization is just one option. It can sync data also SharePoint to SharePoint or with almost any other system or application, e.g. databases.
  • Cost effective licensing per installation: No user client access licenses (CALs) required.

Step-by-Step Intros for Google Drive File Integration and Synchronization

Just some ideas about systems to connect and sync with Google Drive:

  • Sync local or network shares with SharePoint or Office 365.
  • Sync local or network shares with OneDrive for Business.
  • Sync file shares with other file shares.
  • Sync any 3rd party cloud storage (e.g. BOX) to local file shares as intermediate store (with 3rd party tools) and than sync to SharePoint, Office 365 or OneDrive.
  • Sync file share metadata only to SharePoint lists (not the files itself) and have search, change notifications, workflows. Link back via FTB, WebDav etc.
  • Update document libraries in SharePoint, Office 365 and OneDrive 4B with metadata from SQL.

Do you have more ideas? Just let us know. Can't find what you are looking for? Please contact [email protected] directly for more information.

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

The software works perfect and does just what we need.

 

 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.