Layer 2 GmbH

Business Data List Connector for SharePoint Data Integration

by Layer 2 GmbH

The SharePoint Business Data List Connector connects any native SharePoint list (e.g. contacts, tasks, events, custom list etc. - no Web Parts or BCS) to almost any external data source, using a very simple browser-based dialogue. Simply click "Connect to external data source" in your SharePoint list settings and:

- Select connection provider
- Enter connection string
- Enter select statement
- Enter primary keys (if any)

The required SharePoint list structure is created automatically, filled with data and modified external data is updated very fast in background using a SharePoint timer job.

The desired data can be presented without any restrictions, with read-only and optionally full write-back / CRUD functionality of common native SharePoint lists made available: views, sorting and grouping, filters, calculated fields, metadata, search, workflow, RSS, email notifications - if external data is changed, etc.

The SharePoint Business Data List Connector (BDLC) can be used to connect SharePoint lists to databases, such as:

- MS SQL Server or Azure SQL, Sybase
- Oracle
- Sybase Advantage Database Server
- Sybase Adaptive Server Enterprise
- Informix
- Postgre SQL
- IBM UniData
- IBM UniVerse
- AS/400 (IMB iSeries)
- Progress
- Filemaker
- more

With the BDLC you can pull data to SharePoint lists directly from data files, e.g. MS Excel, MS Access, Visual Foxpro, DBF, Filemaker, Text-/CSV/XML/HTMLfiles.

You can also link SharePoint lists directly to services like OLAP, Active Directory (AD), MS Project, MS SharePoint, MS Exchange, MS CRM, MS Index Server, IBM Lotus Notes, Navision, ODBC/OLEDB, OData.

Cut SharePoint integration costs now - codeless and in just minutes.

Also available is a cloud version of this product: Layer2 Cloud Connector for Microsoft SharePoint and Office 365.

Recent Reviews

  • 5.0
  • Overall Rating 5 stars


Reviewed by:BryanJones Reviewed on:6/18/2014

  • 5.0
  • Overall Rating 5 stars

Layer2 Business Data List Connector for SharePoint

Reviewed by:MarkBlankenburg Reviewed on:4/24/2014

  • 4.0
  • Overall Rating 4 stars

Review BDLC 5.0

Reviewed by:TejasKatke Reviewed on:4/7/2014

View All 45 Reviews

Submit A Review

The views and opinions submitted and expressed here are not those of Microsoft.

Screenshot 1 out of 3 Screenshot 2 out of 3 Screenshot 3 out of 3
Screenshot 1 out of 3 Screenshot 2 out of 3 Screenshot 3 out of 3