[Mondrian] Define multiple JDBC connections under a Mondrian schema
ricardo.fradinho at webdetails.pt
Mon Mar 21 10:08:41 EDT 2016
Please share/blog your findings using the virtual layer.
I¹m skeptical that we¹ll get a decent performance as Mondrian generates sql
statements using fact and dimensions in the same statement, e.g.,
Select from Fact F join Dimension D where
which is hard to optimize by the virtual layer
However, maybe there¹s some opportunities there (like using sub selects),
so getting feedback is welcome.
From: <mondrian-bounces at pentaho.org> on behalf of kevin melo
<kevinmelo92 at gmail.com>
Reply-To: Mondrian developer mailing list <mondrian at pentaho.org>
Date: Monday, March 21, 2016 at 1:57 PM
To: Mondrian developer mailing list <mondrian at pentaho.org>
Subject: Re: [Mondrian] Define multiple JDBC connections under a Mondrian
2016-03-21 10:52 GMT-03:00 Tom Barber <tom at analytical-labs.com>:
> Technically no, there is multi schema support but no multidatabase support.
> One technique we were discussing on the Saiku ML was using something like
> Apache Drill to add a layer over the top of the two target DB's to create a
> pseudo DB that will allow you to interact with them seamlessly.
> Director Meteorite.bi - Saiku Analytics Founder
> Tel: +44(0)5603641316 <tel:%2B44%280%295603641316>
> (Thanks to the Saiku community we reached our Kickstart
> -designer/> goal, but you can always help by sponsoring the project
> <http://www.meteorite.bi/products/saiku/sponsorship> )
> On 21 March 2016 at 13:49, kevin melo <kevinmelo92 at gmail.com> wrote:
>> Is there any way to create connections with other banks by Mondrian?
>> I have a default connection, and i want to access a dimension in other
>> Mondrian mailing list
>> Mondrian at pentaho.org
> Mondrian mailing list
> Mondrian at pentaho.org
_______________________________________________ Mondrian mailing list
Mondrian at pentaho.org http://lists.pentaho.org/mailman/listinfo/mondrian
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian