How to create a CI or a Relationship to a CI which have a defined dependency?

[OliverTim]

Dear All,

We're struggeling setting up a proper IH-ETL import for CIs which have defined dependencies (e.g. MSFT SQL Instance, Kubernetes Namespace etc.). We are not even able to create a relationship between 2 existing CIs having a dependency. ETL always returns a MISSING_DEPENDENCY error.

Baseline:

All our CIs and relationships are found in non ServiceNow databases. So we have to import them class by class. There is no discovery in place. 

Import procedure:

1. We start to import the "basic" CIs first, like servers, clusters etc.
2. In a second phase, we want to import additional CIs which have dependencies.
   1. Importing and relate CIs with no dependency works fine
   2. Class Manager view of a CI with a dependency
      

How we configured ETL:

1. Class Mapping (in this case both CIs are already in the CMDB. We  just want to create the relationship)
   
   
   
2. Relationship
   
3. Result of the integration run
   Partial Load (find the JSON file as attachment)
   
   Warning Log  (find the JSON file as attachment)
   

Does anyone have an idea how to import CIs with dependencies using ETL? Is it even possible to use ETL or do we have to switch to transform maps?

Thanks a lot in advance for your support.

Best Regards

Oliver

[Abhiram8]

Hi Oliver

We are having same issue but unable to resolve the issue. We are getting missing dependency error.
For example, we are trying for DB2 Instance class, and hardware is the parent. I have added runs on relationship as well in RTE, but still facing the error.
Any suggestions would be helpful.

Thanks

Abhiram