web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How is the data in MS Dynamics Nav stored? Is it a data warehouse and how do I access it?

(0) ShareShare
ReportReport
Posted on by 5

I realize the question may be a little bit confusing but that's b/c I'm confused.  So I am a contractor and assisting a company who utilizes Nav to catalog all their business needs. In my full time role, I work for a tech company where I am able to access all of our data via SQL .  Our data is stored in a bunch of different tables and I can query those tables for what I need and join them if need be (quite often) to extract that data.

I am stepping into this contractor role with little to no info.  This company is not very technologically savvy.  They have given me access to Nav but it is quite confusing to me.  First and foremost, I want to see if tables exists, where they're located, what's in them and what are the table names etc.  They have a ton of data in Nav, I just don't know how to see it and access it beyond the Nav interface.  Ultimately, my goal is to take the data and connect it to Tableau and create data visualization dashboards.

Can someone please help me with this?

I have the same question (0)
  • Suggested answer
    protc Profile Picture
    on at

    Hi Partner,

    Thank you for your query,

    May be this could guide you a bit:

    docs.microsoft.com/.../data-access

  • youngchea Profile Picture
    5 on at

    Thank you for that link. For your reference, the company I am working with is using MS Dynamics NAV 2009 R2. Extremely outdated! When I go to File > Database > Information is greyed out and I cannot click it.

    I did some research and found that is how I am suppose to access the database but not sure what to do if it's greyed out.  Is it just a permissions issue?  Or is it something else?

    Do you think I should push the company to upgrade to the latest/newest version of NAV? What options are available to me to access the database given the info above?

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi, 

    Its a permission issue. Either you need to have appropriate permission assigned to your user id or use user id which has SUPER permission assigned.

  • youngchea Profile Picture
    5 on at

    Thank you!  When going to File > Database > Open I can see the the server type (MS SQL Server), server name and database name.  It asks for user id and password which I don't have.  

    The ultimate goal is to build data visualization dashboards.  I initially mentioned Tableau but now I am also considering PowerBI given that this company is already in the MS ecosystem.  Right now they are using Jet to analyze their data.

    I guess my next questions are:

    - Where do I go to actually explore this data and write SQL queries?

    - How do I connect their NAV data to PowerBI?

    - Based off your answers, it might not make sense to upgrade to the latest version.  However, given they are on a version of NAV that is over ten years old and the whole purpose of this project is to modernize the way they view and access their data, I feel like if there was ever a time to upgrade, it would be now. I don't want to put the cart before the horse and jump straight to the visualization when the back end is outdated.

    Would love to get your thoughts.

  • Suggested answer
    Marco Mels Profile Picture
    on at

    Hello,

    docs.microsoft.com/.../admin-powerbi-setup

    Thanks.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans