The Layer2 Business Data List Connector for SharePoint can solve many issues that still exist with the SharePoint out-of-the-box external data integration via BCS. It makes it as easy as possible to connect SharePoint lists to 100+ external data sources, codeless, with no-touch and two-way, if required. All SharePoint list features, such as search, change notifications, and workflows, are fully available for the connected list. This product is optimized for SharePoint on-premises. To integrate external data sources with Microsoft SharePoint Online and Office 365 take a look here. Please learn more about the data sources supported and common use cases below.