We have a requirement to sync cmdb from one servicenow instance to another using FDS. We have configured up till FDS request creation and sending sample data from provider to consumer.
Next step is to map the inbound data using ETL transform. In this we are facing issue while mapping the key value table to the cmdb tables. As key value is a standalone table it does not give an option to use ETL or transform map on the subscription item on consumer instance. however when we add an IRE to the cmdb tables for cmdb_key_value table we get an option to configure a lookup on that particular table (say cmdb_ci_group) using the key value table. how do I get the related key value data in the particular cmdb table through same offering item. As there is no direct relation between the cmdb table and key value table. Refer screenshots below for better understanding
below is cmdb_key_value table subscription item without any transforming option. How do we get the data recieved in this table and map it to the other cmdb table data as above.
