Sun Aug 14, 2022 4:09 am
Login Register Lost Password? Contact Us

Please Note: The HPCC Systems forums are moving to Stack Overflow. We invite you to post your questions on Stack Overflow utilizing the tag hpcc-ecl (https://stackoverflow.com/search?tab=newest&q=hpcc-ecl). This legacy forum will be active and monitored during our transition to Stack Overflow but will become read only beginning September 1, 2022.



Do HPCC JDBC driver supports Mondrian?

Topics around the use of the JDBC driver for HPCC Systems

Tue Feb 12, 2013 11:39 am Change Time Zone

Hi,

I'm trying to use Mondrian and connect it with our HPCC cluster but not able to find a proper place to give the connection string.

Currently i'm using Mondrian-3.3.0.14703.
Have anyone tried with Mondrian??

Thanks,
Apurv
Apurv.Khare
 
Posts: 30
Joined: Fri Jan 06, 2012 1:30 pm

Tue Feb 12, 2013 2:49 pm Change Time Zone

What UI are you using Mondrian with? JPivot/Saiku/Pentaho etc..
mnaweed
 
Posts: 9
Joined: Tue Feb 12, 2013 2:48 pm

Wed Feb 13, 2013 12:11 pm Change Time Zone

I'm new to Mondrian, i have just mondrian zip file.
I tried the In built MS-Access database it worked with jPivot tables it shows me data and some graphs.

I want to connect Mondrian with HPCC.I dont know about Jpivot or Pentaho.
Apurv.Khare
 
Posts: 30
Joined: Fri Jan 06, 2012 1:30 pm

Wed Feb 13, 2013 2:33 pm Change Time Zone

1.Download the HPCC JDBC Driver from:
http://hpccsystems.com/products-and-ser ... DBC-Driver

2.Read the documenation, it has the details on defining the connection string.
mnaweed
 
Posts: 9
Joined: Tue Feb 12, 2013 2:48 pm

Wed Feb 13, 2013 2:54 pm Change Time Zone

The Connection string that we use is defined as follows:

driver=org.hpccsystems.jdbcdriver.HPCCDriver
location=jdbc:mondrian:Jdbc=jdbc:hpcc:ServerAddress=xxx.xxx.xxx:Cluster=default:WsECLDirectPort=8008:EclResultLimit=100:ReadTimeoutMilli=30000:QuerySet=thor:LazyLoad=false:PageSize=100:TraceLevel=ALL;Catalog=res:HPCC/Schema.xml;
username=
password=
mnaweed
 
Posts: 9
Joined: Tue Feb 12, 2013 2:48 pm


Return to Java Tools

Who is online

Users browsing this forum: No registered users and 1 guest

cron