Anybody knows if the BDC can crawl the content of a document that is stored in a blob field in an external SQL Server database? The purpose is to integrate a DMS into Sharepoint's search.

I know I can use the BDC to plug the search to an external database, but what about the content of the document?

Thank you in advance

link|improve this question

feedback

1 Answer

up vote 1 down vote accepted

No, I don't believe that BDC can do that. You would probably have to write a custom protocol handler for the custom DMS. The good news is that this might allow you to use the other DMS's API, rather than going to the database directly.

link|improve this answer
I had the feeling it couldn't, because the BDC has no way to know the content type of the binary. We were trying to crawl a database that had an export of the data meaningful to the integration, not the complete DMS database ;) – Dante May 26 '11 at 23:06
Ah! Then yes, even if you can get the binary stream, handling it will be a pain. – Andy Burns May 27 '11 at 8:16
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.