Generate complex XML’s by pulling data from multiple related tables.

Four Stars

Generate complex XML’s by pulling data from multiple related tables.

 

Hi Team,

 

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.

 

Thanks, Jagadeesha


TALEND01_DATABASE_TABLES.PNGDatabase TableSAMPLE_XML.PNGExpected XML[Full XML Attached]

Four Stars

Re: Generate complex XML’s by pulling data from multiple related tables.

Hi Talend Team,
Greetings!!!
I also have similar question. I need solution to above post. Kindly help us. I wanted to fetch data in xml format from different related tables to any numbers.
Regards
Rohit