Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

HCLTech Microsoft Business Applications Practice Blog

for Dynamics 365, Power Platform and the rest of the Microsoft technology stack

Generating Maps for Dynamic CRM Instance Adapter Integration

Post Author: HCLTech |

Generating a Map

After configuring the CRM Instance Adapter and an integration has been created, you can now generate Maps to define the transfer of data in the integration. Begin by selecting the integration you wish to add a map to by selecting it in the Connector and click the New Map button. A new dialog will appear that allows you to select an entity from both the source and destination organizations. After selecting the entities, click Create:

Before the newly created Map will work, we must configure how we want to map the entity’s fields.  To edit a field mapping, click on the edit icon next to the field.   There are three options to choose from:

  • Map from a Source field – User can choose which source field
  • Map Using a Constant – User can type in the constant
  • Map using a Function – For example, a function could be used to populate the field with today’s date

There is one more option that makes it easy to use for bulk migration of the data. Instead of mapping individual fields, users can map all fields by using a back slash in the top level field.  Doing so will then map all the fields from the source fields.  This can also be accomplished by clicking the Edit button, selecting “Map to a source field” and then choosing the root element of the source field as well.

Once the fields are mapped, the Map Run Schedule must be set before activating.  Select the map that you just created under the Maps root element in your integration. The page you’re presented with on the right side of the Connector screen should look like the following:

Modify the “Check for Changes” Edit hyperlink.  Select the start time, and how often you want the adapter to check for changes.  The recurrence patterns include options for “Once”, “Recurring”, “Weekly” and “Continuously”.  Note that all integrations will make re-attempts at any failed entities.

After setting the “Check for Changes” value, we may also need to set what modified date the Adapter should check for.  Clicking the second Edit link will allow you to pull records that have been modified since the date chosen.  In most cases, the default value for this setting is several hundred years in the past.

Now that the scheduling of the map has been configured and the mapping rules have been put in place, we must click Activate button in order for it to be enable to run.  We must then click the Save button to save all the changes made to the mapping.  The next time the Connector starts, this mapping will be active and start pushing records across to the destination Dynamics CRM.  Repeat this process for each entity you want to integrate.  Before starting the Connector, make sure to check out our blog about Initial Integrations which contains useful information about both the order in which you integrate entities and also some special entities you’ll need to handle.

By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

4 comments on “Generating Maps for Dynamic CRM Instance Adapter Integration”

  1. Hi Joe, I have a problem with mapping data from my source query to my test CRM. The description fields appear null on the test crm

    1. Hi - one potential cuase for this is if the field sizes are different. We have seen cases were the adapter will NOT truncate, but will simply not move over the data....such as source 200 char and destination 100

  2. I am trying to integrate Order to Sales Order using a connector.I need the mapping for the Sales Line OrdersSales Line OrderNo field of Nav.When i submit the order along with the Line item i can view the Record in Nav but the Line Item can not be seen.But when i hard code the Product Id in the No. field then it works well.Please help .

PowerObjects Recommends