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?
Thank you for posting your questions. Please find the answers below.
- 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. 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.
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.
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:
Thanks! The problem is solved.
This question is now closed