Create a Dynamics NAV Data Source with Jet Basics – Support Topics

The information in this article will help you establish a Direct SQL Server connection to your NAV 2013 (or higher) database

Jet Basics Help Topics...

Overview

For accessing Dynamics NAV 2013 or newer, Jet Basics includes multiple connection methods:

Let's look at how to establish a Direct SQL Server connection to your database

Requirements

For organizations and users with direct access to the SQL Server on which their NAV database is stored (and using Windows Authentication or NAV User/Password Authentication), this data source can provide substantially faster reporting access than is traditionally possible through NAV's Web Services.

If your organization uses a different type of connection, please see one of our other articles:

If your organization uses NAV Web Services for accessing NAV, see the article on using the Jet Business Objects for NAV Web Services.
If your NAV database is located on a server somewhere other than on your network, you have the option to connect through a Remote Data Service.
If you need to access a Multi-Tenant installation of NAV, you will want to use a Multi-Tenant SQL Connection.
If you are using NAV 2009R2, see Setting Up A NAV Data Source

(although these articles describe the full Jet Reports Excel add-in, the concepts also apply to Jet Basics)

Configuration Settings

Authentication Tab

Once you have selected Direct SQL Server and clicked OK, the first thing you must do is specify the account information that will be used to connect directly to the SQL Server

If your SQL Server is configured to automatically recognize the user names used to log on to Windows, you can use one of the Windows Authentication options (either the current Windows user or another Windows user).

If your SQL Server is not configured to recognize Windows user names, you will need to choose SQL Server Authentication and provide the user name and password for an account that does have permissions to access the SQL Server. Please contact your system administrator to determine what information should be used.

Once you have specified how to access the SQL database, you will then want to specify which NAV user will be used when determining the roles and permissions used to access the NAV data.

If your NAV system is configured to recognize the user names used to log on to Windows, you can choose Windows Authentication (current user) to use the current Windows user's credentials. Otherwise, Jet Basics also supports the use of NAV User Password authentication (see information about NAV Authentication types)
Connection Tab

You will need to provide the name or IP address of the SQL Server hosting your NAV database.

Once this information is provided, you can click the Database down arrow to select the name of your NAV database

Next, click the Company down arrow to select the NAV company name (this must be specified even if you have only one company in your NAV database).