CRM Online & SharePoint Online Integration

I was given an interesting task: integrate CRM Online with SharePoint Online (the native integration). Usually, it’s straight forward…

You have a few steps from a CRM/SharePoint perspective:

  • Download and install the CRM 2011 List Component for SharePoint (available for SP 2010 and 2013)
  • Configure SharePoint Sites in CRM (add your SharePoint site)
  • Configure CRM entities and add “Document Locations”

In fact, it’s so easy to setup that I think it’s crazy to have a document management system other than SharePoint if you want to integrate with Dynamics CRM… but that’s beside my point J.

Back on track, there are plenty of CRM/SharePoint environment setup scenarios (e.g. CRM Online & SharePoint On-Premise; CRM On-Premise & SP Online etc.). I am focusing on CRM Online and SharePoint Online.

In order for the integration to work smoothly, your SharePoint and CRM Online subscriptions should be part of the same Office 365 subscription. The reason for that is that authentication will be done through the same token(s). This makes sense, you log in once and have access to all Office 365 applications. In our case, the problem is Office 365 only recently added CRM Online and in our case, our instance hasn’t been migrated to our Office 365 subscription yet. How do we do integration then?

When some of the system users log on to CRM Online and try to view documents, this is what they get:

In order to make it work, all they need to do is connect to their Office 365 account in the same browser. Then they can simply refresh the Account form and navigate to the documents grid again. The Office 365 authentication token in the browser session will be used when the SharePoint document list in being displayed in the CRM frame.

Of course, in order to setup the integration, you need to be connected to Office 365 as well. The error above is something that end users will see and conclude that something is not working. It is important to find a way to let them know all they need to do is connect to Office 365. As for you CRM Admins, keep the faith and wait until your CRM Organizations get migrated to Office 365…

Cheers

Advertisements

One thought on “CRM Online & SharePoint Online Integration

  1. Thanks for the post Salim! I’d just like to add that whenever integrating Dynamics CRM with SharePoint, there are certain security risks. SharePoint doesn’t replicate the user access rights from Dynamics CRM. Therefore, unauthorized users can access Dynamics CRM documents in SharePoint. The only product to deal with the issue is CB Dynamics CRM – SharePoint Permissions Replicator. The solution copies the entire security model from Dynamics CRM to SharePoint. Learn more at: http://www.connecting-software.com/dynamics-crm-sharepoint-permissions-replicator/ cheers

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s