Solved

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

Posted on 2011-02-25
3
283 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

729 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