SG/ETL/Robust import set transforms

[Amber Kearn]

Hello. Could you please provide an answer to the below: 

The SCCM Service Graph connector has been working well, but the only issue that we have with it is that we have one specific field that is not blanking out the corresponding field on the server table, even though the data being imported has that field as empty. We thought to create a Business Rule to go in and check the Import data on the staging table and then empty the field on the corresponding server record, and we verified the script worked but that it wasn’t running because, by design, Import tables do not allow business rules to run. If this was a normal Import set that uses a transform map then there is an option to allow business rules, but I am not seeing that for SG/ETL/Robust import set transforms.

[Prabu Velayutha · Accepted solution]

Hello @Amber Kearn 

If you have want the data source to update the empty value then you should try the Reconciliation definition and set update null value for that attribute, that should work, all the SG connector uses IRE before ingesting data to CMDB applies the respective CI class or parent class identifiers and reconciliation rules.

Please find the steps and reference screenshot below:

Configuration -> Reconciliation -> Reconciliation Definition:

Create the Reconciliation for SG-SCCM data source and select the attribute that can be updated with null value as shown in the screenshot below also make sure to set the priority order to low so that it can take higher precedence compared to other data sources.

If my answer helped, please mark helpful and correct. Kindly revert if you have any questions.

[John Brown2]

This does not work. The reconciliation definition doesn't seem to have any effect on empty fields in the import.