ReportServer Forum

jonas123

Member

Registered: 2020-12-08

Connecting to Mondrian Datasource

Hey All,

I stumbled upon a problem while creating a Mondrian datasource.
Im currently trying to create a Saiku report and for that im trying to add a mondrian Datasource, which looks like this:

name: test
username: <username>
password: <password>
URL: jdbc:mondrian:Jdbc=jdbc:mariadb://127.0.0.1:3307/test (jdbc:mariadb://127.0.0.1:3307/test gives me the same error)

Properties:
type=OLAP
name=test
driver=mondrian.olap4j.MondrianOlap4jDriver
jdbcDrivers=org.mariadb.jdbc.Driver
location=jdbc:mariadb://localhost:3307/test

The MariaDB Datasource settings are:
name: test
Database: MariaDB
Username: <username>
password: <password>
URL: jdbc:mariadb://127.0.0.1:3307/test

The connection to the used MariaDB Datasource is successfull according to the Test connection feature.
However if im trying to select the Mondrian Datasource in the Saiku report i still get an error saying :
"Could not connect to address=(host=localhost)(port=3307)(type=master) : (conn=85) Access denied for user 'Lokaler Dienst'@'localhost' (using password: NO)"
PS: The passwords are the same for both Datasources

Thanks in advance for your help.

Last edited by jonas123 (2020-12-08 16:35:24)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Connecting to Mondrian Datasource

Hi jonas123,

which reportserver version are you using exactly?

I tested with our test installation in the 3.3.0 version and this settings work:

jdbc:mondrian:Jdbc=jdbc:mariadb://IP:3306/DB

type=OLAP
name=
driver=mondrian.olap4j.MondrianOlap4jDriver
jdbcDrivers=org.mariadb.jdbc.Driver

we used a test cube based on the cube xml created by opening an existing pivot report -> export cube ->  Mondrian 4

Regards,
Eduardo