• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
TSB Alfresco Cobrand White tagline

Technology Services Group

  • Home
  • Products
    • Alfresco Enterprise Viewer
    • OpenContent Search
    • OpenContent Case
    • OpenContent Forms
    • OpenMigrate
    • OpenContent Web Services
    • OpenCapture
    • OpenOverlay
  • Solutions
    • Alfresco Content Accelerator for Claims Management
      • Claims Demo Series
    • Alfresco Content Accelerator for Policy & Procedure Management
      • Compliance Demo Series
    • OpenContent Accounts Payable
    • OpenContent Contract Management
    • OpenContent Batch Records
    • OpenContent Government
    • OpenContent Corporate Forms
    • OpenContent Construction Management
    • OpenContent Digital Archive
    • OpenContent Human Resources
    • OpenContent Patient Records
  • Platforms
    • Alfresco Consulting
      • Alfresco Case Study – Canadian Museum of Human Rights
      • Alfresco Case Study – New York Philharmonic
      • Alfresco Case Study – New York Property Insurance Underwriting Association
      • Alfresco Case Study – American Society for Clinical Pathology
      • Alfresco Case Study – American Association of Insurance Services
      • Alfresco Case Study – United Cerebral Palsy
    • HBase
    • DynamoDB
    • OpenText & Documentum Consulting
      • Upgrades – A Well Documented Approach
      • Life Science Solutions
        • Life Sciences Project Sampling
    • Veeva Consulting
    • Ephesoft
    • Workshare
  • Case Studies
    • White Papers
    • 11 Billion Document Migration
    • Learning Zone
    • Digital Asset Collection – Canadian Museum of Human Rights
    • Digital Archive and Retrieval – ASCP
    • Digital Archives – New York Philharmonic
    • Insurance Claim Processing – New York Property Insurance
    • Policy Forms Management with Machine Learning – AAIS
    • Liferay and Alfresco Portal – United Cerebral Palsy of Greater Chicago
  • About
    • Contact Us
  • Blog

Documentum, SharePoint, OpenSearch and cross-repository searching

You are here: Home / Documentum / Documentum, SharePoint, OpenSearch and cross-repository searching

July 22, 2011

Because clients often leverage SharePoint as their company Intranet, many consider configuring SharePoint as a search portal for external repositories. This approach allows users to use one central interface for searching and retrieving content.  While Documentum provides the MyDocumentum for SharePoint product to provide search access to Documentum, we are seeing more clients wanting a combined search of both Documentum and SharePoint content. This post will discuss the various alternatives as well as present a hybrid open source solution based on our experience.

Issues with “one search to rule them all”

Often times, clients can get caught in a trap of looking for a single search vendor to solve the problem.  Solutions include:

  • SharePoint – have SharePoint crawl the Documentum repository to expose Documentum content and SharePoint content from a single search.
  • Third Parties – whether FAST or Autonomy or open source tools like Lucene, clients look for third party tools to index all content as part of an enterprise search effort.  This solution can be accessed either from within SharePoint or outside.

Issues with the “one search” approach include:

  • Just a “Google” Search? – ECM users might think they want a “Google” search but often want more than just text searching.  As we mentioned in a previous post, the search of “show me all documents that contain this word” is very different then “show me all SOP’s for this product and this location that contain this word”.  Combination of meta-data and content is a typical ECM search requirement.
  • Security – Documentum users get concerned about crawlers indexing their content.  Often times, Documentum users want to restrict world users to approved content. In addition, if security recently changed in Documentum, and the index hasn’t been updated, restricted documents may still be displayed in the results.
  • Crawler – Documentum support resources can rightly be concerned about how often the search crawler will be crawling/accessing Documentum content to refresh the content for the search tool.  Since Documentum support is used to indexing on their own (via FAST or xPlore), the overhead of two search tools can be a concern.

Searching External Data from SharePoint leveraging OpenSearch

In SharePoint 2010, there a two “out of the box” methods for searching external data:

–          Index in SharePoint – As mentioned earlier, SharePoint can crawl the external system and add its data to the SharePoint search engine’s index; this can be extended with the Business Data Connectivity Service. This allows for metadata searching, but at the cost of the security and crawling issues mentioned above.

–          OpenSearch – SharePoint 2010 can also query directly against the external system, leveraging a Federated search location and OpenSearch. OpenSearch is the industry standard for performing “Google-like” searches against external systems and displaying results. This solves the crawling and security issues, but not the “Google” search limitations.

Example of creating a new Federated Search location in Central Administration

One significant issue with leveraging OpenSearch is, as mentioned earlier, it is just a “Google” like search that doesn’t allow querying metadata. Additionally, OpenSearch queries are not supported by Documentum.

A Hybrid OpenSearch/SharePoint Solution

In order to create a search solution to address the aforementioned issues and limitations, we developed a search solution for SharePoint. The solution is composed of the following:

  1. A customizable form to build a keyword and metadata query in SharePoint
  2. A custom servlet that translates the search criteria into an OpenContent query and returns the results
  3. A customized XSL template to style the search results and expose metadata

Leveraging TSG’s OpenContent API, we are able to run OpenSearch searches against any external repository such as Documentum to return our search results.  The OpenSearch standard allows us to pass in additional metadata values into our search criteria not exposed in the SharePoint implementation, and OpenContent is able to translate each of these metadata requests into a proper query for Documentum, and return the results in an extended RSS XML result (per the OpenSearch specifications). The final piece of the user experience is to customize the xsl stylesheet for the search results to display our additional metadata from the target system in a tabular format that users expect. As shown below, the federated results can be placed alongside SharePoint results within the page.

 

Example showing Documentum results and external metadata (bottom) alongside SharePoint results

For more information, please contact us at inquiry@tsgrp.com or comment on this post.

Filed Under: Documentum, SharePoint Tagged With: Documentum, Sharepoint

Reader Interactions

Trackbacks

  1. Documentum and SharePoint Searching – An Integration Approach « TSG Blog says:
    October 6, 2011 at 12:35 pm

    […] – As detailed in a previous post, OpenSearch is supported by Microsoft to provide a federated search against multiple […]

    Reply
  2. Replacing the PIA (Primary Interop Assembly) « TSG Blog says:
    December 18, 2012 at 10:13 am

    […] Documentum, SharePoint, OpenSearch and cross-repository searching  […]

    Reply
  3. Documentum Upgrade – Support Multiple Applications using a single HPI Solr Portal Cache | TSG Blog says:
    June 20, 2013 at 1:01 pm

    […] Documentum, SharePoint, OpenSearch, and cross-repository searching […]

    Reply

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search

Related Posts

  • Migrating From Documentum with OpenMigrate: Best Practices
  • GKC ARMA Panel Recap – Emerging ECM Trends
  • Microsoft Teams integration and the Alfresco Enterprise Viewer for Document Review
  • Alfresco Enterprise Viewer – Offline Annotation for Efficient Review
  • Alfresco or Documentum – Improving Performance Perceptions with OpenAnnotate
  • Workshare Compare for More Efficient Review and Approval of Document Changes
  • Office 365 – Check-in and Check-out with Documentum, Alfresco or Hadoop
  • EMC said planning to sell Documentum Business Amid Dell Deal – (Bloomberg)
  • Documentum D2 – Announcing OpenAnnotate Support
  • Documentum or Alfresco – TSG Government Solution

Recent Posts

  • Alfresco Content Accelerator and Alfresco Enterprise Viewer – Improving User Collaboration Efficiency
  • Alfresco Content Accelerator – Document Notification Distribution Lists
  • Alfresco Webinar – Productivity Anywhere: How modern claim and policy document processing can help the new work-from-home normal succeed
  • Alfresco – Viewing Annotations on Versions
  • Alfresco Content Accelerator – Collaboration Enhancements
stacks-of-paper

11 BILLION DOCUMENT
BENCHMARK
OVERVIEW

Learn how TSG was able to leverage DynamoDB, S3, ElasticSearch & AWS to successfully migrate 11 Billion documents.

Download White Paper

Footer

Search

Contact

22 West Washington St
5th Floor
Chicago, IL 60602

inquiry@tsgrp.com

312.372.7777

Copyright © 2023 · Technology Services Group, Inc. · Log in

This website uses cookies to improve your experience. Please accept this site's cookies, but you can opt-out if you wish. Privacy Policy ACCEPT | Cookie settings
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT