IntegrationHUB ETL is creating duplicates

[victor21]

Hi Listers,

I am trying to use IntegrationHUB ETL - Import application to load some data into the CMDB from an Excel file. I see that when I run the Import multiple times I get duplicates in the CMDB - seems the application is not using IRE as documented. I enabled IRE logging but did not get any entry.

Can someone enlighten me unto what I am doing wrong or how to debug?

Thanks & regards,

Victor

[pratiksha5]

Hi Victor can you share a screenshot of the ETL you have created. 

You can also check article https://www.servicenow.com/community/cmdb-forum/quot-efficiently-importing-data-into-main-and-relate...

[victor21]

Hi Pratiksha,

I have created the ETL from IntegrationHUB - Import wizard, nothing fanciful just 3 records with two fields (name, serial_number) to be loaded to cmdb_ci_computer class. The records are getting loaded to the class only the IRE is not used.

As a result I get the same entries repeatedly loaded to the Computer class instead of updating.

I turned on IRE logging but did not get any log - which is probably indicating that IRE is not being used.   

[Ashok Sasidhara]

What is the identification rule currently configured for Computer class? Is it the OOB one or was it changed? 

[victor21]

It's OOTB - this is on my PDI

[pratiksha5 · Accepted solution]

HI Victor,

I think you are not using the correct integration hub ETL. 

This is the integration hub (above image)

You need to use the one under configuration. 

Let me know if it helps.