Importing CRM 2011 Connections

26 November 2012

To import/synchronise connection data in Dynamics CRM 2011 with Data Synchronisation Studio you need to define your schema map like this below.

Schema

record1idobjecttypecode and record2idobjecttypecode should return the names of the related entities for example.

Preview

CRM will automatically create the reverse connection which is a problem for Data Sync as it will see an extra record on the next sync. Therefore we filter this out by using an FetchXmlFilterExpression and just select the rows where ismaster is true as below.

Properties

<filter type="and">
<condition attribute="ismaster" operator="eq" value="true" >
</filter>

| |