DDEX is a standard for data exchange in the music industry (http://www.ddex.net/)
It's a fairly complex XML standard or set of standards which involve creating hierarchical XML.
Are there any (opensource) tools to assist with doing this? Our data is already in a database, so some sort of ETL or reporting solution to create the file maybe?
We currently use Pentaho / Kettle / PDI - But i'm not sure this is necessarily the right tool in this case.
In the end we stuck with what we knew, and we implemented DSR reporting for DDEX in Kettle. Turns out the XML processing is fine, we did a bit of bodging with shell scripts but in hindsight there is a very powerful xml join step we could have used to do the same job.