Posted by VBerget on Jan 11, 2011; 9:18am
URL: https://discuss.orbeon.com/How-to-extract-data-from-Orbeon-database-for-reports-tp3206331p3208656.html

Erik Bruchez wrote

We have an Oracle XML persistence layer:

  http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/oracle-persistence-layer

Data is stored as XML into fixed tables, but you could create Oracle
relational views for your reporting tool.

-Erik

As somenone mentioned, we are indeed using Form Runner (and Oracle).

If I understand you correctly we can use the Oracle XML Persistance Layer and then use something like XMLTable in Oracle to create relational views on the same data?
That sounds like a good strategy to me, seems I need to study XMLTable more in detail

- Vidar