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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Analysing Microsoft NA...
Microsoft Dynamics NAV (Archived)

Analysing Microsoft NAV Data with R

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

i want to analyse data from my companys Microsoft NAV in R.

What is the best way to access the data from R? I´ve connected R with the MS NAV SQL-Database via ODBC. But now i´ve got the problem, that i don´t know which tables contain the information i need. I would need a resource to find out, i.e. where i can find the information to recreate the NAV-tables i´m looking for.

Another approach would be, to let some developers build Odata-Feeds for my data-needs. What would be the advantages, considered the costs?

Looking forward to your responses,

Niels

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Rashed Profile Picture
    Rashed 3,765 on at

    Hello Niels.   I suggest against reading the data directly from SQL, unless you are a small organization  and do not have high volume of transaction.  Querying the data direct will have a performance issue. 

    There are several other options.  One is to have a process that migrates the data into a separate database or database warehouse Cube. You can also setup sql replication and query the data from replicated sql database.

    As for which table you need to query, you can find that out from users.  Just ask your users where the data is, and you can then click on About This Page  and see the actual table name. 

  • Community Member Profile Picture
    Community Member on at

    Thank you, for your kind reply.

    A replication-server that pulls new data every night is a good idea. Then i would only need to connect to the live-server for i.e. todays´ sales numbers.

    Our service provider suggested to create query objects and publish them as Odata feed, so there wouldn´t be any perfomance issues and i don´t have to become an expert for the data-structure in the sql server.

    I found out about the trick with "about this page", but i don´t see all tables i need. For example i only get "Sales order header", but not all tables.

  • Rashed Profile Picture
    Rashed 3,765 on at

    To see the tables for the details,  such as sales line.  You can click on the lines and then click  Cntr+Alt+F1   and it will open the detail. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans