The CreatorCon Call for Content is officially open! Get started here.

How IRE engine works during Transform maps

Anshu_Anand_
Kilo Sage

Dear All,

Can anyone explain how IRE works during transform maps or does it not.

we have altiris intigration which populates cmdb tables by transform map and also servicenow discovery

populates it.

So we have lot of duplicates. Does transform map in integrations skip Identification rules?

 

Regards,

Anshu

Regards,
Anshu
6 REPLIES 6

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Pradeep,

Good evening. I have seen your blog provided in the URL.
Thanks for the brief information you have provided on how to apply IRE in Import Set/ Transform Map.
I am trying to create/update CI records (Linux server/ Windows server) through REST API on my instance. 
I have used a staging (Import Set) table where the data will be inserted first followed by creating those records in my target cmdb_ci table using a transform map.
I have used the OnBefore script in my Transform Script which you have mentioned in your blog.
But every time my ISET records are getting ignored.
Please refer to the attachments and help me understand what I am missing here.

Regards,
Narayan Saha

Priyanka138
Mega Expert

Hi Anshu,

How did you ended up doing the integration between Altiris and ServiceNow?

via JDBC data source type?

-Priyanka

1. I created an excel template and create a datasource and upload it with the fields i wanted

This created a temporary table like u_altiris_import

 

2. USE JDBC method to connect to Symantec database

 

3. Scheduled job with datasource insert  into the u_altris_import table.

4. instead of Transform map, i used integrationHUB ETL for this.

https://docs.servicenow.com/bundle/sandiego-servicenow-platform/page/product/configuration-managemen...

This is best as it automatically passes your CI data via IRE.

5. fields pulled out

*serial number

*name and other important fields

Hope its helpful

Regards,
Anshu