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. 150+ 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.

TRY FOR FREE

Find Use Cases by Topic

What do you want to connect today?

A

Access

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

Active Directory

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

Azure DevOps

Azure DevOps data can be connected to SharePoint via OData.

Azure SQL

Keep Azure SQL data in sync with SharePoint

B

BlackCompass Visualizer

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

Box

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

C

C4C Hybris

Capsule CRM

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

CSV

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

D

Dynamics 365

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

Dynamics NAV

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

E

Exact Online

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

Excel

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

Excel Services

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

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

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

H

HFSQL Database

HFSQL data can be synced with SharePoint via ODBC.

Highrise CRM

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

Hybris

I

IBM DB2

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

IBM Informix

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

IBM iSeries AS/400

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

IBM Lotus Notes

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

Intersystems Caché

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

J

JIRA

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

JSON Data Integration

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

M

MailChimp

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

Microsoft Active Directory

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

Microsoft Dynamics 365

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

Microsoft Dynamics NAV

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

Microsoft Office 365

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

Microsoft Project Server

Microsoft Project Server can be integrated with SharePoint via OData.

Microsoft SharePoint

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

Microsoft SQL Server

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

Microsoft Visual FoxPro and dBase (DBF)

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

Mimer SQL

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

MongoDB

MongoDB data can be integrated and synchronized with SharePoint lists.

MySQL

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

N

Nomadesk

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

O

OData

OData data can be integrated and synchronized with SharePoint lists.

ODBC

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

Office 365

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

Officeatwork

OLEDB

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

P

Pervasive PSQL

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

PostgreSQL

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

Progress Sitefinity

Q

QuickBooks Pro

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

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