Connecting to Database Cube that uses MySQL database from PHP (using JDBC)

Question

My database team has set up a database Cube using MySQL database. I need to connect to this Cube from PHP and get the data using MDX queries.

I can't find how to do that. Could someone please help me with this ASAP?

Reference document :- Creating Interactive OLAPApplications with MySQLEnterprise and Mondrian

Answer 1

Your best option is to use Schema workbench to create the XML for your Cube

Reference

Schema Workbench download

MySQL Jdbc Driver

Most of the time people get a little bit stuck at first using the workbench, i highly recommend that before you use it, put the mysql jdbc driver inside the driver folder. That way the application will be able to connect to your database as soon as you open it for the first time.

After you puted your jdbc-driver-file.jar inside the driver folder:

1- Execute Schema Workbench (.sh on unix/linux based systems)

2- Go to Tools -> Preferences and setup your connection string:

• driver class name: com.mysql.jdbc.Driver

• connection string: jdbc:mysql://serverlocation:port/database

• username: mysql user

• password: password

3- Go to File -> Open and open your cube

4- Go to File -> New -> MDX Query

If you want a prettier view of your MDX query using jPivot you can use the bi server for testing.