NAV data to SQL Express

(0) Share

Report

Posted on by Community Member

Hi all,

If I uses a batch jobs to extract several table data from NAV database to SQL Express, then build a ASP.NET application to read/write the SQL Express Database.

Do I need to buy any NAV user license or other license? i.e. if I have 50 users to use the ASP.NET application.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: NAV data to SQL Express

No it’s not multiplexing. Multiplexing is a practice of accessing the application through a “Pooling Resource” in order to minimize impact on the database.

If you only need to query the SQL Server db from ASP.NET, you don’t need an NAV License. If you plan to use web services, yes.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: NAV data to SQL Express

If reading the NAV database from other application directly, is it multiplexing?

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: NAV data to SQL Express

You don’t need a license for reading the NAV database from the external (in this case you read data and don’t use the internal NAV business logic).

If you’re using NAV Web Service, you need a NAV user to do so, so you need at least a license (external user is the best way).

Hoping this will close the thread :-)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: NAV data to SQL Express

Hi all,

I am quite confusing. I found someone said that even reading from the NAV database and presenting the data in one way or another requires extra licenses (for each user). Even ETL the NAV data to another database for another ASP.net application also required each user license?

i.e.

dynamicsuser.net/.../what-are-dynamics-nav-2016-licensing-requirements-for-web-services

Was this reply helpful? Yes No
Suggested answer

ShanAbeywicrema 948 on at

Like (0)

Report

RE: NAV data to SQL Express

Hi Pradeep,

You do not need to buy NAV User license since you are accessing through ASP.NET ( External Application)

Was this reply helpful? Yes No
Claus Macali.dk 1,003 on at

Like (0)

Report

RE: NAV data to SQL Express

The case is, you are using NAV data, created by NAV, so some will say you need a license and some do not need a license. I will say you do not need a license, the q you should not ask :)

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: NAV data to SQL Express

1) In teory you need at least an external user access (if the reporting tool can work with asingle user to connect to the database).

2) The reporting tools access a different db, so no licenses for NAV

I repeat: if you access the SQL Server db directly, you don't strictly need a license.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: NAV data to SQL Express

Hi Stefano,

How about below two situations:

1) Access the NAV database by a reporting tools, i.e. 50 users will use the reporting tools

2) Access another database by a reporting tools (data synchronized from NAV database) i.e. 50 users will use the reporting tools

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 49,097 Super User 2025 Season 2 on at

Like (0)

Report

RE: NAV data to SQL Express

Pradeep,

I don't think you need to buy a license in this case, as you are accessing the data from other database. But when you access the data from the Navision you need to have a user license.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
RE: NAV data to SQL Express

Multiplexing. Multiplexing (sometimes referred to as "pooling") is a manner of indirect hardware or software access ("indirect access") that

pools connections,

reroutes information,

reduces the number of users that directly access or use the software, or

reduces the number of users the software directly manages.

Any user accessing the ERP Solution through a multiplexed connection must be appropriately licensed with an Access License.

You don't have blocks on accessing the NAV database from an ASP.NET application. If you want to be 100% compliant, you can buy an External User license and use this user to access the database.

Was this reply helpful? Yes No