Map with explicit transform map scripts
-
- UpdatedJan 30, 2025
- 3 minutes to read
- Yokohama
- Data Management
Explicitly define mapping relationships in the Transform Map record itself.
An explicit Transform Map script explicitly defines mapping relationships in the Transform Map record itself. It runs after the source field values have been copied over to the target record, and before they are written to the database.
CMDB software import facilitated by explicit mapping script
An example demonstrating how explicit map scripting can be used to facilitate an import of software instances to the CMDB where it is necessary to have the count in the software packages table reflect the number of instances.
In the CMDB there exist tables for software packages and software instances. A software package refers to a one individual software title, such as Mozilla Firefox. A software instance refers to an individual instance of a software title such as Mozilla Firefox on Jared_T60_Laptop.
In more technical terms a software instance is a many-to-many relationship with a software package and a configuration item. This script imports software instances. In doing so it checks to see if a software package for the instance exists. If the software package doesn't exist then it is created and the sys_id for the newly created package is associated with the instance via the instance record's Software field.
Populating child tables by setting class names in an import to the CMDB
An example demonstrating how to import servers into the configuration management database.
User import data sanitation
An example script demonstrating how to sanitize user data before import.