Menu
Download Free Trial

What should be connection string to connect to Pentaho Mondrian using Data Speed Accelerator?

I’m trying to connect to Pentaho Mondrian as described here: 
http://www.flexmonster.com/docs/#page=howto-connect-proxy-mondrian.html
It describes an example of connection string for Pentaho Mondrian. I have a few questions:
1. Where should I take this connection string? Do I understand correctly, that there is some database of Pentaho Mondrian that stores the information about cubes and that it should be specified in the connection string? Where it can be found in Pentaho Mondrian?
2. Should I put the schema xml file in the Flexmonster server folder? Or it should be found automatically in the depths of Pentaho Mondrian?

4 answers

Public
Iryna Kulchytska Flexmonster April 12, 2016

Hi Alexey,
 
Thank you for posting your questions. Please find the answers below.

  1. 1. You understand correctly, that there is some database of Pentaho Mondrian that stores the information about cubes and that it should be specified in the connection string. The connection string can be taken from web.xml in your Pentaho Mondrian. Please search for <param-name>connectString</param-name> in web.xml, the string in <param-value> tag will be your connection string.
  2. 2. There are two options here. You can put the schema XML file in the Flexmonster server folder and leave CATALOGS_PATH=./ in flexmonster.config. Or you can change CATALOGS_PATH in flexmonster.config to the folder where the schema XML file is.

 
Please let me know if the answers were helpful.
 
King regards,
Iryna

Public
Alexey A. April 12, 2016

Ira, thanks! We have Pentaho BI Server. It is assumed that Mondrian is embedded. Which one web.xml do you mean? The one that is located here: biserver-ce\tomcat\webapps\pentaho\WEB-INF\web.xml? There is no “connectString” in this file.

Public
Iryna Kulchytska Flexmonster April 12, 2016

Alexey,
 
Could you please check my previous answer? <param-name>connectString</param-name> and <param-value> tags were removed from it after the edit.
 
If you do not have <param-name>connectString</param-name> and <param-value> in web.xml, please check the following documentation that might be helpful:
http://mondrian.pentaho.com/documentation/configuration.php#Connect_strings
http://wiki.pentaho.com/display/ServerDoc2x/01.+Setting+Up+Your+Database+Connections
 
Kind  regards,
Iryna

Public
Alexey A. April 13, 2016

Thanks! The problem is solved.

This question is now closed