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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.