CMDB IRE/ETL: Only allow updates, do not allow Creation of CIs

[Constantine Kr1]

Is it possible to only update a CMDB CI via the the Integration Hub ETL (Extract Transform Load) module?

I have a requirement where we want a data source to update configuration items, but we don't want it creating net new CIs. Doing this outside of the ETL module seems possible using the IRE API and some scripting, but I am trying to stay in the Integration Hub ETL module if possible. 

Thanks. 

[Viraj Hudlikar · Accepted solution]

Hello @Constantine Kr1 

Check this threads 

https://www.servicenow.com/community/developer-forum/integrationhub-how-to-prevent-a-record-from-bei...

https://www.servicenow.com/community/developer-forum/how-to-ignore-record-updates-part-of-integratio...

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Constantine Kr1]

Thanks for the response. We took the suggestion of preventing the record from updating in ETL, and did the following in regards to IRE: 

1. Created a new ETL Script transform that took the most pertinent fields for the identification of the CI
2. Used these fields to create an IRE JSON payload from scratch. Please see Identification Engine - Scoped 
3. Execute the IRE using the identifyCI(String jsonString) to simulate an IRE import.
4. Reviewed the result/output JSON object from identifyCI to determine if the operation was a create or update
5. Final output of the ETL Script / transform was whether the IRE was a flag with the values of Insert or Change
6. Used the flag to filter out all "Insert" values in the ETL mapping option.