Layer2 is easy to use and high flexible to transfer data between different sources.

It was easy to implement the layer2 connector. and to setup data connections and exchange data between systems.

The Layer2 could connector didn't measure our expectations for data migration for Lotus Notes platform.

It's been great overall, we can get data we thought we previously could not as it was stored in a different database. Have had no reason to engage with the support team until the upgrade, and the support has been same day and great, much appreciated.

The ability to schedule syncs, to have multiple syncs. We use it to bring SQL data into SharePoint online which we loved as there was no other way to achieve what we needed. With Layer2, we can schedule syncs to take place overnight without interrupting business activity. We can then do an afternoon sync and switch data sources in our in-house apps so we have 24/7 data availability. Integration with SharePoint is great!

Found on occasion the job would fail due to throttling (429s). Have just upgraded from v8 to 10 and hopeful that some tweaks have been made. Ran one job already and no errors. This was annoying as it had to be communicated to relevant users within the business whilst the job re-ran taking around 2 hours to complete.

syncs randomly fail. JSON script error... or other. then sync fine next. no indication as to the cause.

quick and easy setup to get local files synced with sharepoint site

program sometime just does not respond. High memory usage!!!

OK but as a new server live we couldn't transfer the original license from the decommissioned server

Works in background, allows clients connect and review their data we host

Original license non transferable when server upgraded

We needed a product that copied files from SharePoint online to a local drive, for processing the files to a server based software program. Layer2 Cloud Connector worked perfectly and was easy to set up for this purpose.When contacting support, the response was Quick and the answers given have always solved our issues.

The Cloud Connector works quick and is easy to set up. The support response is awesome!

For our purpose, we haven't found any issues. A licence had to be renewed after a software upgrade, but we assume this as a natural prosedyre in the life cycle prosess of software products.

The Layer2 Cloud Connector ensured that the integration between our ERP and SharePoint was smooth. The support team at Layer2 deserves a special mention. Whenever we had questions or faced minor hiccups, their team was right there, ensuring we had the answers and solutions we needed.

The current UI gets the job done, but there's potential for a more modern, intuitive, and visually appealing interface. A more refined UI could make the process even smoother.

Overall its good, But lot to improve in terms of stability and memory management.

Ease of use and price was ok compared with other products

It was stable a year back and latest versions started giving errors in terms of data types of special characters in the data. application is crashing once after your connections increases

We have solved the issue of not being able to directly query our SharePoint data by being able to extract it into another database. This also allows us to read data from this extracted database using code quicker than when reading directly from a SharePoint list

I like how you can easily sync data from a SharePoint list or document library to a SQL database. It’s also great how it splits out lookup columns into their ids and values.

Syncing data from SharePoint can be slow, especially for document libraries and large lists and libraries.

It’s stable and doesn’t involve too many releases

Debugging issue remains a challenge and understanding the functionality is not always intuitive.

Good product which needs few improvements.

Easy to transfer files. Easy to transfer files. Easy to transfer files.

Error alerts cannot be customized. All errors have the same alert which does not give us any idea what has failed.

Gute Grundlage um die Kollegen / Kolleginnen mit Daten im Homeoffice zu versorgen

Eine gute Alternative, wenn es nicht gewünscht oder möglich ist, den kompletten Datenbestand der Firma in der Cloud vorzuhalten.

Ein transparenteres Management bei Synchronisationsfehlern wäre wünschenswert. Wenn von den Usern mehrere Dateien gleichzeitig geändert werden, an beiden Seiten, gerät das System an seine Grenzen. Leider kein Telefonsupport.

We develop "smart solutions" in SharePoint online to meet a variety of business needs. This could include submitting purchase requisitions or requests for a new hire with the use of SharePoint forms and workflows to handle approvals, notifications and processing. The forms include lookup fields from data we maintain in other SharePoint lists. These lists needed to be manually maintained by the process owners since we had no way to sync the data from our business systems. With Layer2, we can now automate the sync of data from our business systems to the SharePoint lists. This frees the process owners from having to manually maintain them. This also ensures that the data is up-to-date and accurate since it now comes from the systems of record.

Layer2 has connectors to a large variety data sources, which makes it easy to extract data from line-of-business systems for import into SharePoint. We use the SQL database connection the most, and being able to write custom queries to pull the data for import into SharePoint lists allows us to use the same database table for multiple SharePoint sync jobs. If columns in the database do not match the names of the columns in SharePoint, Layer2 allows you to customize the mapping. Finally, the sync process is very fast, and I like that it only updates records when there are changes.

It was a little difficult to initially get the connections set up because of the security settings we have in place. We are using the Layer2 software on a virtual computer with SharePoint online with access to our databases and the VMs with a service account. It was a little tricky to get all the permissions set up correctly, but once we figured it out everything worked very smoothly. We probably should have contacted Layer2 support for guidance, but we wanted to figure it out on our own so that we are more likely to remember how it works.

I have some processes that sync 100K+ rows. Prior to this we had to utilize SSIS to do these syncs which was cumbersome to create and the performance was terrible. What used to take 1 hour to complete in SSIS takes less than 10 in Layer2.

Parameterization of the data selections (at the destination) would greatly improve this product. Example, when sending data to a SharePoint list, I have to create (and maintain) a separate configuration for each folder that I want to send data to. If we could parametrize the select statement in the destination based on the source I could populate the folder in the source and have 20+ connections consolidated into one. Also, the ability to launch a job remotely (via a webhook or some other method) would be fantastic. If there was some way to trigger the jobs other than the schedule, this could be a game changer of a product.

Das Produkt, die Firma und vorallem der Support sind einsame Spitze. Hatte schon lange nicht mehr solch einen guten Support bei anderen Produkten. Macht weiter so.

Die vielen Sync und Einstellungsmöglichkeiten. Obwohl es so vielfältig ist, ist die Einrichtung von neuen Verbindungen ein Klacks, auch die Dokumentation im Internet dazu ist sehr gut.

Keine, kann aber auch nicht gross welche nennen, da wir zuvor noch niche mit einem anderen Sync Tool oder ähnlichem gearbeitet haben. Abgesehen von selbst geschriebenen Scripts. :)

Layer 2 makes it very easy to keep data in sync between multiple sources. Our primary use for this product is syncing data between SharePoint and SQL and it does this flawlessly. The product is very reasonably priced and support is quick to respond if you need help. We have used this for about 4 years now and it is one of the few product we have that you can set and forget.

I think the only improvements would be an improved interface that offers help right in the window you need. I don't end up in this application very often though so this is a pretty small con.

Was very easy. I downloaded the trial and within 15 minutes was syncing data between SharePoint online and local data sources. I found it to be very intuitive and easy to use.

When we moved to SharePoint Online, we needed the ability to "sync" data between multiple sources/targets. Working with 3rd party consultants, they wanted to custom develop ways to do this. We had previously used your BDLC with SharePoint on-prem, so I looked and that's when I found Cloud Connector and it did exactly what we needed it to.

For what we need, I honestly do not have a 'CON' to list.

- Unzählige Connectors - Tolle Anpassbarfähigkeit durch Custom Columns und Select Statements - Vorlagen - Top Support für sehr spezifische Fragen

- Logs sind manchmal etwas kryptisch, falls etwas aber unklar ist, ist der Support sehr hilfreich

Layer2 helps us to sync SharePoint data to external websites. We also use it to import data from databases in to Sharepoint. This all works great.

Product is easy to use. We use it to connect SharePoint to external databases. The product makes sense.

In case of errors, it's sometimes difficult to figure out what exactly goes wrong. Also, one connection became kind of corrupt: we couldn't remove the corrupt field and still haven't figured out why the field was giving trouble.

Good selection of connectors to choose from. I've used Sharepoint, file system and FTP in particular. Decent documentation and easy to setup

Enterprise version is very expensive in comparison with annual fee, and without that FTP is limited to 25 transfers per sessions. Also it saves the passwords unencrypted in the XML config files on the hard disk

I was able to use a combination of onedrive sync and layer2 cloud connector to more quickly and accurately sync data from onedrive/sharepoint to a target server then sync that server with a local file server for a cloud/local repository implementation with fewer error and conflicts than onedrive sync tool

Easy set up, clear logging. Integrates with MANY applications, I am using for onedrive/sharepoint specifically as well as server to server synchronization

Nothing really bad, just took multiple steps to enable and turn on scheduling for continuous synch

Wir synchronisieren Daten aus einer SQL-Datenbank nach SharePoint Online.

Das Produkt macht was es soll und das ziemlich stabil und fehlerlos.

Die Benutzeroberfläche, bzw. die einzelnen Optionen sind manchmal etwas unglücklich korrekt zu verstehen

Stammdaten können zwischen Systemen einfach ausgetauscht werden. Die Konfiguration kann auch vom Fachbereich durchgeführt werden.

Die Konfiguration kann einfach zwischen Systemen portiert werden. Die Verbindung kann gleich in der Konfigurationsmaske getestet werden.

Schalter funktionieren nicht, wie sie in der Dokumentation beschrieben sind.

we use it to move data in and out of B2B teams we have with our customers and suppliers.

being able to move data in and out of office 365 and being able to integrate with many platforms

not sure if this is fair to say, but id like to be able to do automation, some sort of workflow/orchestration would be great, but I like that you can integrate with jira and flow, so maybe that's the more sensible option

Das Perfekte Tool für mich

Ganz Einfach Daten von Microsoft Online zu mir in Unternehmen und wieder zurück zu bringen.

Hab zu wenig Zeit mich noch mehr mit der Software auseinander zu setzen :)

Our aim was to provide an interim solution to synchronise Active Directory File Share to a specific (external) user via their OneDrive account so that production labels could be reliably printed at multiple sites across the country. Once we got our heads around the authentication, it was an easy process to complete.

Our aim was to provide an interim solution to synchronise Active Directory File Share to a specific (external) user via their OneDrive account so that production labels could be reliably printed at multiple sites across the country. Once we got our heads around the authentication, it was an easy process to complete.

We struggled with the URL to OneDrive and the authentication, so maybe some better example especially about copying and pasting OneDrive/Sharepoint URLs from 365 would help others?