SharePoint Use Cases

  • Home
  • About
  • Our Tools
  • Contact me
SharePoint

Use case: Integrating Microsoft Office SharePoint with Microsoft Dynamics CRM

Toni Frankola - January 28, 2009

Few weeks ago I taught Course 8912A: Customization and Configuration in Microsoft Dynamics CRM 4.0 and a student asked an interesting question:

How should I integrate SharePoint and CRM?

Here are some of my advices and experiences on this topic.

Scenario 1. Integrating CRM with SharePoint (SharePoint to CRM)

  • Problem: CRM is really great application but it lacks document management capabilities (this will probably be shipped with CRM 5.0). You do have an ability to attach documents to CRM entities but you cannot change these later on.
  • Benefits: Each CRM user needs to produce a document that is related to a CRM entity (e.g. Quote). Users will benefit from the ability to see both quote financial information (stored in CRM) and the document itself (stored in SharePoint) from the same application.
  • How to implement it?:
    • Third party solutions: c360 CRM/SharePoint Integration or KWizCom CRM-SharePoint Connector.
    • Custom solution: In one of the next posts, I will explain how to do it.
crm

Figure 1: SharePoint site as a document storage in CRM account entity form.

Scenario 2a. Integrating SharePoint with CRM (CRM to SharePoint)

On the other side, you can use CRM to extend your SharePoint site.

2A. Profiling documents

If you are storing your customer related documents to SharePoint (e.g. Project proposal, project plan, vision scope, quote…) you probably want to uniquely connect each document to a customer from your CRM database. This is easy to achieve. You can use Business Data Catalog to create custom, business columns, which connect to your CRM system directly. With this custom business column, you can profile your documents with the unique values coming from your CRM system.

Benefits:

  • This solution is easy to setup and manage
  • You do not need to duplicated your CRM data (e.g. Accounts and Contacts) in SharePoint lists
  • By using SharePoint filtering and search you will find your documents in no time…

Downside:

  • Business Data Catalogs is a feature of SharePoint Enterprise
doclib1

Figure 2: Document Library with Business Data Columns. Columns source is CRM.

2B. Enterprise Search

When it comes to search, CRM built-in search capabilities are somewhat limited (you can only perform entity by entity search). SharePoint comes to the rescue here, allowing your users to use single query across all entities from a familiar search interface.

Benefits:

  • SharePoint is more powerful search engine
  • Familiar SharePoint search interface
search

Figure 3: Shows unified search results. Some coming from CRM and some from SharePoint.

In next post I will go deeper to explain how you can implement these scenarios…

Tags | crm, integration, SharePoint, sharepoint+crm
 0
Share Now

Toni Frankola

Entrepreneur, IT consultant, speaker, blogger, and geek. Co-founder of syskit.com.

You Might Also Like

SharePoint

Warming Up your Microsoft Dynamics CRM 3.0 on Virtual Machine

July 23, 2007
Misc

Updating name format in Microsoft Dynamics CRM 3.0

July 26, 2007
SharePoint

CRM4 and Firefox

November 15, 2007
Misc

What’s new in CRM 4.0 – Part 1

January 2, 2008

5 Responses

  • Parth January 29, 2009 at 3:15 am

    Nice read! Thanks for the info

  • manish tyagi March 29, 2009 at 10:36 pm

    hi
    i want to integrate the feedback form with MS CRM 4.0 means when i enter the data from feedback form it enter in ms crm. can u help me out from the problem please send me link or any other material that help me in solving this problems. plz send it to my id ermanishtyagi@gmail.com

  • Toni Frankola March 30, 2009 at 3:03 am

    @Manish:

    1) Which SharePoint edition do you use? WSS, SharePoint Standard or Enterprise?
    2) What is a feedback? Is it a new CRM custom entity, or you plan to use an existing one?

    T.

  • Greg October 2, 2009 at 5:04 pm

    One thing, have you run into the issue where once there are 200 or more records in the entity you are using for the BDC drop-down, that it no longer is usable?

  • Toni Frankola October 3, 2009 at 5:03 am

    @Greg: Yes I did have some problems with it. In such a case I would go create custom columns.

  • Comments are closed.

    Previous Post PerformancePoint becomes a part of SharePoint 2007 Enterprise Edition
    Next Post Use case: Integrating Microsoft Office SharePoint with Microsoft Dynamics CRM – Part 2

    Archives

    • December 2021 (1)
    • June 2021 (1)
    • January 2021 (1)
    • July 2019 (1)
    • June 2019 (2)
    • March 2019 (1)
    • February 2019 (3)
    • October 2018 (2)
    • August 2018 (2)
    • June 2018 (1)
    • April 2018 (1)
    • February 2018 (1)
    • January 2018 (1)
    • June 2017 (1)
    • April 2017 (1)
    • February 2017 (1)
    • November 2016 (2)
    • August 2016 (1)
    • July 2016 (2)
    • March 2016 (1)
    • February 2016 (2)
    • January 2016 (1)
    • November 2015 (2)
    • December 2014 (1)
    • November 2014 (2)
    • July 2014 (2)
    • June 2014 (2)
    • May 2014 (1)
    • April 2014 (2)
    • March 2014 (1)
    • February 2014 (4)
    • January 2014 (2)
    • December 2013 (1)
    • September 2013 (1)
    • July 2013 (1)
    • June 2013 (1)
    • May 2013 (1)
    • April 2013 (3)
    • February 2013 (1)
    • December 2012 (1)
    • November 2012 (1)
    • September 2012 (1)
    • August 2012 (1)
    • July 2012 (2)
    • June 2012 (4)
    • April 2012 (1)
    • February 2012 (1)
    • January 2012 (1)
    • November 2011 (2)
    • October 2011 (2)
    • September 2011 (2)
    • July 2011 (3)
    • May 2011 (2)
    • April 2011 (1)
    • March 2011 (4)
    • February 2011 (3)
    • January 2011 (4)
    • December 2010 (4)
    • November 2010 (3)
    • October 2010 (3)
    • September 2010 (4)
    • August 2010 (1)
    • July 2010 (4)
    • May 2010 (2)
    • April 2010 (2)
    • March 2010 (3)
    • January 2010 (2)
    • December 2009 (3)
    • November 2009 (5)
    • October 2009 (2)
    • August 2009 (7)
    • July 2009 (3)
    • June 2009 (4)
    • May 2009 (3)
    • April 2009 (5)
    • March 2009 (8)
    • February 2009 (5)
    • January 2009 (8)
    • December 2008 (9)
    • November 2008 (8)
    • October 2008 (7)
    • September 2008 (4)
    • August 2008 (6)
    • July 2008 (5)
    • June 2008 (3)
    • May 2008 (4)
    • April 2008 (6)
    • March 2008 (4)
    • February 2008 (3)
    • January 2008 (6)
    • December 2007 (1)
    • November 2007 (3)
    • October 2007 (3)
    • September 2007 (2)
    • August 2007 (1)
    • July 2007 (12)
    • June 2007 (2)
    • May 2007 (3)

    Connect Us

    All postings on this blog are provided “AS IS” with no warranties, and confer no rights. All entries in this blog are my opinion and don’t necessarily reflect the opinion of my employer.

    • Home
    • About
    • Our Tools
    • Contact me

    Copyright (c) Toni Frankola 2008. - 2019.