Setting up and executing the Job - 7.3

XML connectors
Version
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > XML components > XML connectors
Data Quality and Preparation > Third-party systems > XML components > XML connectors
Design and Development > Third-party systems > XML components > XML connectors
Last publication date
2023-06-12

Procedure

  1. Open the Basic settings view of the tFileInputXML component by double-clicking the component and specify the following properties:
    1. Click the [...] button next to Edit schema to define the schema for this component and then click Yes to propagate the schema and close the schema editor.
      In this example, the input file has three columns: City, District, and Street, which are all set as String data type. The following figure shows the columns added for the schema.

      The columns appears in the Column field of the Mapping table.

    2. Enter the path to the areas.xml file ("D:/obs/areas.xml" in this example) in the File name/Stream field.
      You can also enter the file path by clicking the [...] button to the right of this field and navigating to the areas.xml file.
    3. Enter the XPath of the street element of the areas.xml in the Loop XPath query field ("/areas/area/street" in this example).
    4. Enter the XPaths of the city and district attributes and the XPath of the street node of the areas.xml file in the XPath query column of the Mapping table, as shown in the following figure.
    5. Leave the other options as they are.
  2. Open the Basic settings view of the tLogRow component by double-clicking the component and select Table (print values in cells of a table).
  3. Save your Job and press F6 to execute it.

Results

The city, district, and street values are extracted from the XML file and displayed on the console.