How to Ignore Record Updates Part of IntegrationHUB ETL?

[RK25]

Hi,

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

Thanks!

[RK25]

Thanks for the response @Joe S1 . I am not bringing in the device status. I am not sure if I am doing this right. I did until the below however I can't check the retire status? Am I in the right path?

[Joe S1]

A Table Lookup is not going to work because you're going to need to lookup the device that you're bringing in and find the associated record in the CMDB. I would do it in a script operation that calls a script include, there you can pass in the name or serial of the device (whatever you have that's unique) do a query in the CMDB and find the device record to determine the status. Then return a true/false whether the device is retired or not.

[RK25]

I am little confused here. Can you please educate me on where I am going to create this script and where will it be called and determined whether to update the record in the CMDB or not?

[Joe S1 · Accepted solution]

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.

[RK25]

Thanks Joe. I will try that out.