integrationHub ETL not working with non-cmdb table

[Lam_B]

Hello everyone,

This is my first time working with IntegrationHub ETL for importing non-CMDB data.

According to the documentation and the videos I've watched, to ensure the import of non-CMDB data via IntegrationHub ETL, we need to first create a CI identifier for our non-CMDB table. In my case, it's the sys_user table, and for that CI identifier, we must configure the identifier entries and the related entries.

I have completed all of these steps, and now I can select the "user" table as a class in the IntegrationHub ETL.

The problem arises when I attempt to map, as the activation slider is always grayed out.

Also now I have a button "add associated CI" that displays the message "This non-CMDB class must be associated with a CMDB class." but with an empty dropdown list. (see the screenshot below)

Even if I want to associate my table with a CI, I cannot do it.

Do you have any insights into what might be causing this problem?

[Maik Skoddow]

Hi @Lam_B 

try to create a respective record at the "Related Entry" table (cmdb_related_entry) manually to associate the targeted CMDB  class.

Maik

[Lam_B]

Hello Maik,

Could you please explain the rationale behind creating an association with a CMDB class? My objective is to import users into the user table.

In a personal developer instance, I managed to map to the user table without establishing an association with any CMDB table, utilizing the same configuration outlined in my post.

[Maik Skoddow]

Hi @Lam_B 

when you write "I managed to map to the user table without establishing an association with any CMDB table": Do you mean you also have used IH ETL in your PDI to import into sys_user table without any additional configurations? 

Maik

[Lam_B]

Hi Maik

Yes right, I was able to import my users without any additional conf