[CALUG] mssql oracle

[Bruce F Press]

william kelly wrote:

>I am looking for a solution to build reports via jasper reports that queries
>both oracle and mssql in a single query. i am unable to locate a single
>query that would allow data to be aggregated from both. any ideas? also im
>trying to use ireport to build my report.
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: http://calug.com/pipermail/lug/attachments/20060214/de12a85b/attachment.html 
>_______________________________________________
>Columbia, Maryland Linux User's Group (CALUG) mailing list
>CALUG Website: http://www.calug.com
>Email postings to: lug at calug.com
>Change your list subscription options: http://calug.com/mailman/listinfo/lug
>  
>
There are commercial products to do this, but they aren't inexpensive. 
The general
class of functionality you are referring to is called "Federated Query".
A couple of
starting points for commercial products would be MetaMatrix, BEA
Aqualogic Data Services
and Sybase Avaki.
'
Other wise, I think the suggestion of aggregating the results using a
scripting language
makes good cost sense.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: bpress.vcf
Type: text/x-vcard
Size: 292 bytes
Desc: not available
Url : http://calug.com/pipermail/lug/attachments/20060215/4d5eb5cc/attachment.vcf