SharePoint External Database Integration

Data queries from many database systems can be connected to SharePoint lists with the help of the Layer2 Business Data List Connector. List data can be kept in sync with the external systems one-way or even two-way. SharePoint can add search, data acquisition, reporting, dashboards, and workflows to your existing databases. Find your system below to learn more about connectivity settings, best-practices, known issues, and workarounds.

Use Cases by Vendor

Use Cases by Topic

Find your Use Cases

A

Popular

Access

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

Popular

Azure SQL

Keep Azure SQL data in sync with SharePoint

C

CSV

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

H

HFSQL Database

HFSQL data can be synced with SharePoint via ODBC.

I

Popular

IBM DB2

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

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.

M

Popular

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.

New

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.

Popular

MySQL

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

O

Popular

ODBC

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

Popular

OLEDB

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

P

New

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.

Q

QuickBooks Pro

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

S

SAP HANA

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

SAP SQL Anywhere (Sybase)

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

New

SAS

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

SQLite

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

Ready for next steps?

Questions? Contact us.

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

Contact us

Layer2 leading solutions product regsitration icon: a grey square with a big orange pen symbol.

Register for free download.

Keep your SharePoint in sync. Download and try today.

Free Trial