Integration Hub ETL

[pratiksha5]

Hi, I am trying to load switch data from data source. The switch is getting inserted. Now I am trying to insert the switch port information. I added two classes one is switch and other one is switch port to create contains:: contained by relationship. When I am trying to load the data it is asking me insert the native key. I kept interface number as native key as it is the ID attribute for switchport.  It is not working correctly.  The data have similar interface number but the CI is changing. Please help

[Joe S1]

Hello,

Is your switchport SNK unique for each and every switchport you're bringing in? It must be a completely unique value, if it's unique to the switch itself and the switches are unique then you can do a concatenation of the switch name - switchport (i.e. switch123-ge0/12 then a different switch would be switch321-ge0/12) then use that as your SNK for the switchport record. 

[pratiksha5]

Sorry, I did not understand what you mean. What is SNK(serial number key)? In the switch port data source, I do not have the serial number. If I concatenate then how to use it in mapping? Presently it is inserting data in the table but it is keeping the interface number unique. If that interface number is in any other switch port it is erroring it out. 

[Joe S1 · Accepted solution]

Sorry,

SNK is your Source Native Key in the IH ETL world it's your "coalesce" value. Take a look at this article and see if it helps.

https://www.servicenow.com/community/developer-articles/integrationhub-etl-avoiding-ci-re-classifica...

You must have a unique SNK across all of your imports in order for the data to import correctly.

[pratiksha5]

Thank you so much 🙂