With a generic data virtualization tool, it's also possible to query a relational database via XQuery and build aggregated, hierarchical XML directly. It can provide a reliable platform and decrease the complexity of the data aggregation. At the time we worked on these projects, I was not aware of this option.