Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I was able to crawl a table (from an external SQL database) via SP 2010 and it works great. However, I wanted to have SP crawl multiple tables from that same database and it's not happening. For some reason, it only returns results from that 1 table. I've checked the ECT settings and they have CRUD permissions on all the tables. I don't know what to do.

Any ideas??? thanks!

share|improve this question
add comment

1 Answer 1

In Central Administration search configuration, make sure you that when you configure your content source that you check the box "Crawl all external data sources in this Business Data Connectivity Service Application". You should also see all the sources listed with checkboxes if you want to be selective (you can check that all your tables are showing up).

Also, make sure that you have created an External Content Type for each of your tables that you want to crawl.

Do a full crawl of this content source. If you still don't see results, check your crawl logs to identify any problems.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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