Orbeon Forms community mailing list - Re: Re: How to extract data from Orbeon database for reports?

Re: Re: How to extract data from Orbeon database for reports?

Posted by Erik Bruchez on Jan 13, 2011; 9:54pm
URL: https://discuss.orbeon.com/How-to-extract-data-from-Orbeon-database-for-reports-tp3206331p3216764.html

Vidar,

I am not sure exactly how you create such a view, but I am positive we
have done this in the past! Oracle even has materialized views which
might improve performance: http://goo.gl/Z7Je

-Erik

On Tue, Jan 11, 2011 at 1:18 AM, VBerget <[hidden email]> wrote:

>
>
> 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
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/How-to-extract-data-from-Orbeon-database-for-reports-tp3206331p3208656.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws