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

Anonymous — Wed, 13 Dec 2017 09:33:00 GMT

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

Database TableExpected XML[Full XML Attached]

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

Anonymous — Thu, 14 Dec 2017 05:17:45 GMT

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

topic Re: Generate complex XML’s by pulling data from multiple related tables. in Talend Studio

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

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