DBSync's Microsoft Dynamics NAV connector allows you to integrate your front and back-office applications to streamline and automate your business processes and ensure that your MS Dynamics NAV data is accurate, timely, and functional. As a Nav user, you can use this connector to integrate MS NAV with another On-demand, On-premise or SaaS-based application such as MSCRM, Salesforce, SkuVault and various other databases.
DBSync MS NAV connector allows you to move data into and out of the Microsoft Dynamics NAV application. This connector connects directly to your MS Dynamics NAV instance and enables you to query, add, modify various types of records including quotes, sales orders, blanket sales orders, return orders, Invoices, credit memos, Items and much more.
To establish a connection to Dynamics NAV via DBSync NAV connector, the user has to do the following:
- Have a valid license to DBSync NAV connector, username and password to connect to DBSync iPaaS platform.
- Access to Dynamics Nav with valid username and password
The DBSyncs MS NAV connector instance represents a single NAV account, including login credentials. If a user wishes to connect to multiple instances of the either sandbox/production, create a separate connection for each. The below table represent parameters required for opening the connection to NAV user instance.
The username of the MS NAV instance which has to be connected with.
|Password||The password for the user of MS NAV instance which has to be connected with.||yes|
Base URL is the web service URL that is generated from the NAV application in the following manner.
Administration→IT Adminstrations→General→ Lists→ Web service
SOAP URL format "http://WIN-73D0K4TTRC2:7047/DynamicsNAV80/WS/CRONUS%20New%20Zealand%20Ltd./Page/"
Copy the SOAP URL and paste in the Base URL field of the connector page
After a connector is created within a project, set up the connector within the project. DBSync can map to and from the systems which are supported by our standard connector list and use NAV connector to retrieve data from or send data to NAV Platform.
Click on the following link to know which all connectors we support Connectors List
Additional Set Up
Microsoft NAV Setup
DBSync uses Java to connect to MS NAV. MS NAV needs to be setup for authentication with the java application. For this please enable as follows:
1. Find C:\Program Files\Microsoft Dynamics NAV\60\Service\CustomSettings.config
2. Find the setting for "WebServicesUseNTLMAuthentication" and set it to "true"
3. Restart MS NAV
You can find more information at https://msdn.microsoft.com/en-us/library/dd355055.aspx
Microsoft Dynamics NAV connector can be used to:
- Synchronize customer master databases with Microsoft Dynamics NAV
- Convert closed won opportunities to Invoice/sales orders MS Dynamics NAV
- Integrate e-commerce website orders to MS Dynamics NAV
- Integrate payments received from online payment systems for reconciliation
DBSync's MS NAV connector supports only the following versions of NAV.
- Microsoft Dynamics NAV 2016
- Microsoft Dynamics NAV 2015
- Microsoft Dynamics NAV 2014
- Microsoft Dynamics NAV 2013
Q: How does DBSync connect to MS NAV?
A: DBSync connects to MS NAV through Web Services. Services (and Pages or routines) should be exposed for other applications to consume it.
Q: What are the pre-requisites for DBSync integration to work with MS NAV?
A: SOAP Web service of MS Dynamics NAV should be enabled
Q: Is this connector available with on-demand and on-premise versions of DBSync?
A: yes, This connector has the support for both the versions of DBSync
Q: Does DBSync need to be installed on the same machine as that of MS NAV?
A: DBSync MS NAV adapter can be either configured on the same machine where MS Dynamics NAV is installed or on a remote machine which can access MS Dynamics NAV.
Q: What is DBSync SDK?
A: DBSync SDK allows you to write your own custom adapters and extensions. It can be deployed to your DBSync Integration Engine with processes you need to setup.
Q: Why do we need this additional coding?
A: Many times Web Services exposed cannot be imported or ETL tools cannot interpret the metadata. This causes many other ETL tools to fail. With our Java Adapter extensions, we can handle many of these cases very efficiently.
The below links can be used to access the relevant information related to Microsoft Dynamics NAV.