BDC
There are 3 entries for the tag BDC
I am actually pleased that today we have a bit of variety in tools that can generate BDC Application Definitions. An addition to this list of tools is "MOSS BDC Design Studio" by Simego, which actually quite good and easy to use. The site offers a 14 day trial version, and prices aren't that bad (but me thinks it should priced more a little bit more reasonably). But still for all the tool is quite good, it seems to be limited to SQL Server and WebServices which is a limitation. The other limitation...
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...
Access Denied for User 'MOSS\crawlUser'. Securable MethodInstancewith Name 'TableIDEnumeratorInstance' has ACL that contains: User 'MOSS\administrator' with Rights 'Execute, Edit, SetPermissions, UseInBusinessDataInLists, SelectableInClients' or The parameter is incorrect. (Access denied by BDC.) If you get either of the error message above trying to crawl the BDC, the error could possibly be caused by the crawl account not having access to the BDC application defintion; i.e. the crawl account is...