Does Micosoft have a Navision Data Model available? I would like to know the relationship between tables, data flow, etc Thanks
Hello, I’ve been working with Navision for some time now, but I never saw such a model. If it exists[Wow!], I would sure be interested. Francis
The only way to do this is to use the Navision Developers Toolkit that shows relations between tables, but if you want an ER model you’ll never find it (!). Bye Marco
If you’re using SQL you can map 95% of the Navision table relations into SQL Relationships (foreign keys) using the Relationships option of the Intergration tab of Alter Database. You can then diagram these relationships using other tools such as Visio, Enterprise Manager etc, picking the tables you want.
quote:
If you’re using SQL you can map 95% of the Navision table relations into SQL Relationships (foreign keys) using the Relationships option of the Intergration tab of Alter Database. You can then diagram these relationships using other tools such as Visio, Enterprise Manager etc, picking the tables you want.
Originally posted by robertc - 2004 Sep 24 : 19:09:17
Hi Robert, I’d more than gratefull if you could sent me more details on how I can perform the above mentioned task, since I have clients that want to be given a diagram of the relationships in Navision [}:)]
Dear All, I did find a way to get an ERD for Navision, and having seen the number of times that this posting has been read, I can only share it with the rest of the Nav profs…so take a look at the following link… [:D] http://www.mibuso.com/dlinfo.asp?FileID=152 Njoy Vasileios
Microsoft or Navision does not have a data model to show. That knowledge comes by experience and asking others. You can also find the relationships and flow of data by looking at properties and code.
quote:
Microsoft or Navision does not have a data model to show. That knowledge comes by experience and asking others. You can also find the relationships and flow of data by looking at properties and code.
Originally posted by SimonMc - 2004 Oct 25 : 16:47:57
Hi SM, If you take a look at the link I provided, you will find a Visio automation template, that is written specifically for providing ERD diagrams for Navision. I have tested for small number of tables (30 to 50) and it works just fine. I dunno though how it will behave if I attempt to get an ERD for all the Navision tables (1000+ tables in 3.70), but you could as well get ERD diagrams per functional area [:D] Check it out
Hi, Have a look at www.NaviTools.com. Klaus