Configure the Node relationship configurations
Create a Node relationship configuration record to establish relationships between nodes. Update the node relationships including source table, both Configuration Items (CI) and non-CI relationships. The Node relationship configurations define the connections between the source table and other tables (target tables), specifying how they are related.
Before you begin
Role required: sn_oper_res.admin
Procedure
Navigate to All > Data Relationships Framework > Main node configuration.
Open the desired Main node configuration from the list.
The following example shows the Main node configurations available in the instance.
List.
To add a Node relationship configuration, select New in the Node relationship configurations related list.
The Node relationship configuration form is displayed.
Record.
For description of the fields in the Node relationship configuration form, see [Node relationship configuration form](node-relationship-configuration-form.md).
You can set up these relationship registries by creating a Relationship Registry record in the Relationship Registries module. The Relationship Registry new record form is shown in the example.
Rel registry record.
For the description of the fields in the Relationship registry form, see [Relationship registry record form](rel-registry-record-form.md).
- Select the table of your choice in the Source table field in the Source tab.
Source table.
By default, the system auto-selects the table listed in the Main configuration record, the Service \[cmdb\_ci\_service\] table in this example. You can choose the auto-suggested table or a different table as per your requirements.
Select the relationship registry record in the Relationship registry field in the Relationship tab.
The relationship registry record defines how the Source table links to another table.
- Select the Search icon and select the Relationship registry record from the available list.
Relationship tab.
Selecting the search icon shows the out-of-the-box Relationship registries that have Service as the source table. You can select a Relationship registry from the list.
2. To select a new registry record instead of choosing a record from the out-of-the-box list, select **New**.
New relationship registry.
You can create a new registry record if the out-of-the-box options do not meet your needs.
3. Add a meaningful name for the new Relationship registry record.
You can add a proper name to avoid confusion because there might be other registries with the same name.
4. Select the relationship table in the **Table** field.
The table should be the same as the Source table from the previous screen. This table name may be different from the table that you have defined in the Main node configuration record.
5. Select the relationship type for the table in the **Relationship type** field.
Once the table is selected, the following options are displayed in the drop-down.
1. **One-to-one**
2. **One-to-many**
3. **Many-to-many**
4. **Scripted relationship**
Based on the selected drop-down value, a different list of tables is displayed in the **Relationship** field.
6. Select the relationship table in the **Relationship table** field.
For One-to-one relationship type, the **Relationship** field shows the list of tables that are used as reference fields in the Source table.
The table name is populated in the **Relationship** field.
Table.
7. Select **Submit**.
You have configured the Source table and Relationship registry.
Registry.
To select the target table, configure the Target section in the Node relationship configuration record in the next step.
Target fields.
Configure the Target tab.
All the relationship options are explained in this step.
| Step | Description |
|---|---|
| One-to-one | For non-m2m tables, in the Target tab, select Sys ID as the Target reference field and choose the Relationship table as the Target table. This is valid for One-to-one and One-to-many types. Image omitted: node-rel-target.png Target.</p></td></tr><tr><td id="d222384e373"><strong>One-to-many</strong></td><td><p>If the Relationship table is an m2m table, select <strong>Sys ID</strong> in the <strong>Target reference field</strong> and then in <strong>Target table</strong>, select the same table as the <strong>Relationship table</strong>.</p> Image omitted: one-to-many.png One-to-many.For One-to-many, the relationship shows the list of tables that has source table as a reference field.</p></td></tr><tr><td id="d222384e402"><strong>Many-to-many</strong></td><td>For Many-to-many, the <strong>Relationship</strong> field shows the list of m2m tables in which the source table is referred. Notice that for Many-to-many, you have to select the field from the drop-down that you want as output. For example, [cmdb_rel_ci] table has <strong>Parent</strong> (cmdb_ci) and <strong>Child</strong> (cmdb_ci) fields. If you want to find the child service, you can select <strong>Child</strong>.[Omitted image "many-to-many.png"] Alt text: Many-to-many.</td></tr><tr><td id="d222384e431"><strong>Scripted</strong></td><td><p>For the Scripted relationship, you can select the record from sys_relationship. You can define the relationship via script.</p> Image omitted: scripted.png Script.[Omitted image "scripted-2.png"] Alt text: Updated script.As you can see, the <strong>Applies to</strong> table has to be as same as the <strong>Table</strong> field from the previous screen. Here the value in <strong>Table</strong> field is [cmdb_ci_service_business] but in the <strong>Relationship</strong> field, it is [cmdb_ci_service]. This configuration works because the [cmdb_ci_service_business] table extends to the [cmdb_ci_service] table.</p></td></tr></tbody>
Image omitted: ser-to-dep-main-node-config.png Services to Dependencies. |