Hi Team,
I wanted to clarify doubts on IntegrationHub ETL.
I have create a Data source(Type : JDBC) in servicenow and i wanted to create an integration with solarwinds from servicenow INtegrationHub ETL .
1.Can we use multiple data source to create integration with solarwinds
if yes then please guide me how to use multiple data source for one integration with solarwinds or do we need to create 3 different ETL Transform Map if we have 3 data sources for solarwinds?
2. please clarify 3rd step in ET< Transform Map (Targeting class using conditional class option in Servicenow CMDB)
Map Data to CMDB and Add Relationships
I have a scenario like , custom form contains data and value , whenever the data matches from source i need to fetch the value from custom table at run time . IS it possible to refer custom table in this 3rd step to fetch the data for target class ?
Example: Machine Type = 'a'
if machine type in custom table matches 'a' then the value (value = windows server) should be the target class.
Consider custom table contains 100+ records for example .
please guide me how or where we can write a script or condition to make this requirements work .
Thank you.
Hi Tamilselvan,
1. In answer to your first point, I'm not sure if you can do multi data sources with a Solarwinds integration. You can however create one ETL and use the same ETL for all three data sources. The key there is that all three data sources need to use the same import set table.
2. You can create a script include to determine the Class of the device based on an input column (i.e. Machine type). Then in your ETL create a new Transform Script Operation to call that script include and pass the input column over then return the class back to the ETL. Then in your mapping you can map to the Hardware class but set the class for the individual devices based on the output of the script include by mapping Class to the sys_class_name value.
Example script include:
