The fast, easy and complete integration of external data sources, e.g. databases like SQL Server or Oracle, ERP/CRM systems, Excel and other Office files or web services, is a common requirement in the use of Microsoft SharePoint technology. Existing solutions, such as the Business Data Catalog (BDC) in SharePoint 2007 or the Business Connectivity Services (BCS) in SharePoint 2010 and 2013, are often too complex at the facility, requiring tools or programming, revealing strong limitations, or are available for certain SharePoint editions only.|
With the Layer2 Business Data List Connector for SharePoint
you can connect native
SharePoint lists (no Web Parts or BCS external lists) to almost any external business data sources in just minutes, directly in the list settings dialogue. No additional tools or programming are required. It can easily be configured by using three simple settings: data provider, connection string and data query. Any SharePoint admin can do this. The desired data can be populated to the list and presented without any restrictions, with the full read-only or optionally write-back (CRUD: Create / Update / Delete) functionality of native SharePoint lists: Views, sorting and grouping, search, filters, calculated fields, lookups, metadata fields, attachments can be created as usual. List workflows and notifications per RSS or email can be used to take business actions in SharePoint, when external line-of-business data records are changed.