The fast, easy and seamless integration of external enterprise data sources is a common requirement in the use of Microsoft SharePoint technology. existing out-of-the-box solutions, such as the Business Connectivity Services (BCS), are often complex at the facility, require additional tools or programming, have serious limitations or are available for certain SharePoint editions only. Data is surfaced in SharePoint - but not well integrated.
The Layer2 Business Data List Connector for SharePoint completely seems to solves those issues. You simply have to click "Connect to External Data Source"in your list settings.
Features & Benefits (taken from the vendor page)
The component is offered for SharePoint 2007, 2010, 2013, 2016 all editions. The download is free after registration.