There are three methods of using the Jet Excel add-in to report from a Microsoft Dynamics NAV 2013 (or higher) database.
Which method you use would depend on a few factors:
Dynamics NAV Connection Methods
Connecting Directly to NAV's SQL Database
- You have direct access to the database AND...
- The SQL server resides on the same network domain as your installation of the Jet Excel add-in AND...
- Your installation of NAV uses either:
- Windows Authentication OR...
- NAV User/Password Authentication
Version 14.1 and higher of the Jet Excel add-in can usually communicate directly with NAV's SQL database.
Please refer to the Configuration article for information on how to proceed.
Connecting through a Jet Remote Data Service (JRDS)
If your Dynamics NAV system resides on a different network domain than does your installation of Microsoft Excel...
If you have direct access to NAV's SQL server and your installation of NAV uses Windows Authentication, version 15.1 and higher of the Jet Excel add-in can usually communicate directly with NAV's SQL database.
System Administrators will want to see the JRDS Admin Guide for information about how to configure the service.
Once a Jet Remote Data Service is set-up, users of the Jet Excel add-in will want to refer to the User Configuration article for information about how to use the JRDS.
Connecting through NAV Web Services
Finally, you can also access your NAV 2013 (and higher) data by using NAV's Web Services to handle the communications.
See the article on installing the Jet Reports Business Objects for NAV for details.