Model ID Population using IH-ETL

[diegobermudez]

Hi Community,

I´m building my first CMDB Integration from an external data source and having problems to populate Model Id Information of the CIs. 

I´m using Integration Hub ETL to populate data into several classess of the CMDB and I want to populate Model ID information into the CIs. I have seen there is an OOTB transformation available to perform the creation and Cleanse of the software models (Cleanse Software Model) that is documented in the "Integration Commons for CMDB (2.14.2)" and I have used it as this in my ETL:

So, now I have a column modelId available to map to the class of the CMDB... 

I have no idea on how I can use this transformation to map to the CMDB Class, the documentation says it creates the software model registry but I can´t see it "cmdb_model" and can´t figure out how can I map this column to populate manufacturer and model id  in the CI.

Can someone help me on how can I perform this Model ID population using IH-ETL and not having to create Models manually before this ETL?

Thanks a lot experts!!!

[scottl]

Did you find a solution to this, as it creates the records on the hardware product table but when mapping it to Model ID is fails to set the value on the new CI record. 

Any clues?

[diegobermudez]

Hi,

Yes, for hardware, i can use it succesfully, using Cleanse Hardware Model, it returns an column with: Manufacturer.sys_id|||Manufacturer.name|||ModelID.sys_id|||ModelID.name, with another split transformation i got the columns separated and use the ModelID.sys_id to map to the Model Id of the CIs.

The problem is the Cleanse SOFTWARE model, doesn´t work equal. It doesn´t give you the Model.sys_id and cannot use it for mapping

[Damhoej]

It does not work in Yokohama patch 3.

I am trying to get Model ID imported from a CSV file where Model ID is a value (like Windows Virtual Server), but no matter what I do it ignores the field when importing.