Cloud Workflow
Raise an IssueJoin Community
  • Getting Started
    • Introduction
    • Integration Basics
    • Sign Up and Get a License
    • Features and Benefits
  • DBSync Platform
    • Core Components
    • System Requirements
    • AppCenter
      • Company and User Management
    • Development Studio
    • Security Features
  • iPaaS
    • Home
    • Apps
    • Extend
      • Functions
    • Administration
      • User & Role Management
    • Logs
    • Remote Agent
    • Published Templates
  • Create your Workflow
    • Project
    • Task
    • Flow Builder
      • Standard Functions
    • Actions
      • Flow
      • Variable
      • Transform and Write
      • SQL
      • Restructure
      • Query
      • Debug
      • ReST
      • Conditions
        • If (Condition)
        • For (Loop)
      • Storage
        • Dropbox
        • File
        • CSV
        • Google Drive
        • FTP
        • S3
      • Flow Management
        • Flow
        • Logs
        • Notification
        • Schedule
        • API
        • Webhook
        • Forms
    • Configuring DBSync Environment
  • Connectors
    • Amazon S3
    • Authorize.NET
    • ChannelAdvisor
    • Database
    • Dropbox
    • FTP
    • Google Drive
    • Google Sheets
    • HubSpot
    • JIRA Cloud
    • JIRA Service Management
    • Linnworks
      • Creating the DBsync Application on Linnworks Developer Instance
    • Mailchimp
    • Microsoft Dynamics 365 Business Central
    • Microsoft Dynamics 365 Finance and Operations (D365 F&O)
    • Microsoft Dynamics CRM Online
    • Microsoft Dynamics GP
    • Microsoft Dynamics NAV
    • monday.com
    • Narvar
    • NetSuite
      • NetSuite Connector Settings
    • OpenAPI
    • PointClickCare
    • QuickBooks Desktop
    • QuickBooks Online
    • Sage Intacct
    • Salesforce
    • ShipStation
    • Shopify
    • SkuVault
    • WooCommerce
  • Template Library
    • Salesforce to QuickBooks Online Order to Cash
    • Salesforce to QuickBooks Desktop Order to Cash
    • Salesforce to FTP Integration
    • QuickBooks Online to Salesforce Accounts Receivable
    • QuickBooks Desktop to Salesforce Accounts Receivable
    • QuickBooks Online to Business Central Integration
    • QuickBooks Online to ShipStation Orders
    • QuickBooks Desktop to Shipstation Orders
    • QuickBooks Desktop to monday.com Integration
    • QuickBooks Online to monday.com Integration
    • Shopify to QuickBooks Online
    • Shopify to QuickBooks Desktop
    • Linnworks Orders to QuickBooks Online
    • Linnworks Orders to QuickBooks Desktop
    • Linnworks to Salesforce Integration
    • Salesforce Litify and QuickBooks Online
    • Salesforce Litify and QuickBooks Desktop
    • HubSpot to QuickBooks Online Order to Cash
    • HubSpot to QuickBooks Desktop Order to Cash
    • SkuVault Orders to QuickBooks Desktop
    • SkuVault Orders to QuickBooks Online
    • SkuVault and Salesforce
    • ChannelAdvisor Orders and Salesforce
    • ChannelAdvisor and QuickBooks Online
    • ChannelAdvisor and QuickBooks Desktop
    • Shopify Orders to Dynamics365 CRM
    • Shopify Orders to Salesforce
    • ShipStation to Dynamics 365 CRM
    • ShipStation Orders to Salesforce
    • ShipStation to QuickBooks Online Orders
    • ShipStation to QuickBooks Desktop
    • Target Recruit to QuickBooks Online
    • Target Recruit to QuickBooks Desktop
    • QuickBooks Online to Database
    • QuickBooks Desktop to Database
  • Troubleshooting
    • Common Errors & Fixes
    • Adding Trusted IP Address in Salesforce
    • Installing QuickBooks Web Connector
    • QuickBooks to Salesforce Data Migration
    • Setting Password in QuickBooks Web Connector
    • Starting QuickBooks Web Connector
    • Update Salesforce Password & Security Token in DBSync
  • Additional Resources
    • Billing Information - Auto Renewal
  • Tutorials
    • Salesforce and QuickBooks
      • Account Hierarchy in Salesforce and QuickBooks
      • Account Owner Mapping
      • Resolving Email Fields Sync Issues in QuickBooks Online
      • Mulitple Price Levels in Salesforce QuickBooks Integration
      • Multicurrency in QuickBooks to Salesforce Integration
      • Multicurrency in Salesforce - QuickBooks Desktop Integration
      • Multicurrency in Salesforce QuickBooks Online Integration
      • Product Hierarchy in QuickBooks and Salesforce
      • QuickBooks Data Extraction Queries
      • QuickBooks File Backup and Recovery Process
      • QuickBoooks Reports to Salesforce Integration
      • Recurring Transactions to Accounting System
      • Retrieve Value from custom Field of QuickBooks Online
      • Salesforce Opportunity to QuickBooks - Disabling Jobs
      • Salesforce QuickBooks Custom Mappings
        • Use Case
      • Salesforce QuickBooks Integration with Multiple QuickBooks
      • Syncing Standard Group Line Items in QuickBooks Desktop
    • Using Date Function in DBSync Integration
    • Salesforce and Database
      • Database to Salesforce Integration
    • Database to Database
      • Database to Database Integration
Powered by GitBook
On this page
  • Overview
  • Prerequisites
  • Connector Configurations
  • Useful Links
  1. Connectors

Microsoft Dynamics NAV

Learn how to use the Microsoft Dynamics NAV Connector in DBSync Cloud Workflow

PreviousMicrosoft Dynamics GPNextmonday.com

Last updated 8 months ago

Overview

DBSync's Microsoft Dynamics NAV connector allows you to integrate your front, and back-office, applications to streamline and automate your business processes. It ensures 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 applications - such as MSCRM, Salesforce, SkuVault and various other databases.

DBSync's MS NAV connector allows you to move data in, and out, of the Microsoft Dynamics NAV application. This connector connects directly to your MS Dynamics NAV instance. It 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.

Prerequisites

To establish a connection to Dynamics NAV, via DBSync NAV connector, the user must:

  • Have a valid license to DBSync NAV connector, username and password to connect to DBSync iPaaS platform.

  • Have access to Dynamics Nav with valid username and password.

Connector Configurations

DBSync's 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, then, s/he must create a separate connection for each. The table below represents parameters required for opening the connection to NAV user instance.

Property

Description

Required

Username

The username of MS NAV instance that has to be connected with.

Yes

Password

The password for the user of MS NAV instance that has to be connected with.

Yes

Base URL

Base URL is the web service URL that is generated from the NAV application in the following manner.

Navigate through

Administration→IT Administrators→General→ Lists→ Web service

Copy the SOAP URL and paste it in the Base URL field of the connector page.

Yes

After a connector is created within a project, set up the connector within the project. DBSync can then map to, and from, the systems that are supported by our standard connector list. It can use NAV connector to retrieve data from, or send data to, NAV Platform.

Click on the following link to learn about all connectors we support.

Uses Of MS Dynamics NAV Connector

DBSync 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.

Supported Versions

DBSync's MS Dynamics NAV connector only supports following versions of Navision.

  • Microsoft Dynamics NAV 2016

  • Microsoft Dynamics NAV 2015

  • Microsoft Dynamics NAV 2014

  • Microsoft Dynamics NAV 2013

Frequently Asked Questions (FAQ)

How does DBSync connect to MS NAV? DBSync connects to MS NAV through Web Services. Services (and Pages or routines) should be exposed for other applications to consume it.

What are the prerequisites for DBSync integration to work with MS NAV? SOAP Web service of MS Dynamics NAV should be enabled.

Is this connector available with, On-demand and On-premise, versions of DBSync? Yes. This connector supports both versions.

Does DBSync need to be installed on the same machine as that of MS NAV? DBSync MS NAV adapter can be either configured on the same machine - where MS Dynamics NAV is installed - or, on a remote machine that can access MS Dynamics NAV.

What is DBSync SDK? 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.

Why do we need this additional coding? At times, Web Services that are exposed either cannot be imported or ETL tools cannot interpret the metadata. This may cause ETL tools to fail. With our Java Adapter extensions, we can handle many of these cases very efficiently.

Useful Links

SOAP URL format ""

Connectors
Microsoft Dynamics NAV website
Microsoft Dynamics NAV documentation
http://WIN-73D0K4TTRC2:7047/DynamicsNAV80/WS/CRONUS%20New%20Zealand%20Ltd./Page/