How can one get data model structure of tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-12-2022 08:32 AM
Hello,
Does someone know if there is a ressource or a tool for tables model of servicenow other than business or cmdb data structure ?
I'm looking for something more readable than the schema map (i may not use it to its potential, i'm no expert. I've only been able to check the relations to one table, but i cannot see the relation to referencing tables for example without opening another schema map, and it's basically unreadable for what i want).
For reference, i would like to see the relation for the view/section/element in a way similar to what is presented here : https://www.snow-mirror.com/wp-content/uploads/2016/07/ServiceNow-Data-Model-v3.4.pdf
I'm certain i will want to check models one day for other non business, non cmdb data structure (application model basically). I'm hoping there is some sort of general ressource given/used by servicenow or something compiled by others SN users that i could check.
Thanks in advance
- Labels:
-
Reference Architecture
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-12-2022 08:48 AM
CI class manager is the one provided by servicenow OOTB.
Which actually covers parent-child hierarchy but something like snow-mirror is not there .
Anshu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-12-2022 10:13 AM
Unfortunately there is no OOTB tool that presents the table structure quite like the link you provided. At least not with many layers of tables/relationships shown in a data model.
The OOTB Schema map does give you a table structure surrounding a table of your choice with both upstream and downstream referenced/extended tables - Keep in mind you can refocus the schema map on any table by right clicking on the table and choosing "refocus on this table" . The reason the schema map is limited in what is presents is due to the performance required to render this data graphically in the web browser. The table viewer is few years old at this point - it's not the bleeding edge of web rendering tech...
You could also explore:
- exporting the dictionary and relationships into an external tool that will allow you to graphically create a database model. MS SQL Server offers graphical representations of databases nicely.
- I am certain there will be a ServiceNow partner that has built an app to do this by now. Check the SN Share and Store.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-12-2022 01:40 PM
Extracting the dictionary may be a bit messy because of all the relations that are not really important, but that is still a valid idea if nothing else, thanks.
I'll check the store and keep looking for tools that may answer my need. Well, more curiosity than need anyway as i can always just navigate in the tables and schema map (the refocus on this table makes the schema map slightly more useable i guess) when i need to understand the application data model.
Anyway, thanks for the help.