How to update the alm_hardware table from Integration Hub ETL

[Erick18]

I am building a new import using IntegrationHub ETL and am wanting to update asset related fields as part of the transform map. These fields currently do not exist on the CI record and I don't want to have to create custom fields on the CI to populate them. Is there any way to update a CI's related asset record using Integration Hub ETL? I even tried updating the Robust Transform map manually however that didn't work either. 

Thanks,

Erick

[Martin Grosskop]

Hello Erick,

As far as I Know you cannot update non-CI records using IntegrationHub ETL at present, as it only works on CIs.

But it is my understanding that in Utah, IntegrationHub ETL will be able to run on non-CMDB tables.

[Martin Grosskop]

Looks like alm_hardware, being in the Global scope, cannot be updated by the new IRE/IH-ETL in Utah:

[Erick18 · Accepted solution]

I ended up creating a execute after script on the cmdb_inst_application_feed record for my IHUB ETL data source. The script does a glide record lookup on the asset table and updates each record.