Data Precedence Rules

[Rachana Vulli]

I created 2 Data Sources on Server class. Created Reconciliation Rules for the discovery source with one having High priority and the other with low priority but the records are being updated by low Priority Data/Discovery source as well which shouldn't happen in our case.

I also see that there are no records being created in 'cmdb_datasource_last_update' table which might be the cause.

How the records should get created in that table for every data source run.

Also, if that's not the cause, what might be the issue and how to resolve it

Thanks,

Rachana

[CMDB Whisperer]

All CMDB data sources should use IRE for it to work correctly.  As mentioned in my earlier comment, can use either the IRE APIs in your transform scripts (old school method) or use the IntegrationHub-ETL application (newer method).

[Rachana Vulli]

Hi,

Thanks for responding. Have few doubts as mentioned below

1. But is it possible to use IntegrationHub-ETL application for new Data Sources and leave the existing ones AS-IS?

Also, what can be the Spoke for Data Source Type=JDBC?

2. If we want to use IRE APIs in Transform Scripts, how to achieve Data Precedence? What changes should be made in Transform Scripts??

Thanks,

Rachana

[CMDB Whisperer]

1.  Is it possible?  Yes.  Is it recommended?  Not unless you are using some other method to use the IRE.  For IRE and multi-source processing to work correctly, all data sources need to be going through the IRE.  That said, it is not your data source itself that needs to change to use IH-ETL, you can leave your existing data sources intact, and merely disable the existing transform maps (no need to delete them per se).  Your existing data sources can be brought into the IH-ETL application without any modifications.

2.  If you use the IRE APIs in Transform Scripts that is still acceptable, although the IH-ETL capabilities far surpass this method.  As long as all of your data sources are using some method of going through IRE and your transform maps are sound, your Reconciliation Rules should work as expected.

[Rachana Vulli]

Hi,

Thanks for this.

I used old IRE APIs method and added onBefore Transform Script but found an issue.

Issue: On first run/load Data, it is not inserting records in cmdb_datasource_last_update table but on Reprocess, it is inserting the data.

What might be the issue and how to resolve it?

Thanks,

Rachana

[Rachana Vulli]

Solution: Need to create Data Refresh Rules for Data Source Histories to be inserted on First Run.