Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

NAV data to SQL Express

Posted on by Microsoft Employee

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

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV data to SQL Express

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

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    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 :-)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Suggested answer
    ShanAbeywicrema Profile Picture
    ShanAbeywicrema 940 on at
    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)

  • Claus Macali.dk Profile Picture
    Claus Macali.dk 997 on at
    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 :)

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    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.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans