SharePoint on-prem data integration

Since eight years, starting with Microsoft SharePoint Server 2007, Layer2 has been offering class-leading solutions for SharePoint on-premises external data integration. 100+ widely used IT systems and apps can be fully integrated with SharePoint with the help of the Layer2 Business Data List Connector for SharePoint in just minutes. All the great SharePoint list features are available for your external data, such as views, search, mobile and offline access, forms, change notifications, workflows on external data change, Flow, and PowerApps. Please find detailed connectivity settings, best-practices, known issues, and workarounds for your desired system below.

In case you are looking for Office 365 or SharePoint Online integration, you will find a similar tool here.

Find Use Cases by Vendor

What do you want to connect today?

A
Popular
access-logo

Access

Microsoft Office Access can be connected to SharePoint two-way using it's own data provider.

Popular
activedirectory-logo

Active Directory

Microsoft Active Directory data can be pulled to SharePoint lists onw-way.

Popular
microsoft azure data integrations synchronization logo

Azure SQL

Keep Azure SQL data in sync with SharePoint

B
blackcompass-solutions-logo

BlackCompass Visualizer

Apps from BlackCompass can be integrated with the help of Layer2 Data Providers.

box-logo

Box

Box file metadata can be integrated with SharePoint to link files.

C
New
Logo sap hybris data integration Layer2

C4C Hybris

capsule-logo

Capsule CRM

Capsule CRM data can be integrated with SharePoint read-only via XML.

csv-logo

CSV

CSV and text file data can be integrated with SharePoint with the ODBC provider.

D
Popular
dynamics-logo

Dynamics 365

Microsoft Dynamics CRM data can be integrated codeless with SharePoint via OData.

Popular
dynamics-logo

Dynamics NAV

Dynamics NAV data can be integrated with SharePoint two-way via Data.

E
exact-logo

Exact Online

Exact Online data can be connected with SharePoint two-way via OData.

Popular
excel-logo

Excel

Microsoft Office Excel data can be connected to SharePoint lists read-only.

excel-logo

Excel Services

Excel Services data can be connected to SharePoint read-only.

Popular
exchange-logo

Exchange

Microsoft Exchange (on-premise or online) data, such as contacts, calendar events, and more can be kept in sync with SharePoint two-way.

F
facebook-logo

Facebook

Facebook data like posts, friend lists and followers can be kept in sync with SharePoint.

H
hfsql-logo

HFSQL Database

HFSQL data can be synced with SharePoint via ODBC.

highrise-card-logo

Highrise CRM

Highrise CRM data can be integrated with SharePoint via XML read-only.

New
Logo sap hybris data integration Layer2

Hybris

I
Popular
ibm-logo

IBM DB2

IBM DB2 database data can be kept in sync with SharePoint via the IBM .NET Data Provider.

ibm-logo

IBM Informix

IBM Informix data sources can be integrated codeless with native SharePoint lists using the Layer2 Business Data List Connector.

ibm-logo

IBM iSeries AS/400

IBM iSeries AS/400 data can be integrated and synchronized with SharePoint lists.

ibm-logo

IBM Lotus Notes

ODBC can be used to keep Lotus Notes & IBM Domino in sync with SharePoint.

intersystems-logo

Intersystems Caché

InterSystems Caché database data can be integrated with SharePoint via ODBC.

J
New
jira-logo

JIRA

Atlassian JIRA project data can be integrated with SharePoint via 3rd party data providers.

New
json-logo-codeless-data-integration

JSON Data Integration

Integrate your JSON Data with your SharePoint on-premise system.

M
mailchimp-logo

MailChimp

MailChimp data can be synced with SharePoint via 3rd party drivers.

Popular
activedirectory-logo

Microsoft Active Directory

Active Directory data can be pulled to SharePoint lists one-way.

Popular
dynamics-logo

Microsoft Dynamics 365

Microsoft Dynamics CRM data can be integrated codeless with SharePoint via OData.

Popular
dynamics-logo

Microsoft Dynamics NAV

Dynamics NAV data can be integrated with SharePoint two-way via OData.

Popular
office365-logo

Microsoft Office 365

Microsoft Office 365 and SharePoint list data can be kept in sync with SharePoint on-premises via Layer2 provider.

project-logo

Microsoft Project Server

Microsoft Project Server can be integrated with SharePoint via OData.

Popular
sharepoint-logo

Microsoft SharePoint

Microsoft SharePoint list data and Office 365 can be kept in sync with Layer2 provider.

Popular
sqlserver-logo

Microsoft SQL Server

Microsoft SQL Server database data can be synced with SharePoint with the help of the ADO.NET data provider.

foxpro-logo

Microsoft Visual FoxPro and dBase (DBF)

Visual FoxPro and dBase (DBF) data can be kept in sync with SharePoint via OLEDB.

New
mimersql-logo

Mimer SQL

Mimer SQL RDBMS can be integrated with SharePoint via its .NET data provider.

mongodb-logo

MongoDB

MongoDB data can be integrated and synchronized with SharePoint lists.

Popular
mysql-logo

MySQL

MySQL database data can be synced with SharePoint via its .NET data provider.

N
nomadesk-logo

Nomadesk

Nomadesk metadata can be pulled into SharePoint lists with the help of the Layer2 File System Data Provider.

O
odata-log

OData

OData data can be integrated and synchronized with SharePoint lists.

Popular
odbc-logo

ODBC

Many systems and apps can be connected to SharePoint via ODBC.​​​

Popular
office365-logo

Office 365

Microsoft Office 365 and SharePoint list data can be kept in sync with SharePoint on-premises via Layer2 provider.

New
officeatwork-card

Officeatwork

Popular
oledb-logo

OLEDB

Many systems and apps can be connected to SharePoint via their OLEDB drivers.

oracle-solutions-logo

Oracle

Oracle data can be integrated and synchronized with SharePoint lists.

P
New
pervasive-logo

Pervasive PSQL

Pervasive can be connected to SharePoint using its own data provider.

postgre-logo

PostgreSQL

PostgreSQL can connected to SharePoint with the help of their own .Net data provider.​​​

New
sitefinity general data integration via layer2 solutions

Progress Sitefinity

Q
quickbooks-logo

QuickBooks Pro

QuickBooks Pro (Desktop version) can be integrated with SharePoint via 3rd party providers.

New
Layer2 QuoteWerks Data Integration Logo

QuoteWeks®

QuoteWerks® - a product by Aspire Technologies, Inc data can be integrated codeless with native SharePoint lists using the Layer2 Business Data List Connector via OleDb

R
Popular
rss-logo

RSS

RSS News Feed data can be integrated with SharePoint using aLayer2 data provider.

S
New
sage-logo

Sage ERP/CRM

Sage ERP/CRM data can be integrated via the SQL Server database.

Popular
salesforce-logo

Salesforce

Salesforce can be connected with SharePoint via 3rd party .Net data providers.​​​

New
samanage-logo

Samanage ITSM

Samanage data can be pulled to SharePoint via Layer's XML data provider.

Popular
sap-logo

SAP

SAP data can be fully integrated two-way into SharePoint via OData.

New
Logo sap hybris data integration Layer2

SAP C4C Hybris

sap-logo

SAP HANA

SAP HANA data can be kept in sync with SharePoint via OLEDB.

sap-logo

SAP SQL Anywhere (Sybase)

SQL Anywhere data can be integrated with SharePoint two-way via their own .Net data provider.

New
sas-logo

SAS

SAS Data Management data sets can be connected to SharePoint via ODBC.

servicenow-integration-logo

ServiceNow

Popular
sharepoint-logo

SharePoint

Microsoft SharePoint list data and Office 365 can be kept in sync with Layer2 provider.

Popular
soap-logo

SOAP Web Services

SOAP Web Services​ data can be pulled into SharePoint lists one-way.

sqlserver-logo

SQL Server Analysis Services (SSAS)

Microsoft SQL Server Analysis Services (SSAS) can be pulled to SharePoint via OLEDB.

sqlite-logo

SQLite

SQLite data can be fully integrated into SharePoint via its own data provider.​​​

T
New
twitter-logo

Twitter

Twitter data can be connected to SharePoint via ODBC and 3rd party providers.​​​

V
visualstudio-logo

Visual Studio Team Foundation

Microsoft Visual Studio Team Foundation Server (VSTS) data can be connected to SharePoint via OData.

X
xml-logo

XML

XML data can be integrated with SharePoint with read-only XML provider.

Z
zoho-logo

Zoho CRM

Zoho CRM data can be integrated with SharePoint one-way via XML.​​​

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
The Business Data List Connector was an integral tool to a solution we implemented for a customer. Our partnership with Layer2 has added value to our SharePoint practice.
John Farhat, Vice President, ACTS
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
Der Business Data List Connector von Layer2 ist die optimale Lösung, um schnell, einfach und stabil Verbindungen zu unterschiedlichsten Datenbanken zu erzeugen.
Martin Schlenker, IM-consult.net
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
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
Der Layer2 Business Data List Connector für SharePoint ist das entscheidende Produkt um externe Daten in SharePoint zu verwenden. Die Handhabung ist intuitiv. Der Einsatz vermeidet effektiv Datenredundanzen und gewährleistet die Datenintegrität.
Hannes Brünger, Support, SWITCOM GmbH
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

Ready to go next steps?

Icon for Product Regsitration - Layer2 leading solutions

Register for free download.

Keep your SharePoint on-premises in sync with 100+ external sources. Register, download and try today.

Contact Us Icon for Layer2 leading solutions

Questions? Contact us.

We are here to help. Contact us and our consulting will be happy to answer your questions.