Layer2 Cloud Connector Features

• Cloud migration made easy - The connector can be installed in the cloud or locally. It runs as a Windows Service to move pre-selected data to the cloud. All kind of data supported: structured data from Excel, SQL databases, ERP or CRM systems - or files and documents from a Windows File Server or NAS. You don't need programming: Select your source system or data provider, enter a connection string and a data query, apply sync options - that's it. Run the connection first time or schedule for permanent sync, if required.
• Backup your Microsoft Cloud - There are many reasons to physically own a copy of your data and files: It's not only about disaster recovery (DR) - it's simply about compliance. You can use the connector to backup data and documents in the Microsoft cloud to a local Windows File Server or SharePoint Server, or to your own Azure cloud. No 3rd party vendor, service or cloud involved - all under your control. Microsoft Office 365, SharePoint, OneDrive for Business, Microsoft Teams, Office Groups and more, all are supported for backup. Once you own your data, you can apply your existing backup tools for any further processing, or make use of the Windows File History to keep older versions.
• Keep your cloud connected and in sync - Your new cloud is great - but not as a data island. You can highly improve collaboration, reporting, search, forms, workflows and more in the cloud, but not based on disconnected, possibly outdated, and inconsistent data sets and documents. Your cloud needs to be fully integrated and in sync with your enterprise. It's not only about integrating local systems: Different clouds also need to be integrated cross-tenant, cross-vendor, or cross-app. The Layer2 Cloud Connector can connect in minutes and keeps data and files in sync automatically.
• Connect 100+ systems and apps - Almost any data source supported: ODBC, OLEDB, ADO.NET-based data providers, file content (Excel, XML, CSV), documents and other files from a Windows File Server, NAS or Azure File Share, SQL Server, SQL Azure, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, PostgreSQL, Microsoft Office 365 and SharePoint, OneDrive for Business, Microsoft Teams, Office Groups, Dynamics 365/CRM/NAV/AX, Exchange, Active Directory, Flow, Azure Logic Apps,  SAP, Salesforce, SugarCRM, Web Services like OData, SOAP, and more. Looking for specific systems to connect? You will definitely find it here.
• Secure connections and data transfer - The connector runs where your data resides today - on any server or client inside your corporate network with Internet connectivity available, or in your own cloud. No data is exposed to any 3rd party. Data and files are transferred using secure connections, such as SSL/HTTPS. Various authentication methods are supported out-of-the-box, such as Windows domains, Microsoft Accounts, Active Directory Federation (ADFS), and more. Custom authentications like RM Unify, OKTA, and others are supported out-of-the-box or can easily be added using the Authentication Construction Kit. Connection strings and other settings are stored locally with strong encryption (FIPS compatible).
• Reliable system architecture - The Layer2 synchronization service can be centrally managed and includes flexible logging and alerting using NLOG. Connections are established as scheduled only for data exchange, such as insert, update, or delete operations - not for end-user interaction. End-users will even not know about your sync. They do not have access to the connected back-ends, therefore they don't need to have end-user licenses for the connected systems like SQL, ERP or CRM. The data is provided with the full feature-set of the certain connected system, such as Office 365, SharePoint, or Dynamics. In case of SharePoint, native lists are used to store the connected data without the feature restrictions of BCS / external lists.
• Advanced features for maximum flexibility - While generally easy to manage, the connector has lots of advanced features that can help you to solve very specific requirements: Query your files using a SQL-like query language to include or exclude files to / from sync by name, type, size, or date. Enable / disable specific operations such as insert, update, or delete. Add Dynamic Columns to cleanup your data, apply calculations, transformations, or translations to your data. Add your own business logic in C#. Connections can be created and executed manually on-demand, but also fully automatically using PowerShell scripting to automate provisioning and deployment.

Layer2 Data Provider Support

Personal Edition (One connection only)

• Exchange
• Microsoft Flow and Logic Apps
• Microsoft Teams Channel Webhook
• OData
• Office 365 Groups
• RSS Feeds
• SharePoint Lists
• SOAP Web Services (Deprecated)
• XML

Standard Edition (Unlimited number of connections)

• Exchange
• File System
• Microsoft Flow and Logic Apps
• Microsoft Teams Channel Webhook
• OData
• Office 365 Fast File Sync
• Office 365 Groups
• RSS Feeds
• SharePoint Lists
• SharePoint Libraries
• XML

Enterprise Edition (Unlimited number of connections)

• Azure Blob Storage
• Exchange
• File System
• Microsoft Flow and Logic Apps
• Microsoft Teams Channel Webhook
• OData
• Office 365 Fast File Sync
• Office 365 Groups
• RSS Feeds
• SharePoint Lists
• SharePoint Libraries
• SOAP Web Services (Deprecated)
• XML
• Act! CRM
• Active Directory
• Asana
• Authorize.Net
• Azure Tables
• Bing
• Cloudant
• CosmosDB
• Couchbase
• Dropbox
• Dynamics 365 Business Central
• Email
• Excel
• Excel Online
• Facebook
• File Transfer Protocol
• Google Analytics
• Google Calendar
• Google Contacts
• Google Drive
• Google Mail
• Google Search
• Google Sheets
• HubSpot
• JIRA
• JSON
• Magento
• MailChimp
• MariaDB
• MongoDB
• NetSuite
• PayPal
• PostgreSQL
• Quandl
• Quickbooks
• QuickBooks Online
• Reckon
• Redis
• REST
• SendGrid
• ServiceNow
• Shopify
• Smartsheet
• Square
• SuiteCRM
• SurveyMonkey
• Twitter
• Xero
• YouTube