Download layer2 cloud connector
Author: m | 2025-04-25
layer2 cloud connector free trial - download and evaluation Start your Layer2 Cloud Connector free trial now and see why thousands of customers trust Layer2 to manage their data
About the Layer2 Cloud Connector - Layer2 Solutions
OData that is fully included in the product. The Layer2 Cloud Connector can be used to keep files and documents in sync between file shares and SharePoint libraries, or between different SharePoint libraries for migration, backup or permanent two-way sync. This FAQ gives the full specifications of the Layer2 Data Provider for Office 365 Fast File Sync that is included with the connector since version 7.9. The Cloud Connector can be used to connect to almost any data source, even external SharePoint data - on-premise, internally or externally hosted, or in the Microsoft SharePoint Online / Office 365 cloud. This FAQ gives the full specifications of the CSOM-based Layer2 Data Provider for SharePoint that comes with the Cloud Connector. The Layer2 Cloud Connector for SharePoint can be used to connect almost any external data sources to native SharePoint lists and libraries, even external XML data, file-based or based on web requests. XPath queries can be used to retrieve the data set required. This FAQ gives the full specifications of the Layer2 Data Provider for XML included in product. Register for free download No credit card required. Register, download and try as long as you want
Layer2 Cloud Connector User Documentation - Layer2
Data Providers FAQ of the Layer2 Cloud Connector The Layer2 Cloud Connector can integrate data and sync documents between 100+ typically used IT systems and apps without programming. Find answers to frequently asked questions specifically about specific data providers included with the connector, such as for SharePoint (CSOM), Exchange, OData, SOAP, XML, and RSS. Learn more about data providers of 3rd party vendors here. The Layer2 Cloud Connector for Microsoft Office 365 and SharePoint can connect 32-bit and 64-bit ODBC data sources (and almost any other sources) with native list in SharePoint on-premise or online, in just minutes, without any coding, bi-directional if required. Learn here about the differences, limitations and benefits of the Layer2 SharePoint provider and the new Layer2 Office 365 Fast File Sync. The Layer2 Cloud Connector can be used to connect almost any external data source to Microsoft Exchange, on-premises or Exchange Online & Office 365. This page gives the full specifications of the Layer2 Data Provider for Exchange which is included in the Cloud Connector product starting with version 5. The Layer2 Data Provider for File System can be used to sync local documents with SharePoint libraries including Office 365, Teams, Groups, and more. The Layer2 Cloud Connector for SharePoint can be used to connect almost any external data sources to native SharePoint lists and libraries, for example via the OData protocol as used by many applications, e.g. SAP or Microsoft CRM/ERP systems. This FAQ gives the full specifications of the Layer2 Data Provider forFAQs for Layer2 Cloud Connector - Layer2 Solutions
First we will install the AirWatch Cloud Connector (ACC) by enabling it in the AirWatch Admin Console and then we download and run the installer file onto the server that will host the service.Installing the AirWatch Cloud Connector (ACC) includes the following tasks:Enable the ACC in the AirWatch Admin ConsoleGenerate the certificate that will be used for communication between the ACC and the AirWatch environment.Configure the ACC with the services we will be using.Download the ACC installer and install it.Verify that the installation was successful, and that communications pass between the AirWatch SaaS to the ACC, and the ACC to the AirWatch SaaS.First step is to enable the AirWatch Cloud Connector (ACC) in the AirWatch Admin console.Navigate to Groups & Settings ► All Settings ► System ► Enterprise Integration ► Cloud Connector.► Enterprise Integration ► Cloud Connector.► Cloud Connector.Next up we are going to enable the AirWatch Cloud Connector, before we download and install it.First we ensure that we are not inheriting the settings, as we wish to set up ACC. So we make sure that settings are on “Override”In this environment, since it is a SaaS and we do not want a mismatch between the environment in the cloud, and the ACC on the inside of our network, we enable “Auto Update“.Now we move onto the “Advanced“-tab for further configuration.PS: SaaS customers do not need to download the Secure Channel Certificate installer. We disabled BES (Blackberry Enterprise Services), and Certificate Authorities that we will not be using. Now we save the settings set how we want it to be and go back to the “General“-tab within the “Cloud Connector“-selection.Choose “Download Cloud Connector Installer” and this window will open within the console:Here you need to set a “Certificate Password”. We will be prompted for this password later when we install it on the server set to be used for the ACC-installation. I recommend using a password generator. I prefer to use the Identity Safe Password Generator from Norton by Symantec: hereWhen we are happy with our selection for complexity, we hit “Generate Password(s)“And we feed that in here:(Store the password somewhere temporarily, as we will be using this to start the installation)Scroll to the bottom of that window and hit “”You now have your Cloud Connector xx.xx.exe ready to be installed on your server.I’ve made a folder structure on the server that has been set up to be a dedicated AirWatch Cloud Connector-server.PS: Starting the installer “Cloud Connector x.x.x.x Installer” creates a folder with the following content:AirWatch_9.0_ACC_Installer contains logs about the installation.AdaConfig.xml has the pointers and the information to what group and SaaS tenant the installation will point against, as well as the certificate chain e.g.: Choose “Next” -> Set. layer2 cloud connector free trial - download and evaluation Start your Layer2 Cloud Connector free trial now and see why thousands of customers trust Layer2 to manage their data Existing Layer2 Cloud Connector Personal Edition customers can continue to renew their current subscription. Layer2 Cloud Connector Prices If you need to discuss your licensing requirements for Layer2 Cloud Connector, please contact our Layer2 licensing specialists.LAYER2 CLOUD CONNECTOR INSTALLATION GUIDE - Layer2
Activate a Layer2 Product?.If you have any issues or errors with upgrading, contact [email protected] for troubleshooting assistance.Upgrading the Layer2 Cloud Connector from Earlier Version to 7.8+These steps are specifically for the case when you are upgrading from a pre-7.8 version (7.7.* and earlier) to a version 7.8 or higher. This is because there are major changes to how 7.8 functions, and it has some additional impacting changes and special concerns that may affect the installation.Check the information in the Upgrading Layer2 Products - General section above to make sure you know the changes, have the download link, and have an appropriate license file.Also read the special Upgrade to Version 7.8 guide which lists breaking changes.If you need to update your license file, make sure this is done before you install the update as it will revert to "Shareware Mode" and restrict your connections.Close the Connection Manager.Stop the Layer2 Cloud Connector Service.Uninstall your current version of Cloud Connector using either the original installer or through Programs and Features. The uninstall process does not interact with the existing connection configuration data so you won't lose your connections from doing this. Those will remain in the Program Data folder, so as long as you don't delete that, it will keep your connections.Unpack the installation zip file for the new version.Run Setup.msi in the unpacked folder.The installer will now perform a fresh install of the new version. Open the Connection Manager and verify your connections are still present and working.Note that the logging level will be reset to "Warn" and the service accounts and settings will be reverted to their default state. Please update those to match your preferred settings once the upgrade is completed.If you received an updated license file, you can install that now using the directions in How to Activate a Layer2 Product?.If you have any issues or errors with upgrading, contact [email protected] for troubleshooting assistance.Upgrading the Business Data List ConnectorThe following steps can be used to upgrade the Business Data List Connector from one version to another. Please note that the upgrade process does not touch your existing list connection configurations so any pre-existing connections will still be available after the upgrade process is complete.Check the information in the Upgrading Layer2 Products - General section above to make sure you know the changes, have the download link, and have an appropriate license file.**IMPORTANT If you are updating from version 4.* or older, you must completely uninstall the solution and the ADO.NET provider packages before proceeding with the upgrade to version 5+. This is due to changes in the product that are not compatible with earlier versions.If you need to update your license file, make sure this is doneLayer2 Cloud Connector 8.1 Download
With active Software Assurance for your Layer2 product, you can upgrade to the latest version by downloading the newest installation package. Please read more about how to upgrade your products below.To find out if there is a new version of your product available, please see the Release Notes page. This will also list all the changes, fixes, and new features contained in the version.You should have received the link to download the current version in the email your license arrived in. If you cannot find this email, please contact [email protected] to receive a new link.You may also need to update your license file. Licenses are configured to work with a specific major version, so for example, version 7.* licenses for a product will not work with version 8.* or higher of the product. In this case, you would need to update your license file. If you need to update your license file or need help determining if you need a new license file, please contact [email protected] for assistance.Upgrading the Layer2 Cloud ConnectorThe following steps can be used to upgrade the Layer2 Cloud Connector from one version to another. Please note that the upgrade process does not touch your existing connection configurations, so any pre-existing connections will still be available after the upgrade process is complete, unless they are sample connections. If so, please rename those before the update or they will be lost.Check the information in the Upgrading Layer2 Products - General section above to make sure you know the changes, have the download link, and have an appropriate license file.IMPORTANT If you are upgrading from a version older than 7.8 to a version that is higher, skip down to the next section specifically for that scenario.If you need to update your license file, make sure this is done before you install the update as it will revert to "Shareware Mode" and restrict your connections.Close the Connection Manager.Stop the Layer2 Cloud Connector Service.Unpack the installation zip file.Run Setup.msi in the unpacked folder.The installer will now update the existing components. As noted above, this does not interact with the existing connection configuration data so you won't lose your connections from doing this, but if you are using sample connections productively, please rename those before the update or they will be lost. However, the logging level will be reset to "Warn" and the service accounts and settings will be reverted to their default state. Please update those to match your preferred settings once the upgrade is completed. Last but not least, please check your scheduling service settings as those will be reset too.If you received an updated license file, you can install that now using the directions in How toDownload Layer2 Cloud Connector .0
How to create a valid OLEDB select statement in SharePoint for Excel as external data source?While integrating external data sources into SharePoint via OLEDB the valid syntax of the select statements depends on the types of data sources used. Below are given some samples for Microsoft Excel data sources that are often used with the Layer2 Business Data List Connector for SharePoint (BDLC).Please take a look at the following examples:1. "SELECT * FROM [Sheet1$A:E]" 2. "SELECT * FROM [Sales$A:E] WHERE Name='Bob'" Name being the column heading which will get treated as a recordset field.How to connect to Ecxel via OleDb in detail:MS Excel Use CaseHow to connect to MS Access via OleDb in detail:MS Access Use Case Register for free download. Keep your Sharepoint in sync. Download and try today. Questions? Contact us. We are here to help. Contact us and our consulting will be happy to answer your questions.. layer2 cloud connector free trial - download and evaluation Start your Layer2 Cloud Connector free trial now and see why thousands of customers trust Layer2 to manage their data Existing Layer2 Cloud Connector Personal Edition customers can continue to renew their current subscription. Layer2 Cloud Connector Prices If you need to discuss your licensing requirements for Layer2 Cloud Connector, please contact our Layer2 licensing specialists.Comments
OData that is fully included in the product. The Layer2 Cloud Connector can be used to keep files and documents in sync between file shares and SharePoint libraries, or between different SharePoint libraries for migration, backup or permanent two-way sync. This FAQ gives the full specifications of the Layer2 Data Provider for Office 365 Fast File Sync that is included with the connector since version 7.9. The Cloud Connector can be used to connect to almost any data source, even external SharePoint data - on-premise, internally or externally hosted, or in the Microsoft SharePoint Online / Office 365 cloud. This FAQ gives the full specifications of the CSOM-based Layer2 Data Provider for SharePoint that comes with the Cloud Connector. The Layer2 Cloud Connector for SharePoint can be used to connect almost any external data sources to native SharePoint lists and libraries, even external XML data, file-based or based on web requests. XPath queries can be used to retrieve the data set required. This FAQ gives the full specifications of the Layer2 Data Provider for XML included in product. Register for free download No credit card required. Register, download and try as long as you want
2025-04-19Data Providers FAQ of the Layer2 Cloud Connector The Layer2 Cloud Connector can integrate data and sync documents between 100+ typically used IT systems and apps without programming. Find answers to frequently asked questions specifically about specific data providers included with the connector, such as for SharePoint (CSOM), Exchange, OData, SOAP, XML, and RSS. Learn more about data providers of 3rd party vendors here. The Layer2 Cloud Connector for Microsoft Office 365 and SharePoint can connect 32-bit and 64-bit ODBC data sources (and almost any other sources) with native list in SharePoint on-premise or online, in just minutes, without any coding, bi-directional if required. Learn here about the differences, limitations and benefits of the Layer2 SharePoint provider and the new Layer2 Office 365 Fast File Sync. The Layer2 Cloud Connector can be used to connect almost any external data source to Microsoft Exchange, on-premises or Exchange Online & Office 365. This page gives the full specifications of the Layer2 Data Provider for Exchange which is included in the Cloud Connector product starting with version 5. The Layer2 Data Provider for File System can be used to sync local documents with SharePoint libraries including Office 365, Teams, Groups, and more. The Layer2 Cloud Connector for SharePoint can be used to connect almost any external data sources to native SharePoint lists and libraries, for example via the OData protocol as used by many applications, e.g. SAP or Microsoft CRM/ERP systems. This FAQ gives the full specifications of the Layer2 Data Provider for
2025-04-22Activate a Layer2 Product?.If you have any issues or errors with upgrading, contact [email protected] for troubleshooting assistance.Upgrading the Layer2 Cloud Connector from Earlier Version to 7.8+These steps are specifically for the case when you are upgrading from a pre-7.8 version (7.7.* and earlier) to a version 7.8 or higher. This is because there are major changes to how 7.8 functions, and it has some additional impacting changes and special concerns that may affect the installation.Check the information in the Upgrading Layer2 Products - General section above to make sure you know the changes, have the download link, and have an appropriate license file.Also read the special Upgrade to Version 7.8 guide which lists breaking changes.If you need to update your license file, make sure this is done before you install the update as it will revert to "Shareware Mode" and restrict your connections.Close the Connection Manager.Stop the Layer2 Cloud Connector Service.Uninstall your current version of Cloud Connector using either the original installer or through Programs and Features. The uninstall process does not interact with the existing connection configuration data so you won't lose your connections from doing this. Those will remain in the Program Data folder, so as long as you don't delete that, it will keep your connections.Unpack the installation zip file for the new version.Run Setup.msi in the unpacked folder.The installer will now perform a fresh install of the new version. Open the Connection Manager and verify your connections are still present and working.Note that the logging level will be reset to "Warn" and the service accounts and settings will be reverted to their default state. Please update those to match your preferred settings once the upgrade is completed.If you received an updated license file, you can install that now using the directions in How to Activate a Layer2 Product?.If you have any issues or errors with upgrading, contact [email protected] for troubleshooting assistance.Upgrading the Business Data List ConnectorThe following steps can be used to upgrade the Business Data List Connector from one version to another. Please note that the upgrade process does not touch your existing list connection configurations so any pre-existing connections will still be available after the upgrade process is complete.Check the information in the Upgrading Layer2 Products - General section above to make sure you know the changes, have the download link, and have an appropriate license file.**IMPORTANT If you are updating from version 4.* or older, you must completely uninstall the solution and the ADO.NET provider packages before proceeding with the upgrade to version 5+. This is due to changes in the product that are not compatible with earlier versions.If you need to update your license file, make sure this is done
2025-04-08With active Software Assurance for your Layer2 product, you can upgrade to the latest version by downloading the newest installation package. Please read more about how to upgrade your products below.To find out if there is a new version of your product available, please see the Release Notes page. This will also list all the changes, fixes, and new features contained in the version.You should have received the link to download the current version in the email your license arrived in. If you cannot find this email, please contact [email protected] to receive a new link.You may also need to update your license file. Licenses are configured to work with a specific major version, so for example, version 7.* licenses for a product will not work with version 8.* or higher of the product. In this case, you would need to update your license file. If you need to update your license file or need help determining if you need a new license file, please contact [email protected] for assistance.Upgrading the Layer2 Cloud ConnectorThe following steps can be used to upgrade the Layer2 Cloud Connector from one version to another. Please note that the upgrade process does not touch your existing connection configurations, so any pre-existing connections will still be available after the upgrade process is complete, unless they are sample connections. If so, please rename those before the update or they will be lost.Check the information in the Upgrading Layer2 Products - General section above to make sure you know the changes, have the download link, and have an appropriate license file.IMPORTANT If you are upgrading from a version older than 7.8 to a version that is higher, skip down to the next section specifically for that scenario.If you need to update your license file, make sure this is done before you install the update as it will revert to "Shareware Mode" and restrict your connections.Close the Connection Manager.Stop the Layer2 Cloud Connector Service.Unpack the installation zip file.Run Setup.msi in the unpacked folder.The installer will now update the existing components. As noted above, this does not interact with the existing connection configuration data so you won't lose your connections from doing this, but if you are using sample connections productively, please rename those before the update or they will be lost. However, the logging level will be reset to "Warn" and the service accounts and settings will be reverted to their default state. Please update those to match your preferred settings once the upgrade is completed. Last but not least, please check your scheduling service settings as those will be reset too.If you received an updated license file, you can install that now using the directions in How to
2025-04-05Highest security and performance. Large data sources can be synchronized.100+ more external systems supported: Layer2 Data Providers included (e.g. for external SharePoint or Office 365, Exchange, Dynamics ERP/CRM, OData, XML/RSS, SOAP), vendor specific data providers can be used (e.g. SQL Server Oracle, MySQL etc.), 3rd party data providers also supported, e.g. for custom ERP/CRM, Facebook or Twitter. See here for supported systems and applications. The smart solution for data integration and synchroniationIf you are looking for a data and file synchronization and integration tool, you should try Layer2 Cloud Connector. This tool is intuitive, secure and with no data limit. You can synchronize automatically in the background, one way or two way - and you can use it even without IT knowledge. We offer you three licenses, a free trial of Layer2 Cloud Connector and a life product demo.MORE ABOUT ITODBC Specific SharePoint List Configuration SettingsIn the SharePoint General List Settings click "Connect to external data source". In the BDLC form the data source must be configured as follows to connect to ODBC.Figure 1: Sample connection configuration to connect a native SharePoint list to an ODBC data source via Layer2 Business Data List Connector.Please note the following specific settings.Select the ODBC Data Provider in the drop-down to connect. The provider is part of the Windows Operating System and should be already installed.Install the 64-bit version of the source-specific ODBC driver, e.g. for MySQL or FileMaker. If you can't find any 64-bit compatible driver, see below under Issues and workarounds.Follow the vendor instructions to setup and configure. See here for an example to setup an ODBC data source.Use a System DSN (not User or File DSN) to setup your connection and to refer to in the connection string. Verify your setup directly in the 64-Bit ODBC Connection Manager, if supported. Don't use the 32-Bit ODBC Connection Manager by mistake.You can use a connection string like this to connect:DSN=myDSN; UID=myUser; PWD=myPasswordPlease find more details about ODBC options at www.connectionstrings.com.You can make use of ODBC to query your data as supported by the data provider and source system. For any specification of query
2025-04-14Language supported see specific vendor documentation.You can map your data fields to specific external source fields in the Layer2 Business Data List Connector. Please take care about data types (simple type conversions are supported).Please enter an appropriate primary key (column with unique values), depending on query (see data preview for this).You can use the connection for uni- or bi-directional synchronization. No installation or changes are required at the ODBC data source or data destination.No programming required for setup a connection and sync.ODBC Connection DetailsProvider: .Net Framework Data Provider for ODataConnection string sample:DSN=myDSN; UID=myUser; PWD=myPasswordSelect Statement sample: select * from yourTableSharePoint Integration via ODBC - Examples, Known Issues and WorkaroundsThe integration of ODBC-related data sources in SharePoint has the following known issues and workarounds:In case of inserts (full CRUD) via external systems please take care of the primary key. Database-side IDs will not work in his case.Please make use of the bdlcGUID column that will have a unique GUID assigned automatically, if required.If you can't find any 64-bit driver, please use the Layer2 Cloud Connector (32-bit version) to connect.Please find the following samples:Text/CSV Data, e.g. exported from LOB systems, can be integrated via ODBC as shown here.Microsoft Navision ERP data can be integrated via C/ODBC drivers as noted here. All New Popular ERP/CRM Collaboration Database IBM Microsoft Oracle Productivity SAP Social Register for free download. Keepyour Sharepoint in sync. Download and try today. Questions? Contact us. Weare here to help. Contact us and our consulting will be happy to answer yourquestions.
2025-04-23