IntegrationHub ETL - Class Mapping to Non-CMDB Tables

[BenzChua31]

Context: I'm trying to map fields/attributes to non-CMDB tables such as Location, User. But there isn't an option. The only non-CMDB table/class I can see is Group. 

What I'm trying to achieve:

I want IE-ETL to create Location records in the Location non-CMDB table. Then using class associations for relationship. 

Utah, latest release. IE-ETL latest version. 

What I've tried:

• I have mapped fields/attributes to Location attribute of Computer class. However, my Location table is empty so it is unable to lookup the matching record because the sys_id does not exist... Resulting in a blank cell. 

[pratiksha5 · Accepted solution]

Hi, can directly do it on the CI form. For example, you want to populate the location of a given server. You can do script transform for cmn_location. If location is present you can take that value or else create a new one. 

Check this https://www.servicenow.com/community/cmdb-forum/quot-efficiently-importing-data-into-main-and-relate...

[pratiksha5 · Accepted solution]

Hi, can directly do it on the CI form. For example, you want to populate the location of a given server. You can do script transform for cmn_location. If location is present you can take that value or else create a new one. 

Check this https://www.servicenow.com/community/cmdb-forum/quot-efficiently-importing-data-into-main-and-relate...

[BenzChua31]

Hi Pratiksha5, 

Thank you for the post. I found my answer in the comment section. It appears someone had addressed my doubts with creating a Location record in the Transform Script (Before IRE) and you mentioned:

"The core_company  record is not directly linked to the CI. They are linked to product models. Product models are directly linked to CI. So it is like I have a core company Arista Networks, which have let's say 22 models and each model may or may not have a CI associated with it. OOB service now just provide few models and manufacturer's and not all of them are linked to any particular CI. Only when you discover or import any related CI, then they will be linked to the models or manufacture. So even if it CI is ignored it wont do any harm. I hope this helps. "

[BenzChua31]

Hi Pratiksha5,

It would be lovely if you could also review this question: IntegrationHub ETL - 1-M Relations to JSON Objects... - ServiceNow Community

Your post does not highlight a method to map multiple CIs in an array under a field/column. 

[pratiksha5 · Accepted solution]

Hi @BenzChua31 

Please check my new article https://www.servicenow.com/community/cmdb-forum/insert-data-in-non-cmdb-table-using-ih-etl/td-p/2619...