Here are few lessons learnt from playing with the BDC on a project 1. Even though the BDC can crawl associated entities in your database schema, the search results will not show related entity instances for the item you searched. 2. In case of mapping 'complex' db schemas specially ones that contain m:n relationships between entities, sometimes it might be advisable to show un-normalized relationships via stored procedures or views, but this approach provides the following roadblocks Un-normalized...