How to establish relations using IH ETL for Data imported using CSV?

[Navaneeth1]

I have to populate two CMDB tables cmdb_ci_computer (Computer) and cmdb_ci_appl (Applications) with data from CSV. I'm trying to use IH ETL to populate the two tables with the data from CSV.

Can someone please tell me how the relationship between these two tables can be established using IH ETL and what should I give as the Unique key for Applications table (cmdb_ci_appl)?

Thank you in advance! 

[Akash4]

Hello,

The steps in ETL also have some dependencies, here is the ETL Steps I followed when I performed for my client. You can post for any errors here, I may be of assistance later.

Link: https://www.youtube.com/watch?v=2tVLhE_OwOE

Hope this helps!
Regards, Akash
_____________________________________________________________________________
Please mark it as helpful👍 or Accept Solution✔️ based on the response to your query.

[Navaneeth1]

@Akash4 
Thank you so much!

[Navaneeth1]

@Akash4 

Hey, I tried this and established a Depends on Relationship between the Computer table and Application table but the mapping seems to be not working as the application table is coming up empty on the preview sample integration part?

Should the source key of each class (computer and appl) be the same? or is there a specific way to establish the relationship?

[Akash4]

In Prepare Source Data >

1. Create Unique field #1 for Source Key >

• Create new column of Concatenation type with
• Input columns as Application Name, Computer Name
• Concatenate with String say "-" or "@" for easy differentiation from text.

2. In the Map Data to CMDB & Add Relations: Try following

• Under Application > Source key= use Concatenated key, Source timestamp as Created, other fields (at least 2) Name and Owner etc.
• Under Computer > Source key=use same Concatenated key, etc..

Hope this helps!
Regards, Akash
_____________________________________________________________________________
Please mark it as helpful👍 or Accept Solution✔️ based on the response to your query.