• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

CRM is from Mars, SharePoint is from Venus

June 15, 2017   CRM News and Info

SharePoint and Dynamics CRM are excellent products from Microsoft. What happens when you integrate the two platforms?

It reminds me the book “Men are from Mars, Women are from Venus”, written by American author John Gray, and states that most relationship problems between men and women are a result of fundamental differences between the sexes, that men and women are from different planets. Each one is speaking his own language, and they met on earth.

The case here is similar, when you decide to integrate SharePoint with CRM. SharePoint is designed to store unstructured data, and it is excellent document collaboration tool. The strength of CRM is in its ability to capture structured business data, and centrally store it.

While both SharePoint and CRM can exist independently, much more can be achieved when they act in concert.

The Dynamics CRM integration feature enables you to store and manage documents on SharePoint in the context of a Dynamics CRM record, and use the SharePoint document management abilities in CRM. When enabling document management for entities, CRM creates folders in SharePoint, one per each entity selected in the set up process. The folders can be Account or Contact centric folders or standalone folders.

CRM users can select and upload documents to SharePoint, and save them in the corresponding folder in SharePoint, which also bears the name of the entity where the documents are uploaded from. Documents are now spread over different SharePoint folders. While users are expected to work as a team to achieve common business goals through improved communication between CRM and SharePoint users, these folders do not have the familiar structure of folders and tree representation of folders, as we are used to, which makes it so difficult when a document cannot be located or searched for by SharePoint users.

Metadata is the way to go.

Metadata (columns) and views are better and the recommended alternative to managing documents in folders. Metadata provides descriptive information about the document. Views are using the metadata for grouping, filtering and sorting documents in an organized and methodological way.

The challenge is retrieving metadata tags from CRM records and saving them with the documents in SharePoint, where each such field (attribute) retrieved from the CRM record, is saved in the corresponding column of the document library in SharePoint.

Consider a company managing projects in CRM, using a customised Project entity, and billing clients when each of the project’s stages is completed. Using Word Template the Scope of Work (SOW) of the project is generated in CRM, by populating the Word Template with data from the project record and related records. Invoices are also created in CRM, using Invoice Word Template, with the deliveries and services provided for a project stage. In CRM out of the box integration with SharePoint, both documents, the Project SOW and related invoices are uploaded to CRM, one to the Project folder the other to Invoice folder.

As the project progresses team members, which are not necessarily CRM users, follow the project milestones and how the associated invoices are paid by clients. If the company has many clients and each has many projects, and each project has invoices, and their payment needs to be followed up, imagine the effort required collecting details from the project SOW and invoices documents, without having metadata to allow search and views built on logical and easy way to retrieve them.

What is your experience with CRM and SharePoint?

We find this topic so important for better CRM and SharePoint integration, that we have also created LinkedIn Group (join by following the URL below) for all readers to share with all of us, your knowledge, experience and earned best practices on how to improve using SharePoint and CRM in harmony.

Join LinkedIn Group: http://www.linkedin.com/groups/6617819

www.DynamicsObjects.com

Follow us on Twitter: 

CRM and Sharepoint 560 CRM is from Mars, SharePoint is from Venus

Let’s block ads! (Why?)

CRM Software Blog | Dynamics 365

from, SharePoint, Venus, “Mars
  • Recent Posts

    • Accelerate Your Data Strategies and Investments to Stay Competitive in the Banking Sector
    • SQL Server Security – Fixed server and database roles
    • Teradata Named a Leader in Cloud Data Warehouse Evaluation by Independent Research Firm
    • Derivative of a norm
    • TODAY’S OPEN THREAD
  • Categories

  • Archives

    • April 2021
    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited