[CALUG] mssql oracle
Bruce F Press
bpress at raba.com
Wed Feb 15 10:09:49 CST 2006
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...
>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.
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
makes good cost sense.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 292 bytes
Desc: not available
Url : http://calug.com/pipermail/lug/attachments/20060215/4d5eb5cc/attachment.vcf
More information about the lug