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: 
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

Iryna Kulchytska Staff 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,

CapObvs 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.

Iryna Kulchytska Staff April 12, 2016

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:
Kind  regards,

CapObvs April 13, 2016

Thanks! The problem is solved.

This question is now closed