Drop the following components from the Palette onto the design workspace: tMysqlInput, tExtractXMLField,
Connect the three components using Main links.
Double-click tMysqlInput to display its
Basic settings view and define its
If you have already stored the input schema in the Repository tree view, select Repository first from the Property
Type list and then from the Schema list to display the Repository
Content dialog box where you can select the relevant metadata.
For more information about storing schema metadata in the Repository tree view, see Talend Studio User Guide.If you have not stored the input schema locally, select Built-in in the Property Type and Schema fields and enter the database connection and the data structure information manually. For more information about tMysqlInput properties, see tmysqlinput_c.html.
In the Table Name field, enter the name of
the table holding the XML data, customerdetails in this
Click Guess Query to display the query corresponding to your schema.
- Double-click tExtractXMLField to display its Basic settings view and define its properties.
Click Sync columns to retrieve the schema
from the preceding component. You can click the [...] button next to
Edit schema to view/modify the
The Column field in the Mapping table will be automatically populated with the defined schema.
In the Xml field list,
select the column from which you want to extract the XML data. In this example, the
field holding the XML data is called CustomerDetails.
In the Loop XPath query field, enter the node of the XML tree on which to loop to retrieve data.In the Xpath query column, enter between inverted commas the node of the XML field holding the data you want to extract, CustomerName in this example.
Double-click tFileOutputDelimited to display
its Basic settings view and define its
In the File Name field, define or browse to
the path of the output file you want to write the extracted data in.
Click Sync columns to retrieve the schema from the preceding component. If needed, click the [...] button next to Edit schema to view the schema.
- Save your Job and click F6 to execute it.
tExtractXMLField read and extracted the clients names
under the node
CustomerName of the CustomerDetails
field of the defined database table.