How to Ignore Record Updates Part of IntegrationHUB ETL?

RK25 · ‎04-20-2023

Hi,

I am trying to ignore updates to retired records part of the IntegrationHUB ETL. Is there an easy way to do it?

Thanks!

Joe S1 · ‎04-20-2023

Sure,

In your ETL you're going to create a New Transform and choose Use Source Column

From there you're going to choose Script Operation, and you're going to need to pass in one of the columns you're bringing in, such as 'device name' so that you have a value to do a query with against the CMDB. You'll give it an Output Column name that you'll use in the ETL Mapping.

Then in your script you're going to call a Script Include that you'll need to create that will take the 'device name' and do a lookup in the CMDB to determine the device status. With the status you can return a value of 'true' if it's retired, otherwise return 'false' from the script include. Your script should look something similar to this.

View solution in original post

Joe S1 · ‎04-20-2023

Hello RK,

Are you bringing in the device status as part of your ETL mapping? If so, then you would just need to make your CI Class mapping (Step 3) conditional where status != retired. If you're not bringing in the device status you're going to have to do a lookup in the Preview and Prepare Data (Step 2) to determine if the device is in a retired state then you can set an output variable to true/false. With that you can make the class conditional in the Class Mapping (Step 3)

Rowella Montell · ‎06-14-2023

Hi @Joe S1 I do have a similar issue with RK atm except that we do both insert of new record and update if record is existing. I did the same instructions above and it does work of not updating the records that does not match the values I set e.g. if u_serial_number is True and u_ci_class is Software. However by doing so it also skips creating new record. We still need to be able to create new records using the same ETL if the name is not existing (does not match) and serial number is false then it should still create new record. How do I do that?

Joe S1 · ‎06-14-2023

@Rowella Montell

Sounds like a possible problem with your conditional class, what are the conditions that you have set on the class you're mapping to in Step 3?

Rowella Montell · ‎06-14-2023

Hi @Joe S1,

Please see below screenshot I have for my condition in PDI.