Data Transformation

Equipment

Source File

Netcool Output File (Netcool.xml)

 

Network Elements

XML Transformation NE (Juniper & Cisco)

 

Raw Data

         Example Juniper SRX550

DSE_MA~3_img1

DSE_MA~3_img2

DSE_MA~3_img3

DSE_MA~3_img4

 Example Cisco ASR-903

DSE_MA~3_img5

DSE_MA~3_img6

Transformed Json

 

ConnectMaster

Netcool

Linked System key

id

component category

Type from UnitaryComputerSystem TAG

component type

Model from chassis TAG

NE name

Name from UnitaryComputerSystem TAG

Description

Description from UnitaryComputerSystem TAG

Location

Name string extraction frist characters up to “- “

i.e., for “ABH-SRX550-0001” location is “ABH”

Juniper/Cisco

Manufacturer (needed for processing child elements)

Free Attributes

HWRevision

SerialNumber

Manufacturer

Signature