IntegrationHUB ETL with XML file

[Amar_Be]

HI,

I've to integrate a XML data file into the CMDB using the # IntegrationHUB ETL

The file has the following structure :

<environment>

    <Servers>
       <app>
          <EnvironmentName>DEV</EnvironmentName>
          <ServerName>SERVERSAAA</ServerName>
          <applogicalName>App_AAA</applogicalName>
          <appname>App AAA Name</appname>
          <BigIPs>
             <BigIP>BIGIP06</BigIP>
             <BigIP>BIGIP07</BigIP>
          </BigIPs>
          <ApplicationServer>TOMCAT</ApplicationServer>
          <ASVersion>8.5</ASVersion>
          <Sources>
             <source>SourceB3L</source>
             <source>SourceB2H</source>
          </Sources>
          <appPort>21115</appPort>
       </app>
    </Servers>
</environment>

If in the Data Source, I give the following XPATH :     /environment/Servers/app/

Then the elements Sources and BigIPs are imported as xml :

My questions is : How can I do to integrate my XML file into the CMDB using IntegrationHUB ETL?

Is it there a special XPATH syntax that can tell the data source to import each "Source" and each "BIGIP" as a new line of data or do I have to loop on the content of the fields BigIPs and Sources into the IHETL transformations to extract the values BIGIP06 & BIGIP07 ? In this case how to do it?

Thank you for your help.

I suppose that I'm not the first one who's trying to import a XML file into the CMDB 😅