Skip to main content

Create a Dynamics NAV data source with Jet Reports

Overview

Jet Reports can connect to your Dynamics NAV data in a variety of ways - depending upon the version and type of NAV configuration your organization uses.

Here are some helpful knowledgebase articles to help you access your NAV data.

NAV 2013 and higher

SQL Direct

Recommended

The Jet Excel add-in can connect directly to NAV's SQL database.  This is the fastest connection method.

( in the Jet Hub )

Remote Data Service

Recommended method for when NAV exists on a separate networkthan does Excel.

NAV Web Services

This is a great choice if your NAV installation does not match the Requirements for connecting directly through SQL Server

( in the Jet Hub )

Connecting to Multi-Tenant Dynamics NAV

SQL Direct

The Jet Excel add-in can connect directly to NAV's SQL database.  This is the fastest connection method.

NAV Web Services

This is a great choice if your NAV installation does not match the Requirements for connecting directly through SQL Server

NAV 5.0 through NAV 2009 R2

Setting up a NAV Data Source (NAV 2009R2 and earlier)

Was this article helpful?

We're sorry to hear that.