CRM 2011 Import Custom Entities and Related Data

In this example were showing how you can Import/Synchronise data from a SQL Server Database into an instance of CRM 2011 with custom entitles and Data Synchronisation Studio.

We're going to import Sales Order History from the Adventure Works database and relate each Order History line to an Account in the CRM system.

Using the Query below we can pull out the Sales Order Header Lines and in this example we are going to relate the Contact ID back to the Account in CRM (previously we imported the Contacts into the Account Entity using the rowguid as the accountid in the CRM system)

This is the typical result we get from the Query

Next we create a new Entity in CRM with 2 custom fields, Amount and Account:

Amount Field

Account Field

We can then simply map the Data in Data Sync between the Source SQL Query and CRM entity like this.

Schema Map

Compare and Sync the Data

Once the Data is imported you can then create a view to view the list of Sales or records.

Sales order item showing Account Relationship connected.