Business Data List Connector - BDC's alternate

This is a good solution provided by Layer2, which will be used as an alternate solution for BDC.
It connects a REAL SharePoint List Without Any WebPart to external business data.
Click here to learn more...

BDC Column for SharePoint List

This custom column type provides a BDC Column type that can be created at the Site Column level and therefore used in Site Content Types. Out of the box this is not possible, and the ability to reuse BDC columns across sites and content has been identified as a common requirement. At this stage there are a number of things that are not yet implemented, including related fields, refreshing and nicer admin UI. Read more...

You can download the WSP from here...

Everything You Need to Know about BDC

I am still waiting for the article to finish all its 8 parts on SharePoint Magazine... meanwhile I found, There are two approaches for working with BDC: creating the XML schemas manually or employing SharePoint's Object Model to programmatically interact with the LOB system.

This is one of the good article I found on SharePoint Magazine. This article containing 8 parts. I am listing 5 out of 8 as others are still not published.

Part 1, BDC Technical Architecture
Part 2, Application Definition File (ADF) and its Development
Part 3, Developing an ADF to Connect to Web Services
Part 4, Using BDC Web Parts to Consume BDC Data and Embedding BDC Data in Lists
Part 5, configure Enterprise Search to crawl BDC data.
Part 6, importing User Profiles from BDC
Part 7, BDC Object Model