Solved

Unabel to crawl/search multiple tables (external database sQL) in SP 2010

Posted on 2011-02-25
3
277 Views
Last Modified: 2012-05-12
hi everyone,

I was able to crawl a table (from an external SQL database) via SP 2010 and search it 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!


--------------------------------------------------------------------------------
0
Comment
Question by:pfaruiz619
3 Comments
 
LVL 5

Accepted Solution

by:
mo1one earned 250 total points
ID: 35480112
One ECT corresponds to one Entity. Unless you have a View in ECT which gets data from multiple tables by using SQL Join inside the view Or a SQL query with multiple joins to view the data.

This view or a query with join will be helpful for only reading data and you may not be able to do CRUD operations on that.

0
 
LVL 17

Expert Comment

by:GreatGerm
ID: 37693312
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now