Integration hub ETL mapping Records not updated for few attributes.

Deep Singh
Tera Contributor

We are experiencing an issue with our Integration Hub ETL mapping where the  Vendor fields are not being populated .

DeepSingh_0-1741618102413.png

 

The vendor field is mapped to its correct source on the ETL mapping 

DeepSingh_1-1741618147539.png

When I delete all my records on the table and insert it , the field values shows but I cannot delete the existing data.   When I try to update with a new data source or imports, then some of the fields value does not get updated and shows as empty even though that field have values on them. 

Any help will be appreciated.

2 REPLIES 2

Kieran Anson
Kilo Patron

This could be a couple of things

 

1. Reconciliation Rule - Your data source isn't allowed to overwrite the field. 

2. Source Recency - ServiceNow won't attempt to update a record if it's had data passed with a more recent timestamp. I don't think it's this option as your ETL mapping doesn't have source recency timestamp populated.

 

Have you checked on whether cmdb_ci_spkg as any reconciliation rules for your discovery source? 

Hello Kieran, Thank you for your response.

1)  I do see there are three Reconciliation rules but they are not tied to the vendor field not showing because I deactivated to try and the vendor field still showed empty.

DeepSingh_0-1741813795506.png

Source Recency we do not have anything mapped 

 

Thank you