Gravatar for rob.mcclanahan@arrowdesigns.com

Question by rmcclanahan, Apr 21, 2016 10:43 AM

Indexing Sharepoint to display results within Sitecore

I am working on indexing SharePoint content so that we can display those results in our custom Sitecore search UI. We are currently running in to 2 issues that i dont fully understand.

  1. Does anything need to be installed on the SharePoint side if we do not have a search UI within SharePoint. It looks like based on the documentation the answer is no but it wasn't clear how the connector crawls SharePoint. Is the connect using the SharePoint Web API?

  2. Since Sitecore users will be searching the SharePoint index, security may be an issue. Everything in the SharePoint index will be available to any Sitecore user. Would we just need to set something up with impersonation to make sure the Sitecore user will be able to access the SharePoint index?

Thanks, Rob

1 Reply
Gravatar for jflheureux@coveo.com

Answer by Jean-François L'Heureux, Apr 21, 2016 3:21 PM

Hi Rob,

I'm not an expert in SharePoint but I'll try to answer your questions:

  1. I don't think there's anything to install inside SharePoint. You can follow the quick setup related to your environment (see Microsoft SharePoint Source Quick Setups).
  2. Your Sitecore and SharePoint indexed documents won't have common securities by default. You have a few options.

Options for searching SharePoint documents inside a Sitecore search page:

  1. If you are using the January 2016 release of Coveo for Sitecore or later AND you are able to map the Sitecore users to SharePoint users, you could create a processor for the getSearchUserIdentities pipeline to inject an additional SharePoint user identity on queries done in the Sitecore search page.
  2. If all your SharePoint indexed documents should be searchable by all the Sitecore users, you can modify your SharePoint source permissions. You'll need to add the "Everyone" "Group" for your Sitecore security provider to the allowed users on your SharePoint source. To do this in CES7 Admin Tool, edit your SharePoint source, go to the "Permissions" section in the left menu, choose "Index security permissions and specify additional security permissions to index", add the everyone group in the allowed users, click on the "Apply Change" button, then rebuild your source. (see step #3.c of Displaying External Content in a Search Interface).

I hope this helps,

Jeff

Gravatar for rob.mcclanahan@arrowdesigns.com

Comment by rmcclanahan, Apr 21, 2016 3:48 PM

Thanks for the response. I did see that there is a "Coveo SharePoint web service" that will help index content but it is optional. We may want to test with and without that web service to see if it is needed but I cannot find when to download it. I do not see it when i got to the product update site. Is there another location where I can download this?

Gravatar for sdesilets@coveo.com

Comment by Sebastien Desilets, Apr 21, 2016 4:06 PM

The installer of the Coveo SharePoint Web Service is part of the Coveo .Net Front-End installer. If you run it on a SharePoint Web Front End you will get the options to install the Web Service.

The current latest version is available here: http://download.coveo.com/download/SearchInterface/12.0.1459/x64/Coveo%20.NET%20Front-End%2012.0%20x64%20(1459).exe

Gravatar for mlaporte@coveo.com

Comment by Martin Laporte, Apr 22, 2016 5:36 AM

For the record, if you'd needed to enforce security on SharePoint content it would have been needed to configure "Claims" authentication as described here: https://developers.coveo.com/display/public/SearchREST/On-Premises+SharePoint+Claims+Authentication

But in your case it's much more simple. Just including this for future readers :)

Ask a question