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
- IBM DB2
- Sybase Advantage Database Server
- Sybase Adaptive Server Enterprise
- Postgre SQL
- IBM UniData
- IBM UniVerse
- AS/400 (IMB iSeries)
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.
Layer2 Business Data List Connector for SharePoint
View All 45 Reviews
Submit A Review
The views and opinions submitted and expressed here are not those of Microsoft.