Features & Benefits Layer2 Business Data LIst Connector

Keep your SharePoint on-premises portal in sync with data from 100+ external systems. Learn more about the features and benefits of the Layer2 Business Data List Connector for SharePoint below. Are you on SharePoint Online? Take a look here to find a similar tool for the Microsoft Cloud.



Close the gaps that still exist with SharePoint out-of-the-box external data integration

While Microsoft SharePoint Business Connectivity Services (BCS) allow exposing a small amount of external data records directly in the SharePoint user interface, there are still many gaps in functionality compared to native SharePoint lists. Think about search, lookups, metadata, mobile and offline access, forms, change notifications, or workflows on external data change. There are also issues with performance, especially in case of larger data sets and remote systems. BCS needs programming and it supports only a limited number of external systems.


Layer2 can completely close these gaps using a form-based, no-code, and easy to use SharePoint app to keep native SharePoint lists in sync with external data. All the great SharePoint list features are completely available for your external data sets. Forget about complexity: Simply create your SharePoint list and click "Connect to external data" in the SharePoint General List Settings...

Connect SharePoint to External Data Source in List Settings

Select your data provider to connect

The connector comes with data providers for ODBC, OLEDB, ADO.NET, Text/CSV, XML, RSS, SharePoint (CSOM), Exchange, Web Services (OData, SOAP), and more. It also works with any vendor specific ADO.NET driver, such as for Microsoft Office Excel, Access, SQL databases, ERP/CRM systems, and more. If you can't find your data provider in the list, please install (as shown here for Oracle). You can add data providers directly from any system vendor, and also from highly specialized 3rd party vendors to integrate even more systems. Find the right data provider here. If you can't find, contact us to learn more.

SharePoint Data Integration Select Data Provider Layer2

Enter your connection string

You don't need programming or additional tools to connect. No need to modify your external system. Just enter a connection string in the list settings that fits to your connected system. Usually it contains information about the target system, authentication methods, credentials, and vendor specific options. To find a connection string that fits to your requirements, take a look here. Important to know: Later on you can safely hide the connection string in the SharePoint Secure Store.

SharePoint Data Integration Enter Connection String Layer2

Select your external data set and key

You can query your data source using any query language your specific source system understands, such as SQL, XPath, OData, SOAP, and more. In case of databases you can also use stored procedures to return data sets. To connect to other SharePoint lists views can be used. In any case you will need one or more columns with unique values in your data set to setup the sync with SharePoint. You will find the column names using the data preview.

SharePoint Data Integration Select Data Set Layer2

Create your list columns on-the-fly and auto-map to external data fields

You can create the list structure and columns with one click based on the source data query results. To customize regarding column name and data types, simply remove and re-add columns as you want. You can also map SharePoint columns and external fields manually, if required.

SharePoint Data Integration Field Column Mapping Layer2

Keep your data in sync manually on-demand, automatically in background or via API

You can update your SharePoint list on-demand manually using the Action Menu or Ribbon button. You can automate using a link or the API. Typically updates are done completely in background using pre-configured timer jobs as scheduled. Data changes, such as inserts, updates, or deletes in the external systems are processed as set. You can even enable write-back of changes in the SharePoint list to your data source, if required.

Connect whatever you want

100+ typically used apps and systems are supported for SharePoint data synchronization, such as SQL databases via ADO.NET, ODBC, or OLEDB, CSV/XML files, ERP/CRM/CMS systems, Exchange, SharePoint itself (other list, site, site collection, tenant or installation), Exchange, Dynamics, Azure, OData or SOAP web services, and more. Find your specific system here. Can't find what you are looking for? Contact us to learn more.


Make use of ALL SharePoint list features

Think about native SharePoint lists as some kind of cache for your external data. It's automatically up-to-date and has all list features available, such as views, sorting, grouping, filters, calculated fields, versioning, search, lookups, metadata, mobile and offline access, Office integration (like Outlook, Access or Excel connectivity), forms, notifications, workflows. You can use all types of lists, for example a contact list for external address data,  calendar events, tasks, or custom lists. 3rd party tools will definitely work with Layer2 - as the data is in native SharePoint lists.

Secure und easy administration

Centrally manage connections in the SharePoint Secure Store to keep your configuration data safe. Connection data can be stored encrypted. No need to open list settings for end-users. Protect list settings using SharePoint access rights. Use the SharePoint ULS for debugging, setup email notifications in case of possible issues.

Programming not required, but possible

You can make use of the connector's feature-packed API to completely create, connect and update your lists via C#, PowerShell or workflows. Please find comprehensive documentation and code samples in the distribution ZIP and FAQs.

The only boundary is your imagination

You can do with your external data whatever you can do with SharePoint lists: Pull data from external line-of-business systems and publish for collaboration and dashboards, make it available in the common, easy to use Office environment without any need for users to access the source systems. Save license costs for the source systems - your SharePoint users will never access it directly. Use SharePoint lists or forms as a front-end to acquire data into backend systems. Start notifications and workflows based on external data change.


PlumSail Dashboard Designer Layer2

Available for all SharePoint editions and easy to migrate

The Layer2 Business Data List Connector is available for Microsoft SharePoint Server 2016, 2019 and Subscription Edition including the free SharePoint Foundation. It's easy to migrate and upgrade between the different versions. In case you are moving to the SharePoint Online cloud, a similar app is available with the Layer2 Cloud Connector.

We were able to bridge SharePoint gaps by introducing Layer2’s Business Data List Connector. The setup took a few minutes and the configuration to create a company directory was easy too.
Kenny Steinbacher, Real IT Care
Dank des CloudConnectors ist das Einbinden von externen Daten nach SharePoint online ein Kinderspiel.
Michael Nguyen, Innovation Manager und Projektleiter, IOZ AG
Der Layer2 Business Data List Connector ermöglicht die Synchronisierung verschiedenster Datenquellen mit SharePoint in wenigen Minuten - ohne Programmierung. Damit können wir unseren Kunden maßgeschneiderte Lösungen anbieten.
Gerald Werner, COO smartpoint
We use Layer2 Business Data List Connector for its flexibility in connecting many different source databases and files towards SharePoint. Thru the use of Layer2 we managed to cut down development costs while still providing full flexibility for our custom SharePoint solution
Tom de Ridder, ValueBlue
Wir und unsere Kunden sind von der einfachen Bedienung und der Flexibilität des Layer2 Business Data List Connectors für SharePoint überzeugt.
Eric Chall, novaCapta Software & Consulting GmbH
Wir nutzen den Layer2 Business Data List Connector bei unserem Kunden zum Import von Annahmestellendaten in den SharePoint... Unserem Kunden gefällt der BDLC, weil es ein Tool für viele verschiedene Datenquellen ist.
Markus Bütterhoff, Technischer Leiter Consulting, Amexus
Our customer’s have been very pleased with the full range of Layer2’s products including Cloud Connector, Business Data List Connector, and the Knowledge Management Suite. Our customers love that they can easily set it up and manage it themselves with very little learning. We now have many clients that have been using Layer2 for years and continue to find it very reliable for syncing data quietly and efficiently between their lists, applications, and environments.
Suzanne Myhre, SmartData
With this tool 'Business Data List Connector' SharePoint is the ideal central platform to make connections between your various business applications in order to have unique and consistent data throughout your company.
Peter de Meester, Orbid
Layer2 Business Data List Connector gives us easily the possibility to quickly integrate external Data into the Sharepoint Lists without extra code development.
GMI group
We particularly appreciate the ease of use involved in Business Data List Connector for SharePoint that comes from the simple browser-based list settings dialogue. It allows easy connection from a real SharePoint list to external business data.
Mark Douglas, Marketing Executive QBS Software
We use the “Layer2 Business Data List Connector” every day for connecting our different SQL applications with our Sharepoint intranet... To be able to connect other SharePoint list is a worthy bonus as well!
Loup Cattalano, D-Mute Network
De business Data List Connector van Layer2 heeft het bij Unitron mogelijk gemaakt om onze ERP data te ontsluiten naar SharePoint om ze daar verder te gebruiken in catalogen, formulieren en allerhande bedrijfsprocessen.
IT Manager, UnitronGroup
Of all the tools I've bought to make our SharePoint portal more user friendly, the Layer2 connector is my favorite. It is really well done, and the service from the publisher is top drawer.
Sean Moran, Nordstrom, Inc.

Ready for the next steps?

Ifoc for free trial product regsitration - Layer2 leading solutions

Register for free trial

Download a free trial of the Layer2 Business Data List Connector after a short registration.