Field Not Updating in Target Table| Robust Transform Map| SG-SCCM Integration

[Sai_Tarun]

Hi All,

We have Integrated with SCCM using Service Graph Connector. Target Table is Computer.

Based on one of the fields in staging table (Computer Identity Data Source), I have to update another field in target table. We are using Robust Transform Map in order to transform the data here.

• I have written Entity operation script for the same and I can see the data in ETL Integration hub. 
• When I do the data load using import schedule, The Field in the Target table is not getting updated.
• I have made sure that.
  • Field Mapping is done properly.
  • Script written properly.
  • No Errors in the logs.
  • No server script is suspicious.
  • Use last run datetime is false in data source.

Not sure why this field is not getting updated. Please let me know if any other things I have to verify in order to resolve this issue.

[Appanna M]

Hello @Sai_Tarun ,

What is the target field that is not updating? 

Is it through field mapping or script? 

you can paste your Sample script for better assistance. 

[luffy3478]

Install IntegrationHub ETL store app and debug

[IbrahimK4837164]

Ensure that the field mappings between the source and target tables are correctly configured, check that the entity operation script is written correctly and ensure that it performs the necessary field update operations, check if there have been any changes in the data structure that could affect the field update in target table, ensure that the source and target SCCM Service Graph Connector connection settings are configured correctly and that data access is configured correctly; After completing these steps, restart the data loading process and check if the target field in the Computer table is updated.

[Sai_Tarun · Accepted solution]

Hi All,

I have an update on the same.

• Somehow after doing data load again, RTE worked, and field got updated as expected.
• I have modified the field in staging table and did transform once again for that particular import set. I have observed no update in the field in target table.
• I have deleted respective records from sys_object_source table and did transform once again and boom, the field got updated in target table.
  • The sys_object_source field is a reference field that points to the sys_object_source table, which contains information about the data sources that are integrated with ServiceNow.
  • The sys_object_source field is used to track the origin of the data that is imported or updated in the CMDB. It is also used to prevent duplicate records from being created by different data sources.
  • The IRE module uses the sys_object_source field as one of the criteria for identifying and reconciling data from different data sources.
  • The IRE module has a set of predefined identification rules that define how to match data from different sources based on certain attributes, such as name, serial number, MAC address, etc. The identification rules also specify which source has the highest priority or authority for updating the data in the CMDB.