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

Highlighted
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads