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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend