Skip to main content

Connecting to Dynamics NAV

Overview

The Dynamics NAV adapter simplifies the extraction of data from Microsoft Dynamics NAV.  This article details how to setup the NAV adapter using a SQL Provider.

Prerequisites

Import NAV Adapter into the New NAV Database (NAV 4.0SP1 - 2009R2)

If the NAV database that is being used is a new NAV database that was not previously used by the Jet Data Manager then the NAV Adapter needs to be imported into the NAV database and the Adapter Setup needs to be run.  This is the same process that was followed during the initial setup and additional information can be found in the Jet Reports installation document.

Open the Project in the Jet Data Manager

Since the data source needs to be changed in the project itself, open the Jet Data Manager and open the desired project.

Add Dynamics NAV Adapter

  1. On the Data tab, right click Data Sources > Adapter Data Sources > Add Dynamics NAV Adapter.

  2. Click Wizard Setup.

  3. Click Microsoft SQL Provider.

    mceclip2.png

    For adding a NAV Native data source see the following article: Configuring A Natvie NAV Project
  4. In Add Dynamics Business Central (NAV) Adapter, assign a name in the Name field. In this example we choose NAV.  Click OK.

  5. In the Server name field enter the name of the server where your NAV database resides. In this example we choose localhost.

  6. In the Database field select your NAV database.

  7. Click OK.

    mceclip4.png

  8. In Jet Data Manager Server, accept the defaults and click OK

    mceclip5.png

  9. In Adapter Settings, a ccept the defaults and click OK

    mceclip6.png

  10. The Synchronization result: dialog opens and shows added accounts. Click OK.

  11. Select the company(s) you would like to report from. In this example we only wanted to report form the North American company.

  12. Select the template that corresponds the the company you selected.

  13. Click OK. If selecting more than one company, select the template of the main company.

Synchronize Database Objects

  1. Right click the NAV data source and select Read Objects . This will synchronize all necessary database objects (such as tables, fields, and option values) from the new data source to the Jet Data Manager.

    The NAV Adapter must be imported and executed in the new database prior to synchronizing the objects.  If this has not been done then an error will appear.

  2. The following window will appear during the synchronization process:

    Once synchronization is complete the Jet Data Manager will display any changes that have occurred in the tables and fields currently being used in the project. If no changes are found the follow screen will appear:

Deploy and Execute the Project

  1. After the new data source has been configured and synchronized the final step is to deploy and execute the project against the new database. This can be achieved by clicking the Manual Deployment and Execution button at the top of the Data tab.

  2. Click the Start button to start the deployment and execution process.

Was this article helpful?

We're sorry to hear that.