Hybrid Office 365 Search Deep-dive: SharePoint Server 2013 & Office 365 Integration

By Errin O'Connor posted 08-02-2014 11:04


Hybrid Search Deep-dive: SharePoint Server 2013 & Office 365 Integration


One of the most common configurations that is starting to emerge into today’s IT landscape is that of a hybrid cloud architecture and is something you must plan for in your organization's long-term SharePoint and/or Office 365 roadmap.

SharePoint Server 2013 can integrate with cloud-based solutions such as Office 365 and/or SharePoint Online in a secure and federated manner that will allow a user with proper permission’s search to return results from both on-premises in SharePoint Server 2013 as well as in Office 365 in the cloud, as shown in image below.

Hybrid Cloud (Hybrid SharePoint 2013 & Office 365) Architecture Summary Overview

The following is a summary of a hybrid SharePoint Server 2013 and Office 365 search integration and the related components:

  • The remote SharePoint Index allows for the search to be federated between the on-premises SharePoint Server 2013 environment and the cloud-based Office 365 environment for a hybrid cloud environment architecture
  • This sample configuration provides query capability and additional configurations can be implemented to support crawl

Hybrid Cloud Architecture Overview

The hybrid cloud architecture requires:

  • Configuration of an OAuth trust between your on-premises SharePoint 2013 farm and your Office 365 tenancy
  • The creation of a result source for the remote farm
  • An externally addressable endpoint for the on-premises farm (reverse proxy) that can be reached via the Office 365 sites
  • This sample configuration allow you to query the result source directly or create a query rule to also allow for user queries to the cloud-based Office 365 or remote farm when needed
  • A token is created for the user and security trimmed results are returned which requires 2-way AD synchronization between the SharePoint Server 2013 on-premises environment and Office 365
  • By using a query rule you can integrate the results from both farms into a single display for users and tailor the UI as desired
The results of a hybrid cloud search from a user searching both SharePoint Server 2013 and Office 365:


Search Web Parts in SharePoint 2013, Office 365 and/or SharePoint Online

There are several new web parts for Search in this latest release of SharePoint that allow users an entire new experience when conducting search. The following is a list of the core search related web parts in SharePoint 2013, Office 365 and/or SharePoint Online:

Content Search Web Part (CSWP)

The content search web part utilizes various capabilities to display dynamic content within SharePoint pages. Each content search web part within a page is directly associated to a search query and displays the results for that search query while providing options to easily tailor the way the results reflect within the web part.

• Exposes results as JSON (JavaScript Object Notation) on page

• Customize search results rending

• Easier to customize than content by query web part styles

• Client-side solution using returned results as JSON (JavaScript Object Notation)

• Server side via custom Display Templates

• Content is only editable at the source

Refinement web part

The refinement web part allows users to filters the search results from a search results web part into additional categories to allow for more intelligence decisions making on the result set.

Search box web part

• The search box web part is typically utilized on the home page of the Search Center (default.aspx).

Search navigation web part

• The search navigation web part displays links to the different major search verticals such as Everything, People, Conversations and Videos.

Search results web part

The search results web part displays the results of a search query entered in a search box web part. The search results web part, OOTB (e.g. native), is used on all search vertical pages and displays the actual search results returned. The web part also relays search results to the refinement web part.

You can add refiners to a page to narrow the items that are shown in a Content Search Web Part, and help users quickly browse to specific content. Refiners are based on managed properties from the search index. To display refiners on a page, you must first enable the managed property that you want to use as a refiner, and then add a Refinement Web Part to the page where you want the refiners to appear. 

Refinement web part

In SharePoint 2013, you can add refiners to a page to help you continue to narrow the scope of a search to find the very specific content. These refiners, for which you first must enable the managed property you are wanting to use as a refiner, allow you to then add a refinement web part to the page where you are wanting these specific refiners to appear.

Note: You must have the relevant publishing features enabled to include the cross-site publishing feature in order to utilize web parts such as the refinement web part.

Tailoring the Search UI of SharePoint 2013 and/or Office 365’s

When updating the user interface (UI) of SharePoint 2013, Office 365 and/or SharePoint Online it should be performed in a governed manner that follows the branding and UI standards of the organization.

The search UI itself has specific characteristics for which you can tailor or configure as a “one off” branding initiative or to simply offer a set of specific and tailored search result-type pages to meet a department or specific user’s needs.

SharePoint’s search UI configuration elements mainly consist of:

• Result types

• Display templates

• Query suggestions

• Thumbnail preview features

These new search UI related features can now be administered by site and site collection administrators but must follow the organization’s overall governance strategy in relation to permissions and specific user capabilities.

Result Types

Result types in SharePoint 2013 are similar in nature to query rules as they allow you to define rules for when a specific search result can trigger a specified display template. A display template contains the list of managed properties that can be utilized in the results and also can control how the results themselves should be rendered.

There are a wide range of options that can be utilize around defining the specific rules for when a result type should perform a specific action.

The underlying framework allows you to create custom comparisons based on equality, greater than or less than well as logical operators.

For example, “Equality(= or !=), comparison (< or >), or logical (AND or OR or NOT).” Multiple rules can also be combined for a specific condition while also giving you the option to use managed properties in a rule.

Providing custom metrics for a result type


Display Templates in SharePoint 2013 & Office 365's Search

Display templates provide the actual rendering of an individual search result and provide for a dynamic array of options to create very visual and interactive search results and is compatible fully compatible with HTML.

With the new focus of allowing HTML you are not limited to a specific HTML editor so based on yourorganization’s governance strategy you may be able to utilize not only SharePoint Designer 2013 but Visual Studio, notepad, Dreamweaver or other tool for which you are comfortable editing in.

When the HTML is created for which you would drive the resulting specific search result, there are underlying placeholder tags that are used to indicate where you should specify the output a managed property (result title, author, etc.).

For example, the image below shows a SharePoint 2013 search that was run using a sample custom result type and corresponding display template for .TXT file stored in SharePoint Server 2013.

An example of a custom result type and corresponding display template for .TXT file stored in SharePoint Server 2013


There are a number of display templates that SharePoint 2013 natively contains for which you review and copy to a new file name to begin modifying and quickly start to learn and test to perfect this new capability.

Search Display Templates

• Display templates contain the following characteristics:

• They define the visual layout of a Result Type

• A template is really just HTML

• You can edit it with any HTML designer including Dreamweaver, SharePoint Designer, Visual Studio, Notepad, etc.

• You add placeholders to your HTML file where managed properties should be emitted

• It gives you a real WYSIWIG experience when designing templates

• A set of display templates is included OOB; you can find them in the Master Pages/Display Templates/Search folder

• Site collection admins can upload new display templates

After you have spent some time developing and testing this features to “get your feet wet” you can then upload the display template to a site, site collection or at a farm level for which it can then be added to a search service application.

Query Suggestions

Query suggestions allow you to take advantage of the suggestions that SharePoint 2013 provides via a personal query log that is stored of all the queries you execute. This personal query log is utilized to provide query suggestions by SharePoint 2013 by remembering the search queries that you have executed before as well as search results that you’ve selected and clicked on in the past. 

SharePoint 2013’s search also pulls in frequent queries from all users within the organization to include relevant results to your query for which others also found to be useful and accurate.

This builds on a foundation of SharePoint’s search learning with you and your organization to provide query suggestions as another option to find relevant content in addition to the standard browse and “findability” experience that you would get with just a standard raw search.

SharePoint 2013 also allows additional configuration to add custom inclusions and exclusions for query suggestions to users via the search service application administration pages.

SharePoint 2013 provides for two variants of query suggestions which occur at different times during the search process. There are query suggestions that appear as you are typing in the search box as well as suggestions that appears after your query is executed.

In the first query suggestion variant, as you’re typing in the search box you will see a list of queries for which you have previously executed which you can click on as well as a list of other queries from users across the farm whose queries have led to two or more successful searches, as shown in image below.

Query Suggestion feature in SharePoint 2013’s Search showing previous successful searches

In the second query suggestion variant, once your search is executed, SharePoint will provide you with a list of additional choices based on search results that you have personally clicked on when you had executed the same query at a previous time within the platform.

This feature enables you to quickly execute a search for content that you may routinely search for via the utilization of the same query to find specific documents or list or library items.

To summaries, this features allows for the following:

• Your personal SharePoint activity factors into the query suggestions

• It includes weighting based on sites that you have previously visited

• It uses the most frequent queries across all users that “match” the search terms

• The behavior of the query suggestions turns into more of a “browse and find” kind of experience

• You can also add inclusion and exclusion lists for suggestions via the search service application admin pages

Thumbnail Preview in SharePoint 2013 & Office 365 | SharePoint Online

SharePoint 2013 utilizes Office Online (the rebranded Office Web Apps) to provide the ability to be able to view a thumbnail preview, as shown in the image below, of a document or piece of content without actually having to open the specified content.

SharePoint 2013’s Thumbnail Preview example


Similar to YouTube or Bing Videos, you can also hover your pointer over presentations to view a short animations as well as zoom in and out to ensure the selection if the correct content for which you are trying to retrieve.

There is no delay if the content that you hovered over to view the thumbnail preview is not the content for which you are requiring as you can simply view the other search results and click on the other items to also preview them before making your ultimate selection.

This feature has been a resounding hit for our clients at EPC Group as it reduces time by ensuring the document they are previewing is correct by quickly looking for things like formatting, logos, color schemes and other easily identifiable markings.

Note: SharePoint 2013’s default authentication is clams-based authentication and most all organizations who have upgraded and\or migrated from a previous version of SharePoint 2010 have more than likely converted any classic-mode web applications to claims-based authentication or opted to create a new claims-based web application in SharePoint 2013.

It is important to be aware that if you organization still has any classic-mode web applications, the thumbnail preview feature will have issues and not properly function which can cause confusion for your user base.

EPC Group’s Nationally Recognized Practice Areas

EPC Group leading SharePoint, Office 365, Infrastructure Design and Business Intelligence Practice areas continue to lead the way in providing our clients with the most up-to-date and relevant information that is tailored to their individual business and functional needs.

Additional "From the Consulting Trenches" strategies and methodologies are covered in EPC Group's new book, "Sharepoint 2013 Field Guide: Advice from the Consulting Trenches" covering not only SharePoint 2013, Office 365 and SharePoint Online but Information Management, ECM\RM and overall compliance strategies in this ever changing world of "Hybrid IT."

#EPCGroupLessonsLearned #SharePoint2013SearchConfiguration #Search #SharePointandOffice365HybridConfiguration #Office365SearchConfiguration