Microsoft Dynamics CRM Connector for NAV- Step by Step Guide to Installation & Configuration

Trapti Nagar - Click for blog homepageThis blog post gives step by step procedures to integrate Dynamics CRM 2011/CRM online with NAV 2013.

Note: Download the connector setup and installation guide from links mentioned in the last section.

Prerequisites

Microsoft Dynamics CRM

Create two Windows Live ID accounts for CRM online or two user accounts for Dynamics CRM on premise for following types of users:

  • Admin User
  • Integration User (assign System Customizer role after creating a user in short)

Setup Dynamics NAV to enable Data Synchronization

  • To turn on integration and enable synchronization, run through following steps:
  • Start Microsoft Dynamics NAV and in the search box, enter Marketing Setup.
  • Open the Marketing Setup window.
  • On the Synchronization FastTab, select the Enable Connector check box. Click Yes to confirm.
  • Exit and start Microsoft Dynamics NAV again before you configure Connector for Microsoft Dynamics.
  • After you enable Connector for Microsoft Dynamics, verify that the following services are started:
    • Microsoft Dynamics NAV Business Web Services
    • Microsoft Dynamics NAV Server

Installation and configuration

Run the setup, click next.

image

Give the name of your Dynamics NAV SQL server

image

Provide administrator account credentials for NAV/System

image

Click to install.

image

It will start to install dynamics connector.

image

image

You will reach finish screen, if everything goes fine.

image

You need to install the ConnectorForMicrosoftDynamicsNav solution in your CRM organization to enable CRM instance to support NAV data integration. Follow the steps mentioned below:

1. Log on to an organization in Microsoft Dynamics CRM as an administrator.

2. In the navigation pane, go to Settings > Customization > Solutions. Click Import.

3. Browse to the Connector installation directory (\Program Files\Microsoft Dynamics\Microsoft Dynamics Adapter).

4. Select the ConnectorForMicrosoftDynamicsNav.zip solution file. Click Open.

5. Click Next. When the Solution Information is displayed, a message might be displayed that warns of a version mismatch. Click Next.

6. Select Activate any processes and enable any SDK message processing steps included in the solution.

Note: If you do not select this check box, the steps to install the plug-in will not be activated and the process cannot be completed.

7. Click Next.

8. When the solution customizations have been successfully imported, click Close to exit.

image

image

After importing the solution, follow the steps below to give adapter settings:

1. Start-> connector for Microsoft dynamics

2. Run the connector

3. Click on adapter settings on top menu

4. Give the following information in Dynamics CRM 2011 for online, else give the setting in Dynamics CRM

Note that the user given here integration user we have already created.

image

Click on test settings, after you see a success message click on link to configuration utility.

You will see a screen like this.

image

The configuration settings will take the URL automatically, just give username (here use administrator credentials) and password and click on Get organizations. You should be able to get the organization name in the highlighted area in which you want to implement the integration as shown in the screenshot.

image

Finish the CRM configuration utility wizard and click on Microsoft Dynamics NAV in the adapter settings as shown below.

Credentials to be used are mentioned here:

Domain: Enter your Windows domain.

User Name: Enter your Windows user name or alias.

Password: Enter your domain password.

URL:

(Note: In some cases we might face errors in connecting the NAV and it fails, try giving server IP address in place of localhost in the URL as shown in screenshot below)

image

This is the success message screen

image

Click on test settings, after you see a success message click on link to configuration utility.

Give the credentials and select the Dynamics NAV Organization.

Select the entities you want to enable for integration.

image

image

After the process is finished click in create new integration. Give the details as given in the below screenshot.

image

Now you can start creating new maps.

image

image

Make sure that you create necessary maps first. Have a look at the installation guide for more information.

image

After the Connector for Microsoft Dynamics is installed and the adapters are configured, data needs to be synchronized between Microsoft Dynamics CRM and Microsoft Dynamics NAV before you can run integrations on a regular schedule.

Verify that the customizations have been deployed as outlined in the Basic installation section, to check this create one entity record and see if you are able to see the submit button on the ribbon as highlighted in the screenshot below.

image

The Connector for Microsoft Dynamics is designed to integrate data between Microsoft Dynamics NAV and Microsoft Dynamics CRM in the following scenarios:

  • New Microsoft Dynamics NAV and Microsoft Dynamics CRM application installations
  • Existing Microsoft Dynamics NAV installation and new Microsoft Dynamics CRM installation or Existing Microsoft Dynamics CRM installation and new Microsoft Dynamics NAV installation
  • Both Microsoft Dynamics NAV and Microsoft Dynamics CRM existing installations

Data could exist in one or both applications. You must synchronize this data prior to running the integration on a regular schedule.

Now you are done with the integration, schedule the Data synchronization process and validate the data.

Quick Links

Here are some useful links to quickly access resources:

msdn.microsoft.com/en-us/library/gg502460.aspx

msdn.microsoft.com/en-us/library/gg481835.aspx

blogs.msdn.com/b/dynamicsconnector/

www.microsoft.com/en-in/download/details.aspx?id=10381

https://mbs.microsoft.com/partnersource/deployment/resources/productreleases/MDNAV2009R2_CRMConnector.htm