Hello!
Looking to bulk load business capability mappings to Business applications.
I have a spreadsheet that contains capability to business application values.
What table holds this information? Or where is the best way to set these in bulk?
Thanks!
Jim has is right. The Relationship type is Provided by:: Provides where the Business Capability is assigned to the parent on the cmdb_rel_ci record and the Business Application is the child. When you build the transform, you will need field map records: Business Capability -> parent, Business Application -> child, and the Type -> a scripted field map that returns the sys_id for the Provided By::Provide relationship type which are defined in the CI Relationship type table [cmdb_rel_type]. The field maps for capability and application can look up by name if, and only if names are unique which is not always the case with Capability models.
Here is an example Transform map
the type field map:
You may need to script the Application (child) and Capability (parent) columns as well to lookup by name. I always make the choice action reject so if the capability or application is not found.
Jim has is right. The Relationship type is Provided by:: Provides where the Business Capability is assigned to the parent on the cmdb_rel_ci record and the Business Application is the child. When you build the transform, you will need field map records: Business Capability -> parent, Business Application -> child, and the Type -> a scripted field map that returns the sys_id for the Provided By::Provide relationship type which are defined in the CI Relationship type table [cmdb_rel_type]. The field maps for capability and application can look up by name if, and only if names are unique which is not always the case with Capability models.
Here is an example Transform map
the type field map:
You may need to script the Application (child) and Capability (parent) columns as well to lookup by name. I always make the choice action reject so if the capability or application is not found.
