Map Attributes to Extended Table via IntegrationHub

[Tim Hart]

Hi Team,

I have a question about using IntegrationHub ETL to map attributes to "extended classes" when the parent table doesn't contain that attribute.

I am working specifically in the Solarwinds Service Graph Connector and in the IH-ETL Class Mapping - the devices are mapped to cmdb_ci_hardware but are also given a sys_class_name column based on inbound data (e.g. switches,routers, etc) and these devices are mapped into cmdb_ci_netgear for example. 

However, in the IH-ETL UI, there is no option that I can see to map to the fields in cmdb_ci_netgear, only the cmdb_ci_hardware fields. 

In the mapping for the Hardware table, I can see the SGC passes the class name to the class name column of Hardware?

Is there a way to map additional attributes based on theses extended CI classes?

[shubhamseth]

@Tim Hart 

Configure the ETL mapping to target the extended class directly (e.g., cmdb_ci_netgear, cmdb_ci_router, cmdb_ci_switch) instead of only cmdb_ci_hardware.

If the device type is determined dynamically:

• Create separate ETL Class Mappings per device type/class, or
• Use ETL transformation logic to route records to the correct target class before IRE processing.

Simply setting sys_class_name on a cmdb_ci_hardware mapping will not expose child-class attributes in the mapping UI.

Rule of thumb: If you need to populate child-class fields, the target ETL Class Mapping must be the child class itself.

[Tim Hart]

Hi @shubhamseth,

Thanks for your response. This is the Store App Service Graph Connector for Solarwinds. I take it the Solarwinds team would need to rearchitect their app.

I will look into using an alternative method of populating this data rather than having to remake my changes every version upgrade :$.

Thanks again!

[shubhamseth]

Agree with you @Tim Hart !