This software enables SharePoint lists to connect with over 100 external data sources, without the need for programming. It can be done by simply selecting the required data provider, entering the query, and the connection string. All list features such as workflows, write-back, and search are supported.
The Layer2 Business Data List Connector (BDLC) is a software that provides fast, easy and complete integration of external corporate data with Microsoft SharePoint technology. This is a common requirement for businesses that use SharePoint, but existing solutions like Business Connectivity Services (BCS) are complex at the facility, with serious issues and limitations.
With the BDLC, you can connect ANY native SharePoint list to 100+ external data sources. You only need to use a very simple list settings dialogue that involves selecting a connection provider, entering a connection string, and entering a data query like SQL. The SharePoint list structure can be created automatically, and modified data is updated very fast in the background or manually on-demand.
Furthermore, you can use bi-directional operation with full write-back (CRUD) to the data source. The BDLC also allows you to present the desired data with the full features of native SharePoint lists, including views, sorting and grouping, filters, calculated fields, search, and offline access.
Moreover, workflows and notifications can be used to take business actions directly in SharePoint if external business data records are changed. The BDLC can connect native SharePoint lists to databases, such as MS SQL Server, Oracle, IBM DB2, MySQL, Sybase, Informix, PostgreSQL, IBM UniData, IBM UniVerse, AS/400 (IBM iSeries), Progress, and more.
With the BDLC, you can also pull data to SharePoint lists directly from data files like Text/CSV, XML, MS Excel, MS Access, Visual Foxpro, DBF, Filemaker, and link SharePoint lists to web services like OData, OLAP, Active Directory, MS Project, Exchange, SharePoint, Office 365, Dynamics, Lotus Notes/Domino, SAP, and more.
The feature is available for SharePoint Server 2007/2010/2013/2016 including Foundation, and a similar tool is available for SharePoint Online and Office 365. The BDLC is an excellent solution for businesses seeking a simple yet powerful way to let SharePoint integrate with external corporate data without the issues and limitations posed by existing solutions.
With the BDLC, you can connect ANY native SharePoint list to 100+ external data sources. You only need to use a very simple list settings dialogue that involves selecting a connection provider, entering a connection string, and entering a data query like SQL. The SharePoint list structure can be created automatically, and modified data is updated very fast in the background or manually on-demand.
Furthermore, you can use bi-directional operation with full write-back (CRUD) to the data source. The BDLC also allows you to present the desired data with the full features of native SharePoint lists, including views, sorting and grouping, filters, calculated fields, search, and offline access.
Moreover, workflows and notifications can be used to take business actions directly in SharePoint if external business data records are changed. The BDLC can connect native SharePoint lists to databases, such as MS SQL Server, Oracle, IBM DB2, MySQL, Sybase, Informix, PostgreSQL, IBM UniData, IBM UniVerse, AS/400 (IBM iSeries), Progress, and more.
With the BDLC, you can also pull data to SharePoint lists directly from data files like Text/CSV, XML, MS Excel, MS Access, Visual Foxpro, DBF, Filemaker, and link SharePoint lists to web services like OData, OLAP, Active Directory, MS Project, Exchange, SharePoint, Office 365, Dynamics, Lotus Notes/Domino, SAP, and more.
The feature is available for SharePoint Server 2007/2010/2013/2016 including Foundation, and a similar tool is available for SharePoint Online and Office 365. The BDLC is an excellent solution for businesses seeking a simple yet powerful way to let SharePoint integrate with external corporate data without the issues and limitations posed by existing solutions.
What's New
Version 7: Support for Microsoft SharePoint Server 2016
Version 5.1: Fixes, improved data providers
Version 3.0: All SharePoint list types are supported with V2.0, e.g. contacts, tasks, events...
Version 2.0: All SharePoint list types are supported with V2.0, e.g. contacts, tasks, events...
Version 1.5: More data sources supported in V1.5
Version 1.0: More language variants on request.