Layer2 Business Data List Connector solves many of the well-known issues that exist with SharePoint on-premises external data integration via BCS. It can keep native SharePoint lists in sync with 100+ external data sources, such as SQL/ERP/CRM and more without any programming, one-way or even two-way, automatically or on-demand. All SharePoint list features are available for your external data: views, filters, lookups, search, forms, change notifications, and workflows. This product is optimized for SharePoint on-premises.