Sunday, 25 January 2015

File Connect In Salesforce -Integrating Office 365 Sharepoint within chatter Files

I remember couple of years back when I had to integrate Sharepoint with Salesforce ,only option I could think of is to visit appexchange and pay some bugs to get this up and running.There was a free app "Chatter For Sharepoint".Configuring this was again scanning through lot of documents .

File Connect lets you connect Microsoft SharePoint 2010, SharePoint 2013 or SharePoint Online account, and everything is indexed and made searchable within your Salesforce environment.File connect is not just about sharepoint and in general its about sharing salesforce files outside salesforce organization.

In this blogpost I will walk through simple steps to connect Microsoft 365 Sharepoint to Salesforce Files and bring Files located in sharepoint to SFDC.
It won't be too detailed as salesforce documentation around this is awesome but will add necessary Screenshot to help folks who want to set quick demo for clients to showcase.

Step 1-Sign Up for a trial account from microsoft for online sharepoint .Office 365 trial edition will work well .

Step 2-Select a sample site for sharepoint and try accessing this site .Note URL as this URL we will be using lot throughout configuration.

Also note microsoft domain as this will be used as well for further configuration.The below shows how your admin console look and you can navigate and select and activate a sharepoint site .

















Step 3-Enabling file connect in Salesforce .




Choose Reference if you want only view else prefer copy option

Step 4-Creating permission set for Microsoft access 365 online

Assign this to Users

https://help.salesforce.com/HTViewHelpDoc?id=admin_files_connect_perm.htm&language=en_US






Step 5-Create an Authentication Provider for SharePoint Online or OneDrive for Business

This is well documented in below article from salesforce.

https://help.salesforce.com/HTViewHelpDoc?id=admin_files_connect_sp_online_auth.htm&language=en_US

I am attaching screenshot from both sharepoint and salesforce end on how this should look





The sharepoint App configured final screen should resemble something like below
Step 6-Creating external data source 


On successful authentication click validate and sync button .


Step 7-Associate External data source with Permission set

Debugging tips

1)If oauth is failing double check auth provider configuration and domains entered in sharepoint settings .

2)If permission issues check permission sets and users are assigned .Also chatter for sharepoint is enabled for user or at profile level user is assigned valid permission.

Our final finished integration will look as below

Great thing is global search will search from sharepoint as well as chatter files

Hope you enjoyed and Let me know if anyone is encountering any issue in getting this to work .


20 comments:

  1. Replies
    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai

      Delete
  2. Nice Blog, Thanks to share an amazing information with us, It helps me alot salesforce customer portal

    ReplyDelete
  3. swiss replica watches sale, combining elegant style and cutting-edge technology, a variety of styles of swiss replica omega watches sale, the pointer walks between your exclusive taste style.

    ReplyDelete
  4. Great blog. All posts have something to learn. Your work is very good and I appreciate you and hopping for some more informative posts. Cryptocurrency Services

    ReplyDelete

  5. You write this post very carefully I think, which is easily understandable to me. Not only this, but another post is also good. As a newbie, this info is really helpful for me. Thanks to you.
    Tally ERP 9 Training
    tally classes
    Tally Training institute in Chennai
    Tally course in Chennai

    ReplyDelete
  6. Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
    Digital Marketing Course In Kolkata
    Web Design Course In Kolkata

    ReplyDelete
  7. Hi
    I visited your blog you have shared amazing information, i really like the information provided by you, You have done a great work. I hope you will share some more information regarding full movies online. I appreciate your work.
    Thanks
    Top SharePoint Courses Online

    ReplyDelete
  8. Techforce services is a Salesforce Consulting Services in Australia Specializing in delivering end to end Salesforce solutions ,Consulting, Implementation DevOps partners in Australia We deliver applications and services more rapidly and reliably, but it’s more than a methodology – it cuts to the very core. Salesforce Data Analytics let us help you become a data driven organization and ensure your data is working hard for your business, This includes implemention
    Salesforce consulting companies
    Salesforce top partners
    Staff augmentation companies
    Salesforce DevOps services
    Salesforce integration companies
    Salesforce Implementation services
    Salesforce Health Check
    Salesforce DevOps
    Managed project services

    ReplyDelete

Introducing Lightning Base Components

Lightning Base Components are great addition to the platform and in fact revolutionary .One of the concerns around lightning component ...