Microsoft Dynamics CRM Connector for NAV- Step by Step Guide to Installation & Configuration
This 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.
Give the name of your Dynamics NAV SQL server
Provide administrator account credentials for NAV/System
Click to install.
It will start to install dynamics connector.
You will reach finish screen, if everything goes fine.
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.
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.
Click on test settings, after you see a success message click on link to configuration utility.
You will see a screen like this.
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.
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.
(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)
This is the success message screen
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.
After the process is finished click in create new integration. Give the details as given in the below screenshot.
Now you can start creating new maps.
Make sure that you create necessary maps first. Have a look at the installation guide for more information.
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.
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
Comments
- Anonymous
October 22, 2013
Good article Trapti! - Anonymous
October 22, 2013
Good One!! - Anonymous
October 22, 2013
Good one Trapti.. very helpful! - Anonymous
October 23, 2013
nicely drafted!! - Anonymous
October 29, 2013
Good one again Trapti , Keep them coming :) AX - CRM Connector info would be tremendously helpful too! :) - Anonymous
December 08, 2013
Hi Trapti, just followed your step by step, but my integration is not working well... hope you could help me out. - Anonymous
December 09, 2013
good in-detail article Trapti... but my integration is only working one way for all entities (NAV - CRM)... need some help !! - Anonymous
January 02, 2014
Vinay - If you are a partner, raise an advisory request to askpts@microsoft.com and we will be able to assist you on this question. - Anonymous
May 04, 2014
Great Article.
Just followed It step by step and got the integration working.
thanks Trapti. (Y) - Anonymous
August 01, 2014
Mahesh - Glad the article helped you. - Anonymous
August 20, 2014
Thanks a lot Trapti.
It helped me a lot for my Integration Project... - Anonymous
December 23, 2014
Thanks for this Trapti.
Do you have documentation on what functionality is provided by the integration e.g can CRM users view NAV order status? - Anonymous
January 05, 2015
The comment has been removed - Anonymous
January 08, 2015
Thanks, Can you assist how to map Navision (Item Card) Fields with CRM Product Fields - Anonymous
July 12, 2015
Microsoft Dynamics CRM Connector for NAV- Step by Step Guide to Installation & Configuration