Connecting to a database cube that uses a MySQL database from PHP (using JDBC)

Question

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

I can not find how to do this. Can someone please help me with this as soon as possible?

White Paper: Creating Interactive OLAPApplications with MySQLEnterprise and Mondrian

Answer 1

Your best bet is to use Workbench Schema to create XML for your cube

Link

Download Schema Workbench

MySQL Jdbc Driver

In most cases, people get hung up on the desktop first, I highly recommend placing the mysql jdbc driver in the driver folder before using it. Thus, the application will be able to connect to your database as soon as you open it for the first time.

After you installed jdbc-driver-file.jar in the driver folder:

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

2 Go to Tools → Settings and configure the 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 → Create → MDX ​​Query

If you need a more beautiful view of your MDX request using jPivot, you can use the bi server for testing.