We are using “TALEND Data Integration” tool. The requirement we have is to generate complex multi-level XML’s from relational database [Multiple related tables].
Until now we create a JOB and have used tAdvancedFileOutputXML componenet for XML creation and tMSSqlInput component to connect to SQL Server database.
With single table and simple join the XML is coming up fine [2 tables].
However we are struck while trying to generate XML from more than 2 tables. Here are the sample table structure and expected XML document.
Please let us know how to design this in TALEND Data integration or any other TALEND tool.