How to map data to alm_hardware table fields using Integration Hub ETL?

[Steve Stivers1]

I am building an integration using Integration Hub ETL. I need to map some of the data to fields in the alm_hardware table. How can I create mappings to this table? I only see tables under cmdb_ci.

[#2 · Accepted solution]

Steve,

The IntegrationHub ETL is a tool specifically designed for the CMDB use case and in particular sending data through the IRE to prevent duplication.  As such there is no out of the box way to map data to the alm_hardware table directly.

That being said, the alm_hardware table is kept in sync with the cmdb_hardware table through the Create Asset on Insert and Update Asset Field on Change business rules.  This means that if you create a mapping to the cmdb_ci_hardware table in the IntegrationHub ETL it will sync fields between cmdb_ci_hardware and alm_hardware.  Additional custom fields that are not synced automatically can be added to alm_asset_ci_field_mapping table.

Hopefully this helps you find a solution.

[Rahul Mishra1]

I could see they have allowed it for some non CMDB tables from Vancouver onward. Is there any OOB way that works for alm_hardware ?