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

RK25 · ‎04-20-2023

Appreciate the steps. That helped a lot. I was able to perform all steps and now I have a column that returns true or false based on the device status. From here can you please help me how this column will be utilized whether a skip a retired record or not during the transform?

Joe S1 · ‎04-21-2023

Of course,

Now that you have a column where, for example, "retired = true" or "some other status = false" you can take that column and in your Step 3 where you're mapping to the CI class make it a Conditional Class where whatever the name of your true/false column is (i.e. "device_status") = false. This way any record that you're bringing in through the ETL where retired = true would be ignored and not updated.