How to check the target CI data using IntegrationHub ETL?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 04:35 AM
Hello,
We have implemented a Service Graph Connector integration in CMDB and have a requirement to set the 'Environment' field value to 'Production' only while inserting/creating the record. Later if the 'Environment' field value is manually updated, the value should not get overwritten by the ETL mapping.
Can you please let us know how to achieve this functionality?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 06:11 AM
You can add a Reconciliation Rule for Manual Entry with higher priority and a lower priority for the integration for the attribute you want.
CI Class Manager > Reconciliation Rule> Create Reconciliation Rule
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 11:37 PM
Hey Joby,
Thanks for the reply. I Agree, we can use reconciliation rule, but I think the question is more about - how do we check the CI target field value and then update the corresponding value via ETL.
Essentially, what we could do in transform maps using an 'on before' script with target. XXX [fieldname].
Please let me know if you have any insights
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2025 05:28 AM
Yes I agree, in your specific case, BRs would make more sense since you need to check the field values.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2025 08:41 AM
I would still suggest using the reconciliation rule and giving high priority to manual entries. For instance, if you manually create a CI, it will update correctly because manual entries have been given high priority for that field. If a CI does not exist, any other source will still be able to create it. I'm not sure why you would want to write a Business Rule (BR); IRE will handle source precedence.