Solved

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

Posted on 2011-02-25
3
281 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

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. …
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

740 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