Populating CI classes using integration HUB ETL

[Passion_of_SNOW]

I need to populate two CI classes in the CMDB using data provided via an Excel spreadsheet. The client will supply values for the following attributes:

1. VMware vCenter Server Object (cmdb_ci_vcenter_server_obj)

• Name
• IP Address
• Serial Number
• OS Version
• Install Status
• Environment
• Support Group
• Managed By Group
• Owned By
• Change Group
• Approval Group
• Location

2. Virtual Machine Instance (cmdb_ci_vm_instance)

• Name
• IP Address
• VMware vCenter Server Object Serial Number
• Install Status
• Operational Status
• Environment
• Support Group
• Managed By Group
• Owned By
• Change Group
• Approval Group
• Location

I’ve been asked to load this data using Integration Hub ETL to ensure that the Identification and Reconciliation Engine (IRE) is properly applied and to minimise data inconsistencies. However, I haven’t used ETL for this type of load before, so I’m looking for some guidance on how to approach it.

Specifically, I’d appreciate advice on the following:

• Should the relationship between the two CI classes be defined and mapped before performing the data load?
• Is any scripting required as part of the ETL process, or can this be handled through standard transformations?
• What is the recommended way to ensure that the dependency between the Virtual Machine Instance and the VMware vCenter Server Object is correctly established during the load?

Any guidance or best practices would be greatly appreciated.

[shubhamseth]

@Passion_of_SNOW I sharing couple of point here: 

Integration Hub ETL is very powerful and recommended way to push the data in any of the CMDB tables as it goes though IRE engine. 

Step 1: Create Data source where type can be excel spreadsheet. 

Step 2: Try loading 20 records for testing purpose in staging table. 

Step 3: Create Integration Hub ETL. While creating this make sure to use the same data soruce as part of created in step1. 

Step 4: Set up the prepare and map the right data to respective target coloumns. Add tramsform if you want to manipulate the data. 

Step 5: Perform the mapping between soruce and target tables mapping variable as per requriemnet, Also, please perform the relatioinship mapping to other classes as part of this step itself. 

Step 6: once you are done with it, try running the integration and it would populate the data. 

Make sure you have defined the unique parameter and also you have defined the Identification Rule as part of IRE in CI Class Manager. 

Please review the data and we are done! 🙂