With the Layer2 Business Data List Connector for SharePoint you can connect native SharePoint on-premises lists to almost any external business data sources in just minutes, via the browser-based SharePoint General List Settings dialogue. No additional tools or programming are required. The connection can easily be configured by three simple settings: data provider, connection string and data query. Any SharePoint administrator can do this in just a few minutes. The desired data can be populated to the list and presented without any restrictions, with the full read-only and also write-back (CRUD) functionality of native SharePoint lists.
Views, sorting and grouping, search, filters, calculated fields, lookups, metadata fields, offline and mobile access, and attachments can be created as usual with your external data. List notifications per RSS or email and even workflows can be used to take business actions in SharePoint, when external line-of-business data records are changed. The Layer2 Business Data List Connector can close many gaps that still exist with SharePoint out-of-the-box data integration via Business Connectivity Services (BCS) and external lists. It simplifies your SharePoint architecture and provides ALL native SharePoint list features for external data with highest performance and security.