Data in servicenow is instance and it is stored and managed by a principled structure that can be view and configured by the Administrator. Data administration functions include importing, exporting, and archiving database data and configuring fields and tables. To effectively manage and improve your systems, you have to know exactly what resources are in your IT condition and have present exact configuration data. With an exact configuration management database (CMDB), it’s easy to understand your association’s IT environment, especially in the areas of service impact analysis, resource management, compliance, and configuration management.
The ServiceNow CMDB gives a single system of record for IT. At the point when combined with ServiceNow Service Mapping, the CMDB becomes service aware which empowers your ServiceNow applications to be service aware too. Presently with your CMDB, you increase the full visibility of your infrastructure and service, leading to more control of your environment and better choices.
Below are some important features of Data management
The information is stored in database tables and records.
Different tools exist to deal with this data.
The schema map displays CI relations graphically.
Data word reference tables store structure and relationship definitions.
Data import and export simplifies managing large data sets through import maps and various exportable formats.
Different modules give extra functionality.
Field standardization makes records more reliable and prevents duplication of data.
Database structure:
The majority of the data in the instances is stored in tables, which consists of a series of records. The record thus holds a series of fields that hold the individual bits of information and can be viewed either as a list or a form.
The table can be related to each other in many ways:
Extensions: A table can extend another table. The table expanding incorporates the majority of the fields of the other table (parent class) and includes its own fields. For example, the Incident [incident] table has the majority of the Task [task] table fields (on the grounds that an occurrence is an exceptional type of errand) and has its own incident specific tasks.
One – to – Many: A field can hold a reference to a record in another table within a table.
There are three types of one-to-many relationship fields.
Reference Field: It enables a user to choose a record on a table defined by the reference field. For example, the Caller field on the Incident table enables the user to choose any record on the User table.
Glide List: It enables a client to choose different records on a table characterized by the glide list. For example, the Watchlist field on the Incident table enables the client to choose records on the User table.
Document ID Field: enables a user to choose a record on any table in the table. These fields are substantially less common, yet one example is the Document field on the Translated Text [sys_translated_text] table.
Many- to – Many: Two tables can have a bi-directional relationship, with the goal that the related records are visible from the two tables in a related list.
Database Views: Two tables can be joined for all purposes with Database Views to enable reporting on data that may be put away stored over more than one table.
Data management Tools:
There is the number of data a management tool that helps to manage the data.
Schema map: The Schema Map shows the connections between tables visually, exploring through the database structure. The Schema Map gives an interface to review the connections between tables. The inter-table connections it captures incorporate many-to-many relationships, tables that extend other tables, and tables that reference other tables through reference fields.
Data Dictionary Tables: Data dictionary tables hold data that characterizes the database and can accesses data on the database schema.
Table Cleaner: The system automatically records from particular tables after a particular time to deletion. Erasing these records naturally, keeps the tables from developing to an unmanageable size. The time before a record is deleted starts on the date and time value in the tracked field.
Recommended Audience:
Software Developers
Project Managers
Analytical Professionals
ETL professionals
Prerequisites: It is good to have a knowledge of coding and databases like SQL, MySQL. But it is not Mandatory.Trainers will teach you from the basics