Insert data in non-cmdb table using IH ETL
Starting from the Utah release, IRE now provides support for certain non-CMDB tables. To utilize all IRE features with these tables, you must first establish identification rules (CI identifiers and identifier entries) specific to those tables. The non-CMDB tables that are supported for IRE features encompass the following:
In an application-specific scope: All non-CMDB tables are supported.
In the global scope: Only non-CMDB tables that come pre-configured in the base system are supported. For instance, in the Utah release, the supported non-CMDB tables include Location [cmn_location], Department [cmn_department], Cost Center [cmn_cost_center], Building [cmn_building], User [sys_user], and Group [sys_user_group].
I am sharing one example of how you can do that. Let’s take example of location table.
Step one : - Create an identifier for the location table
Step two : - Create identifier entry for above identifier.
Step three: Your table is ready for insert.
Don't forgot to make my article Helpful
Hello @pratiksha5
this is how I created my identifier :
I've done the same configuration in my personal developer instance and it works just fine, but in our dev instance, I can select the user table as a class in integrationHub ETL, but I cannot activate the mapping.
from the documentation is it written :
An associated class lets you select the CMDB class to be associated with a target non-CMDB table. Setting an associated class is required for IRE processing if the non-CMDB table is not configured for IRE processing.
I don't understand what is meant here by "if the non-CMDB table is not configured for IRE processing."
And where should I look to find out if it is properly configured or not?
