This is a very complex topic but what I do know is that its an extremely powerful tool to aggregate disparate data sources in our organization. I would like to know of any resource (discussions / forums / tools, etc) that I can be exposed to that will aid me in my effort to not only understand the BDC but develop a strategy for implementing it across our Enterprise.
Shane,
I don't know if any other forums than here that will help with the strategy; ask away! :)
As for tools, I recommend BDC Meta Man.