How to establish relations using IH ETL for Data imported using CSV?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2024 12:54 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2024 12:28 AM
@Akash4 ,
Thank you so much for the response! When I tried this, the Preview Sample Integration showed "This sample source data did not return any relationships". I see a tab for Computer but I don't see a tab for application. I checked the Application table and it's empty. The result looks like below:
I just wanted to point out that I'm using the same CSV file to populate both the computer and applications table. I have attached a copy of the excel sheet with the email.
The relationship I've established between the tables is Application 1 (Parent) and Computer 1(Child) = it's only allowing Runs on:: Runs relationship.
Could you please review the data source and see if any extra fields are needed for it to work?
Thank you so much in advance!