• 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

SharePoint and Alfresco Search Alternatives

You are here: Home / Alfresco / SharePoint and Alfresco Search Alternatives

November 2, 2011

Similar to our recent post and whitepaper on Documentum and SharePoint integration, this post will present similar options for Alfresco users.  We recently posted an example of SharePoint and Alfresco integration in our Learning Zone.  This post will present a recap of possible solutions to compare and contrast the alternatives. 

Alfresco Access from SharePoint

As we mentioned in a previous post, sometimes users just want a universal search or Google type search.  The simple box in SharePoint can often be viewed (sometimes wrongly) as the means to view all content.

Since most users bring their home search experience to work, the desire for one general box for every search scenario from SharePoint is a common request.  Users can ask “how come I don’t see my procedure 123XYZ when I type 123XYZ into the box?”   While the IT response might be something like: “if you are looking for a procedure, log into Alfresco since approved procedures are located there”,  users, particularly SharePoint users, would like to access one system for all searches.

IT needs to be able to respond to the request of users to provide a simple search across both Alfresco and SharePoint from a SharePoint environment.  The remainder of this post will compare and contrast some common approaches.

Alfresco Publishing to SharePoint

Another approach highlighted previously has been the ability to “publish” content out of Alfresco or other ECM repositories to a cache.  For the cache approach, we have typically implemented OpenMigrate to enable a “publish” job where the approved documents get pushed to another, more subservient read only, repository.  If documents are deleted in Alfresco, the publish job would make sure they are removed from the cache as well.  Typical scenarios have included publishing metadata to a search platform such as Solr, or to a simple database table.  

For SharePoint users, the logical question is why not leverage simply leverage SharePoint storage as a cache and push these documents (or just the approved renditions) to SharePoint.  While OpenMigrate does have a SharePoint target adapter, some obvious concerns would include:

  • Security – One concern would be making security on the document is tight (read only) since allowing for a document to be deleted/moved or versioned would destroy the referential contact.
  • PDF Manipulation – Lots of our clients add dynamic header/footer/signature pages on approved Alfresco documents.  This ability would have to be available in SharePoint if this is a requirement.
  • User confusion –  Users might get confused why some documents they can edit (SharePoint collaboration documents) and some cannot be edited.  Also, SharePoint allows for a “Site Search” as well cross-site search.  We would anticipate that the cache would be limited to one site which might confuse the users in regards to why the document isn’t available across all searches.

SharePoint Federated Web Part

In reviewing alternatives, one of our clients has successfully developed their own approach leveraging SharePoint’s ability to support the OpenSearch protocol for cross-repository searching as documented in this post. 

This approach has a couple of advantages over other approaches:

  • Isolation of SharePoint/Alfresco content – Similar to the Indexing Connector, all of the Alfresco content stays in Alfresco.
  • Federated Search Performance – Search results are returned from both queries (SharePoint and Alfresco) simultaneously. 
  • OpenSearch Limitations – specific limitations of the OpenSearch specification around user security and custom meta-data making it the equivalent of a “Google Search”.  As we have discussed before, users might as for a “Google Search” but, when pushed, examples like “show me the currently approved SOP for this product” is not a Google search.
  • Integration – Some integration needs to be developed to a given cache to provide for OpenSearch connectivity.  Alfresco already supports the OpenSearch protocol.

Downside

  • As presented in the picture below:

While the results are on the same page, they are not really mixed together.   Clients have asked for the ability to sort by column and see all the results in a more tabular format.

 SharePoint/Alfresco Integration Approach

One approach we are currently developing would be leveraging Microsoft SharePoint development tools (ASP .Net) combined with our OpenContent web services to build a dual searching application as a web part within SharePoint.  Highlights of the approach include:

  • Complete leverage of both SharePoint and Alfresco security model
  • One Search against both repositories
  • Results merged into a table that supports paging, filtering and sorting consistent with SharePoint Lists and Libraries.
  • Content streamed from Alfresco repository (or cache) leveraging user’s credentials.
  • Ability to add search for specific meta-data across both repositories

Check out our demo in the learning zone .  We are looking to add this to our downloadable open source in the near future.  Send us an email or post below if you are interested in the beta copy.

Filed Under: Alfresco, OpenMigrate, OpenSearch, SharePoint

Reader Interactions

Comments

  1. ukdavo says

    November 2, 2011 at 9:40 am

    What about using CMIS?

    Reply
  2. Ray says

    November 3, 2011 at 3:15 pm

    Any of these approaches could leverage CMIS to talk to either repository. OpenContent contains CMIS calls in a wrapper as well as additional calls which are not covered by the CMIS spec. This gives us the ability to leverage proprietary features from either repository in an insulated manner.

    Reply

Trackbacks

  1. SharePoint and Alfresco Search Alternatives « TSG Blog | Mastering Sharepoint says:
    November 2, 2011 at 11:26 am

    […] example of SharePoint and Alfresco integration in our … … Read the original here: SharePoint and Alfresco Search Alternatives « TSG Blog ← Add ratings to your documents and list items in SharePoint 2010.wmv Hong Kong […]

    Reply
  2. Documentum Top Tips for 2012 « TSG Blog says:
    December 1, 2011 at 2:49 pm

    […] 3)      Be Prepared for SharePoint….but it will fade for Documentum clients in 2012 –  Since SharePoint 2010, we have seen clients look more and more at SharePoint as a replacement for Documentum.  We thought 2011 would be a big year to move but, for the bulk of the Documentum clients we talk to, SharePoint has been seen as an integration point rather than replacement for Documentum.  As we mentioned in a previous posts, Collaboration is easy while Document Management is hard.  Most clients are sticking with their Documentum infrastructure for the hard stuff.  See our thoughts and whitepaper on Documentum and SharePoint search alternatives. […]

    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

  • Third Annual TSG Client Briefing – June 3rd – 2010
  • OpenContent Solr Services – New TSG Product Offering
  • OpenMigrate 1.7 Released: Enhanced Support for Documentum, Alfresco and SharePoint Migrations
  • Documentum and SharePoint Search Alternatives – TSG WhitePaper Available
  • Documentum Migrations – Interview with OpenMigrate Product Manager
  • Alfresco Consulting – Consulting in an Open Source world
  • Alfresco Consulting – Documentum Disruptor #2
  • Migrating From Documentum with OpenMigrate: Best Practices
  • Documentum – Top 12 Tips
  • Alfresco – Do More with OpenMigrate Services

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