By using this web site you accept our use of cookies. More information about cookies
Accept
Infopulse - Expert Software Engineering, Infrastructure Management Services
By using this web site you accept our use of cookies. More information about cookies
Accept
Infopulse - Expert Software Engineering, Infrastructure Management Services
Infopulse - Expert Software Engineering, Infrastructure Management Services
Send message
Send message Please fill in this quick form and we will send you a free quote shortly.
* Required fields
Your privacy is important to us. We will never share your data.
Subscribe to our updates Be among the first to get exclusive content on IT insights, innovations, and best practices.
* Required fields
Your privacy is important to us. We will never share your data.
Subscribe to our Vacancies Please fill in this quick form to be among the first to receive our updates.
* Required fields
Your privacy is important to us. We will never share your data.
Subscribe to our updates Be among the first to get exclusive content on IT insights, innovations, and best practices.
* Required fields
Your privacy is important to us. We will never share your data.
Photo of Kostiantyn Dovgal Send an email to Kostiantyn Dovgal Please fill in this quick form to contact our expert directly.
* Required fields
Your privacy is important to us. We will never share your data.
Infopulse - Expert Software Engineering, Infrastructure Management Services
Read the Full Case Study Don't miss the most interesting part of the story!
Submit this quick form to see the rest and to freely access all case studies on our website.
* Required fields
Your privacy is important to us. We will never share your data.

Extending Predefined ServiceNow CI modules – Part II

In our previous blog post, we explained how to add a new module to the Configuration Application menu and how to retrieve data by setting new filters in the already existing tables. Since there are different ways to implement data retrieval by modules, in this blog post, we’ll show you another approach to creating a new module and retrieving data from CMBD.

Deal With Hierarchical Data In A Better Way

Last time we used a very simple filter to select data from the single table. Sometimes the provision rules can be much more complex due to the hierarchical data nature. Thus, using filters might not be the best and the most sound way to implement data import and store information in ServiceNow.
Let’s review another way to create an Informix Database Instance and make it appear in the Database Instance menu of the CI module.

Extending Predefined ServiceNow CI modules – Part II - Infopulse - 174983

Fig. 1. Database Instances menu

We’ll need to go through the following steps:

  1. Create a new table to collect Informix instance related data;
  2. Create a new CI module to be shown as a Database Instance subitem;
  3. Modify the transformation map to populate new table with Informix-related data;
  4. Validate the results.

Let’s get things done.

A (Not So) Hard Way to Extend the List of Available Database Types

(1) Create a new table to collect Informix-related data.

Go to System Definition -> Tables & Columns -> Create table
Name the new table “Informix” by filling in the Label field and make it inherit the predefined Database Instance table.
Note: Name field may vary in different cases depending on the current working Application scope.

Extending Predefined ServiceNow CI modules – Part II - Infopulse - 855865
Fig 2. Creating new table

(2) Create a new CI module and make it shown as a Database Instance subitem.

Go to System Definition -> Modules -> and create a New module.

Enter a value under the Title field that you want to be shown as a CI module name (e.g., Informix).

Enter a configuration value in the Application Menu that would be a part of a menu where the new module will be shown.

Order value defines the place in the Application Menu hierarchy where the module will be shown.
Select a newly created Informix table as a data source (a mandatory field in the table).
You don’t need to create filters this time.

Extending Predefined ServiceNow CI modules – Part II - Infopulse - 360712
Fig 3. Creating new module

(3) Modify transformation map to populate the new table with Informix related data.
In order to correctly populate new table with Informix entries during data load, the transformation map of Database Instances needs to be modified. To do this, we need to check the type of database instance in run time and assign a proper target class name for provisioning. Transformation map frame and full code listings are present in fig. 4.

Extending Predefined ServiceNow CI modules – Part II - Infopulse - 480348

Fig 4. Modifying Transformation map

(4) Validate the results.

As a result, a new submodule is now present in the Database Instances menu.
New data load and transformation map should be performed in order to populate Informix.

Extending Predefined ServiceNow CI modules – Part II - Infopulse - 753258

Fig 5. Informix is now present as a submodule in the Database Instances menu

Thank you for reading our series of blog posts on creating new items in the ServiceNow Database instances menu. Are you interested in other technical reads? Subscribe to our newsletter and stay tuned for new technical guides from Infopulse specialists!

Subscribe to our Newsletter