What’s in This Post?
In this post we shall see examples of different kinds of integrations between Microsoft and Salesforce:
1. Salesforce Connect based integration: Use Lightning Connect (aka Salesforce Connect) to connect Salesforce with MS NAV, .NET apps & with MS SQL Server database
2. API based integration: Use Salesforce pre-built toolkit for Visual Studio to Connect to Salesforce from .NET
3. UI integration: Use Canvas toolkit to embed .NET apps in Salesforce
4. Integrate using AppExchange Connector: Connecting Legacy .NET to Salesforce
5. Using Microsoft Power BI for Office 365 to Gain Insights from Salesforce Data
6. Microsoft Dreamforce Videos
7. Examples of Salesforce Integration with Office 365 – Sharepoint, Outlook, Exchange, Excel, Word
8. Strategic relationship between Salesforce & Microsoft – what it means for customers – Videos and links.
Salesforce Connect based integration: Use Lightning Connect (aka Salesforce Connect) to connect Salesforce with MS NAV, .NET apps & with MS SQL Server database
API based integration: Use pre-built toolkit for Visual Studio to Connect to Salesforce from .NET
A new version of the above toolkit is known as Salesforce Connected Services for .NET: https://developer.salesforce.com/blogs/developer-relations/2014/11/nothing-net-connected-service.html
UI integration: Use Canvas toolkit to embed .NET apps in Salesforce
Integrate using AppExchange Connector: Connecting Legacy .NET to Salesforce
Additional Resources on Salesforce Microsoft Integration
Batch integration with on-premise MS SQL Server database: http://www.forceamp.com/
Quickly Connect to Force.com from Visual Studio the new Connected Service Provider (This is an enhancement to the Salesforce .NET toolkit) : https://developer.salesforce.com/blogs/developer-relations/2014/11/nothing-net-connected-service.html
Call the on-premise database from Salesforce: Here is an example how you can expose On-Premise data as API using SOAPBox: https://developer.salesforce.com/page/Integrate_Salesforce.com_With_Your_On-premise_Database
Salesforce – Microsoft Office 365 Integration
Using Microsoft Power BI for Office 365 to Gain Insights from Salesforce Data – https://www.youtube.com/watch?v=embuucevDPE
Integrate with Microsoft Outlook (including Office 365)
- Salesforce App for Outlook Blog Post for Launch (May 2015): https://www.salesforce.com/blog/2015/03/announcing-availability-salesforce-app-outlook.html
- Which Outlook Plugin to Choose: https://developer.salesforce.com/trailhead/microsoft_integration_admin/microsoft_integration_admin_why_integrate/microsoft_integration_admin_why_integrate_unit_2
- Salesforce App for Outlook – Setup: http://salesforce.vidyard.com/watch/ZKd4kPVThHvFdOaF7fH_ug
- Salesforce App for Outlook Demo: http://salesforce.vidyard.com/watch/6eDfR-pA2hPhRxLupDxgwQ
Integrate Salesforce with MS Exchange (Exchange Online)
- How To Video to setup Exchange Sync for Office 365 (7 mins): http://salesforce.vidyard.com/watch/J2eLUC8avByiPXSu1Lkq6A
- Exchange Sync (Beta) Syncs Your Microsoft® Items from the Cloud: https://help.salesforce.com/apex/HTViewHelpDoc?id=productivity_sync_exchange_overview.htm&language=en_US
- Exchange Sync Implementation Guide: https://resources.docs.salesforce.com/198/latest/en-us/sfdc/pdf/salesforce_exchange_sync_admin_implementation_guide.pdf
- Define Sync Settings for Sales Reps Using Exchange Sync: https://help.salesforce.com/apex/HTViewHelpDoc?id=exchange_sync_admin_configurations.htm
- Assign Users to Exchange Sync Configurations: https://help.salesforce.com/apex/HTViewHelpDoc?id=exchange_sync_admin_config_assign.htm&language=th
- Exchange Sync Status: https://help.salesforce.com/apex/HTViewHelpDoc?id=exchange_sync_admin_status_msg.htm&language=en_US
SSO from Salesforce to MS Office 365
- Step by Step Guide to Single Sign On between Salesforce & MS Office 365: https://developer.salesforce.com/page/Configuring-SAML-SSO-to-Office365
Integrate MS Office Docs (Office 365 & On-premise) with Salesforce:
- Files Connect integrates SharePoint 2010, SharePoint 2013, Office 365 (SharePoint Online, OneDrive for Business), Google Drive and Box with Salesforce: https://www.youtube.com/watch?v=aG3m3zP00KQ
- Files Connect Setup Process: http://help.salesforce.com/apex/HTViewHelpDoc?id=admin_files_connect_overview.htm&language=en_US
Integrate MS Word and Salesforce for Mail Merge
- Using Conga Composer with MS Word and Salesforce for mail merge: https://www.youtube.com/watch?v=ZdhhkOmOa0c
Summary
Salesforce & Microsoft have a strategic partnership agreement with a focus on close integration with each other’s products. The following links provide more information about the Salesforce – Microsoft partnership and roadmap.
-
Salesforce & Microsoft Integrations http://www.salesforce.com/campaigns/microsoft/
-
Dreamforce Innovation Sponsor: Microsoft – https://www.youtube.com/watch?v=tm40037m2tg
-
Microsoft Dreamforce Videos – https://www.youtube.com/user/dreamforce/search?query=microsoft