Get Free Trial

Regarding connection of flexmonster with MySQL

akash gupta asked on September 19, 2017

Suppose i have data around 150GB in mysql how can i connect it to flexmonster (considering i have a premium account :P).
Also can i provide data to flexmonster via API .
Please help.

5 answers

Tanya Gryshko Tanya Gryshko Flexmonster September 20, 2017

Hello, Akash,
Thank you for the interest on our component. Flexmonster is a client-side solution which stores all the data in the browser. Here is why the amount of data you mentioned exceeds the browser capabilities. Our recommended approach is to try pre-filtering of the data on the server side and then passing it to the component. For more details please refer to the following article: How to achieve the best performance.
As about how to connect your data to Flexmonster, you can connect to MySQL database via our special server-side compression tool called Flexmonster Data Compressor. It is available for different technologies. Please find the list of technologies and setup tutorials in our documentation. After compressing the data can be added to Flexmonster while initialization or via API calls.
Let me know if you have any other questions.

akash gupta September 20, 2017

Hi Tanya 
Can the problem be solved, if we connect to flexmonster with mondrain cubes?
We can form the cube from the db using schema workbench, Will the flexmonster work then?

Tanya Gryshko Tanya Gryshko Flexmonster September 21, 2017

Yes, sure, I think it’s a good solution in your case.
Please find how to work with Mondrian here:

akash gupta September 23, 2017

Hi Tanya

I have successfully connected flexmonster to mondrain cube.

Can you please help me able to understand how can I ‘expand all’  columns and rows in flexmonster pivot table, I used custom view for it, but it didn’t expand all the rows and columns.
Need urgent help.


Dmytro Zvazhii Dmytro Zvazhii Flexmonster September 25, 2017

Hello Akash,
It is nice to hear that you have successfully connected your Mondrian cube to the Flexmonster component. When you need need to expand all the nodes selected in rows and columns please use expandAllData() API call. You can find more information about it in our documentation –
Please let us know if everything works fine for you.
Best regards,

Please login or Register to Submit Answer