Pariveda is a Microsoft National System Integrator which in addition to CRM, provides services across the Microsoft application stack including custom .NET development, business intelligence and data warehousing, and document management and collaboration leveraging SharePoint. Our Microsoft centric clients often ask whether SharePoint or CRM should be leveraged and for what business need. These two platforms definitely have some overlap, however I think about these two applications based on their strengths and weaknesses.
SharePoint is a strong web portal and document management platform. It is excellent at providing a site structure for internet, extranet, intranet sites as well as smaller team collaboration sites. Users can easily manage documents and web content across sites. SharePoint plays particularly well with Office 2007 and above allowing users to easily save Word, Excel, PowerPoint, and other Microsoft documents into SharePoint sites. SharePoint has built in workflow which can provide document/content routing and approval.
SharePoint is not a relational database, nor was it designed to be used as one. However, many organizations early in their SharePoint maturity try to develop complex applications in the environment only to rip them out later.
CRM is an excellent relational database and was built to allow users to quickly model their own hierarchical entity relationships within the system without writing code. CRM is built to easily integrate with other relational database systems with a full web services toolkit. Microsoft CRM can also be extended as a development platform to meet business needs other than the traditional sales, marketing, service functionality. In addition, CRM has robust reporting leveraging SQL Server Reporting Services, user configurable Dashboards, and the Advanced Find query builder which exports to Excel Dynamic Pivot Tables and Workbooks.
CRM is not a strong document management platform. CRM stores documents as an attachment to a ‘Notes’ entity. There is no version control, check-in/check-out, archiving, or workflow capability around documents within CRM.
The marriage of CRM 2011 and SharePoint 2010 allows each of these tools to play to their strengths in managing relational customer information and related documents all in one interface for the end user.
Labels: CRM 2011, Microsoft, Microsoft CRM, Office, Pariveda, SharePoint, SharePoint 2010