[Mondrian] Integrating with any other database

[Raja Nagendra Kumar]

Hi Will,

Thank you for the URL's.

Pl. let me know if my understanding is correct for the below stament.

'Mondrian can generally figure out the capabilities of the database from the 
JDBC driver, and generate SQL accordingly.'

All these done by mondrian by JDBC driver api which could tell more about 
sql support etc..

Are there any plans for Mondiran to use Hiberate or any other persistant 
layer to achive the database inpendence in future.. Not sure if this may 
have perf penality.. curious to know the road map.

Also, what if we would like to integrate to JDO complient database, where 
perf could be faster due to native java objects doing the work. Has any one 
done such integration in the past. if yes, I would appriciate any good 
references on such work.

Regards,
Nagendra

----- Original Message ----- 
From: "Will Gorman" <wgorman at pentaho.org>
To: "Mondrian developer mailing list" <mondrian at pentaho.org>
Sent: Saturday, June 09, 2007 8:23 AM
Subject: Re: [Mondrian] Integrating with any other database


> Hello Nagendra,
>
> Please take a look at the database compatibility section in Mondrian's
> Installation Guide:
>
> http://mondrian.pentaho.org/documentation/installation.php#7_Database_compatibility
>
> I hope this helps!
>
> Will
>
> On Sat, 2007-06-09 at 02:20 +0530, Raja Nagendra Kumar wrote:
>> Hi all,
>>
>> We are looking for a solution to let Mondrian provide OLAP Support for
>> the data which is stored in MySQL, Postgre or Cache
>> (http://www.intersystems.com/cache/).
>>
>> Could you pl. provide us few pointers on how easy is it for such
>> support.
>>
>> Do you use Hiberante or any JDO  kind of technology so that Mondrian
>> is agnostic about any database!
>>
>> or
>>
>> if I use proper JDBC driver, would that be enough for integration to
>> happen. Do you use any MSSQL specific SQL's are do these sql's
>> compatible with any RDBMS.
>>
>> We appreciate any inputs and roadmap details
>>
>> Regards,
>> Nagendra
>> Raja Nagendra
>> Kumar
>> Founder & C.T.O
>>
>> TejaSoft
>> Innovations Pvt
>> Ltd
>> 17C/17,
>> Sector-II, Nandi
>> Gardens
>> J.P Nagar 9th
>> Phase
>> Bangalore,
>> Karnataka 560062
>> India
>>
>>
>> Work:
>> +91-80-28436591
>> Mobile:
>> +91-9886723872
>> Email:
>> nagendra.raja at tejasoft.com
>> IM: Nagendra.Raja
>> (Skype or Yahoo)
>>  Professional
>> Profile
>> "When Teja is
>> tasked - The job
>> gets done!! "
>>
>>
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>