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]

1 REPLY
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