Marketing Integrations

SJoshi71
Contributor

MSD 365 Integration

SOLVE

Hi,

I had a query regarding HubSpot & MSD 365 integration. I wanted to know if HS<>MSD365 integration syncs opportunity data. I did look through the product doc on this. But it points to only the following:

 

Select the object you want to sync between HubSpot and Microsoft Dynamics 365. You can sync Accounts, Contacts or Leads from Microsoft Dynamics 365.

  • Account: a Microsoft Dynamics 365 account stores data about companies you do business with. 
  • Contact: a Microsoft Dynamics 365 contact is someone you currently do business with or have done business with in the past.
  • Lead: a Microsoft Dynamics 365 lead is a business prospect that you have not yet qualified through your sales process.

There's no mention of opportunity and deal sync. Has anyone else previously integrated these two platforms? And were they able to sync MSD 365 opps info in Hubspot?

 

Regards,
Sai

0 Upvotes
1 Accepted solution
coldrickjack
Solution
Guide

MSD 365 Integration

SOLVE

Hi Sai, 

 

One limitation that I've found with Operations Hub is the inability to create a two way sync between dropdown fields in the respective system. One solution I've used in the past was to create a single line text field in HubSpot which I could then map the data to from Dynamics (see below):

 

Screenshot 2022-08-24 at 13.45.55.png

 

However, one issue with this is the data can't sync back if it changes, it's one way from Dynamics to HubSpot.. So you'd need to create a single line text field in dynamics and create automation to update the actual dropdown properties. It's not ideal and by no means a perfect solution but it works.  See below:

 

Screenshot 2022-08-24 at 13.50.10.png

View solution in original post

10 Replies 10
A_ERPBridge
Contributor | Platinum Partner
Contributor | Platinum Partner

MSD 365 Integration

SOLVE

Also, check ERP Bridge, we have tons of experience regarding HubSpot & MSD 365 integration, one way and two way, for all of the custom objects:

- Contacts,
- Companies,
- Tickets,
- Deals,
- Products,
- Line items,
- Quotes and any unlimited Custom objects.

0 Upvotes
IFarafonov
Member

MSD 365 Integration

SOLVE

Hi,

Right now, HubSpot and Microsoft Dynamics 365 don’t automatically sync Opportunity or Deal data with each other. Our integration specialist research https://www.hiredynamicsdevelopers.com/dynamics-365-integration-services/ shows that the usual sync options mainly focus on Accounts, Contacts, and Leads.

A lot of businesses want to sync Opportunities and Deals. This helps them manage their sales pipeline better. As you’ve seen, the docs only mention syncing Accounts, Contacts, and Leads. Unfortunately, Opportunities or Deals are not part of the automatic sync.

If you want to sync Opportunities and Deals between Dynamics 365 and HubSpot, there are a couple of options. You can use HubSpot’s Operations Hub. It has custom sync features that let you map and sync Opportunity or Deal fields to custom properties. This won’t create a smooth two-way sync, but it lets you control how Opportunity data moves from Dynamics 365 to HubSpot with custom mappings.

0 Upvotes
A_ERPBridge
Contributor | Platinum Partner
Contributor | Platinum Partner

MSD 365 Integration

SOLVE

I'm glad that you guys have all find out a way to make it work.

In case your Dynamics is on-premises. we have developed ERP Bridge, a top 30 connector on HubSpot's marketplace: https://ecosystem.hubspot.com/marketplace/apps/productivity/connector/erp-to-hubspot-by-dma-srl-2866...

We can sync:

- Customers
- Companies
- Deals
- Tickets

- Quotes
- Line items/products
- Custom objects
- Custom properties

If you guys want to know more, just drop me a line.

Best,
Alessandro
firma-hubspot-forum.png

rtjeenkwillink
Participant

MSD 365 Integration

SOLVE

Hi Alessandro, 

 

does your solution work for MD 365 Business Central (on prem) as well?

0 Upvotes
A_ERPBridge
Contributor | Platinum Partner
Contributor | Platinum Partner

MSD 365 Integration

SOLVE

Of course, it does. We only work with on-prems. So Business Central on-prem is a great fit. Go to our website to schedule a demo or a virtual tour.

 

 

0 Upvotes
coldrickjack
Guide

MSD 365 Integration

SOLVE

Hey @SJoshi71,

 

Yes, I've managed to get this working, I think HubSpot needs to update the documentation

 

If you are using the data sync connector (Operations Hub Free/Starter) you can sync opportunity data. If you are use the free version you can only sync default fields. If you are the starter version you can create custom mappings however be mindful of some of the limitations.

0 Upvotes
SJoshi71
Contributor

MSD 365 Integration

SOLVE

Hi @coldrickjack ,

Thanks for your reply. 

 

We will be using the data sync connector,  and it says in the app marketplace, it says that custom field mappings are compatible with the plan.

Were you able to sync lifecycle stage "opportunity" from MSD to HubSpot as well?

 

Regards,

Sai

0 Upvotes
coldrickjack
Solution
Guide

MSD 365 Integration

SOLVE

Hi Sai, 

 

One limitation that I've found with Operations Hub is the inability to create a two way sync between dropdown fields in the respective system. One solution I've used in the past was to create a single line text field in HubSpot which I could then map the data to from Dynamics (see below):

 

Screenshot 2022-08-24 at 13.45.55.png

 

However, one issue with this is the data can't sync back if it changes, it's one way from Dynamics to HubSpot.. So you'd need to create a single line text field in dynamics and create automation to update the actual dropdown properties. It's not ideal and by no means a perfect solution but it works.  See below:

 

Screenshot 2022-08-24 at 13.50.10.png

WinnieHien
HubSpot Product Team
HubSpot Product Team

MSD 365 Integration

SOLVE

Hi Jack and Sai,  Dropdown sync LITE is now live for Dynamics.  

 

See this Ideas Forum post for the update and FAQ doc. 

 

We are continuing to add objects to the Dynamics 365 integration, and those will appear in the Shared Data section. 

 

As of April 2023, here's the list. Expect more objects available for sync to come this year, such as Sales Activities and more! 

 

Object sync for Dynamics.gif

SJoshi71
Contributor

MSD 365 Integration

SOLVE

Hi Jack,

 

Thanks for your reply.  The workaround is going to be a bit of a hassle, but that would solve the problem. Thanks a ton for your help. 🙂

 

Regards,

Sai