Layer2 Cloud connector

The Layer2 Cloud Connector can integrate data and sync documents between 100+ corporate data sources without programming. It is typically used to connect services and apps, local or cloud-based, such as Microsoft Office 365, SharePoint, Dynamics, Azure, SQL/ERP/CRM, and more for migration, backup, or permanent two-way synchronization. This product is optimized for SharePoint Online. If you are on SharePoint on-premises, please find a similar product here.

Learn more about connectivity settings, best-practice advises, known issues, and
possible workarounds for data integration and document sync between 100+ supported IT systems
and apps in our new Solutions Finder.

Features and Benefits

Keep your enterprise in sync codelessly

Connect and sync data and files in local or cloud-based systems and apps in minutes. Just select a data provider, enter a connection string, map the data fields. Schedule the sync to automatically run in background.

Best performance and security

Once connected, only data changes are transferred as configured, one-way or two-way. You don't have to modify the connected systems. No administrative rights required. No need to open your network or modify firewall settings. No 3rd party vendor or cloud involved: All under your control.

Flexible high-end features

Flexible data or file selection using SQL, XPath, OData, SOAP, and more. You can sync one-way or even two-way, enable or disable specific operations, manage sync conflicts. Dynamic columns can be used to cleanup, transform or translate data, or add your own business logic in C#. 

Cost-effective licensing

Licensing per installation. Just a one-time fee with optional annual maintenance. No user CALs, no data volume-related costs. 100+ supported systems, unlimited number of connections and sync items, depending on configuration.

HOW It WORKS

Forget about complexity: Create a connection based on the templates provided.
Adapt for your needs. Take a look at the screens below to get a first impression.

WHAT DO YOU WANT TO CONNECT TODAY?

Connect your SQL database to the cloud

Find connectivity options for all SQL databases like SQL Server, Oracle, MySQL, Informix, DB2, Access, QuickBooks, and more to keep it in sync with other systems and apps, local or cloud-based. Many ERP/CRM/CMS can also be integrated directly using the backend RDBMS.

Integrate your enterprise with Microsoft Office 365

Is your Office 365 still a data island? Release the potential benefits and connect whatever you want to SharePoint, Exchange, Dynamics CRM / NAV / AX / SL / 365, Project, Azure, Groups, Teams, Flow, Logic Apps, and more Microsoft services and apps.

 

Keep your local files and documents in sync with the cloud

Migrate local documents to SharePoint, OneDrive, Microsoft Teams or Office Groups. Backup your cloud-based files locally or to Azure for disaster recovery and compliance. Keep your documents in sync two-way to enable better collaboration across sites or clouds.

FIND ANSWERS IN FAQs

Where do I have to install the connector?

The connector is installed centrally, where it could easily reach your data or files: on a separate Windows server or client in your local network, or in your Azure Cloud. It runs as a Windows Service to keep your data and documents in sync as configured. It communicates with the connected systems via ODBC, OLEDB, ADO.NET, SMB, HTTP, CSOM, OData, SOAP, REST or others. 

How to connect to my specific system or app?

First try to find your specific system using the Solution Finder. If it's listed, it will work. If not, that does not mean anything. Does your system come with an ODBC, OLEDB, ADO.NET data provider, just install and select in the provider dropdown. Does it offer generic interfaces like CSV/XML, OData, or SOAP? Just select - it's all included. Are there any 3rd party data providers available? We will definitely work with it. Does it speak REST? You can easily code your own provider or middleware.

Is Office 365 or SharePoint required?

While the connector originally was developed to better integrate Microsoft Office 365 and SharePoint with external data, this is no longer a requirement. You can connect and sync all supported 100+ systems and apps directly, without any need for Office 365 or SharePoint.

 

Too many options for me. Can we talk?

A web site cannot answer all questions. We will be happy to talk with you. Best to use the contact form. That will make it as easy as possible for us to be well-prepared when we call-back. Also note our Quick Start Service: A technical consultant can guide you remotely during installation, setup your first connection and talk about general best-practices, and your specific requirements.

WHO IS USING THE LAYER2 CLOUD CONNECTOR?

1000+ clients trust Layer2 to manage their business critical data integration and file sync every day.

How Layer2 helps ChemWerth to integrate Office 365

The Layer2 Cloud Connector helps ChemWerth, a US-based full service generic drug development and supply company, to fully integrate their local line-of-business applications, such as SAGE 300 ERP (AccPac), with the Microsoft Office 365 Cloud to allow end-user access to current backend data at any time, from anywhere, and with any device within the well-known Office environment.

How Office 365 was integrated in the Vrije Technische Scholen

The Vrije Technische Scholen (Belgium) was able to keep data and files from several sources, such as file servers, NAS, databases, and web servers, in sync with Microsoft Office 365 to provide up-to-date education schedules, student lists, contact information, forms, reservations, and inventories from their backend systems in the cloud.

Ready for the next steps?

Download product flyer

Learn more about the Layer2 Cloud Connector in the product flyer (PDF).

 

Register now for free download.

Keep your systems in sync. Download and try the Layer2 Cloud Connector today.