Skip to main content

Microsoft Dynamics Integration Guide

Connect Grata with your CRM

Written by Brendan Mahoney

Establish the Connection

  1. Go to the Account page

  2. Scroll down to Integrations and select Dynamics 365

  3. Enter your username and password.

    1. This user must be an admin in Microsoft.


Company Mapping

Company Mapping is where you decide which Dynamics fields are populated during a sync from Grata.

(*) asterisks mark required fields.


All mappings besides Name & Company Domain are optional. If you choose not to map to a corresponding Dynamics field, Grata won't ever send data to that field.​


Replace Toggles

Replace ON (blue)

  • Grata will override that field, including any companies in Dynamics that already have data in that field.

  • Grata will populate blanks in that field.

Replace OFF (gray)

  • Grata will not update the value for matching companies in Dynamics— regardless of whether the field is blank, or already has data in it.

  • Grata will not populate data for blanks.

  • Grata will populate the field only while it is creating a new company in Dynamics.

Static Mappings

This setting makes it so that Dynamics is populated with a fixed, predefined value for a field, each time that a company is synced — regardless of the data on that profile.

For example, set Company Type equal to "M&A Target" — so that, once in Dynamics, each newly added target goes in as the correct type of M&A Target.

Additional Guides for Dynamics Custom Fields


Contact Mapping

Contact Mapping is the step where you decide which Dynamics contact data gets populated any time Companies & Contacts are synced.

(*) asterisks mark required fields:

Job Title Filtering

There is an optional step to filter Job Titles for contacts. By selecting specific titles, you can filter out unwanted contacts from flowing into Dynamics 365.


Syncing to Leads

As an alternative to Accounts & Contacts, you can have Grata sync to Leads in Dynamics. Change the Records to Sync dropdown in Step 1.

Grata will push both the firmographic information and contact information for that company onto a single record — a Lead — in one clean sync.

Is CRM Intel supported for Leads?

Yes, the CRM Intel feature is also supported for Leads!



Pull info from my CRM into Grata

Before you setting the fields you would like Grata to populate when syncing, select your CRM preferences.

Pull info from my CRM is the feature that allows Grata to check for matches in your Dynamics. This feature is the driver behind filters such as Show my companies, where you can filter down Grata profiles to ones that match your CRM.


Can I turn this off?

Yes, you can turn off Pull info from my CRM; this makes Grata a one-way integration. However, it is recommended to leave this feature on, as Grata will be "blind" to your CRM, which means it cannot index company matches— thus slowing down syncs.

How often does Grata check for matches?


Grata refreshes weekly. If you have access to the Auto-Update feature, you can set this to run daily, or monthly.


Auto-Update Companies & Contacts in my CRM

This feature runs automatic data enrichment. When it comes to deciding which Dynamics data gets overwritten, Grata follows the Company Mapping you saved.

Enrich All Companies

Grata enriches all Dynamics records it finds a match with. This also includes companies added to Dynamics from sources outside of Grata. Note: this option will consume more credits.

Only Update Synced Companies

Grata enriches only companies you have synced from Grata before.

How often does Grata enrich data?

By default, Grata enriches Dynamics weekly. If you have access to Auto-Update, you can change the Auto-Update Frequency by clicking on the blue calendar icon.

How do I prevent my data being overwritten?

Data is controlled at the field-by-field level; only fields where the Replace toggle is ON will be overwritten (see: Company Mapping). This means Grata can overwrite Employee Headcount in Dynamics, while never touching your Priority field, for example.


CRM Intel

CRM Intel is the feature allowing you to display Dynamics-specific data on your views in Grata.

CRM Intel fields are accessible in multiple areas of the Grata platform: Company Search, Conference Pages, Buyer Search, Banker Search, and more. They are a direct reflection of your Dynamics fields, and they are read-only.

Grata checks for updates in Dynamics on a scheduled basis. If a Grata profile is displaying outdated information from Dynamics, click Sync to have it refresh.


Note: once CRM Intel is enabled, all your Grata seats can view the Dynamics fields.


FAQ

Does Grata share my Dynamics data?

No. The connection is a secure data pipeline between your Grata instance and CRM— existing solely to benefit your search experience. Grata has its own proprietary data, and will not use your CRM data for any other purpose in the platform.

Read more about our data policy on the Integrations and Data Privacy FAQ.


​How does Grata prevent duplicates?

Grata knows to avoid creating duplicate companies. Before syncing, Grata will check for a matching Website. Grata recognizes a match regardless of whether the company is spelled amazon.com or http://www.amazon.com in your CRM.

Grata knows to avoid creating duplicate contacts, as well. It will check for First Name + Last Name of the person. It then checks for a match to the person's email.

How do credits work?

Each Grata profile equals 1 credit. The amount of Dynamics fields— or the amount of contacts Grata has for that company— do not factor into the credit calculation.

Once a company has been synced to Dynamics— after the first time— any sync thereafter of that company uses zero credits. The same company can be exported to Excel without costing additional credits.

How do I disconnect?

If you need to disconnect Grata from Dynamics, you can do so from the Account page. Click the three dots under the Dynamics 365 tile, then choose Disconnect Dynamics from Grata. Stored credentials are immediately wiped.

I ran into an error while syncing. What should I do?

If you need assistance with your CRM integration, reach out to Grata Support (support@grata.com) or chat with us in the Help section > Messages.

Where can I see my syncing history & credit usage?

To see logs on how many companies were synced, how many credits were used, and by whom, go to Accounts > Audit Log. For detailed information, such as how many contacts were synced, reach out to Grata Support.

Did this answer your question?