asked on November 8, 2023
Afternoon Support,
I'm currently looking into reviewing our current OLAP cube solution, and was looking at Doris as the backend and then I'm looking at various web pivot tables components and one of those is flexmonster. So to my question, I see you support MySQL which is how it would communicate with Doris but then I see you have a data server that sits in between which aggregates etc and readies the data but then behaves a little bit like what Doris does and has a large memory footprint.
So I guess I'm interested if I understand it correctly and if the above would be performant in your view.
Cheers
Tom
⋅ November 9, 2023
Hello, Tom!
Thank you for reaching out to us.
As a first step, we want to briefly describe all the possible ways you can connect Flexmonster component to the MySQL Database.
1. Flexmonster Data Server
As you have already read, the Data Server is our tool for connecting to MySQL databases.
Flexmonster Data Server processes and aggregates the data using the RAM of the machine where it is installed to perform all the calculations. From the use case you have described, it is possible to use Flexmonster Data Server instead of Apache Doris as a connector between your MySQL databases and Flexmonster client component. However, please note that Flexmonster doesn't allow merging data sources so that you can show data from one database in one Flexmonster component at a time.
2. JSON/CSV files
There is a simpler approach to using Flexmonster with any backend stack - generate the data in JSON or CSV files on your server and feed them to Flexmonster directly or use the Data Server as well. This approach suits well, for example, if you need to preprocess the data before inserting it into Flexmonster component.
Please read more about this approach in our docs: https://www.flexmonster.com/doc/json-data-source/.
3. Custom data source API
There is also a more advanced approach to connect Flexmonster to any data source. In this case, we are offering our communication protocol, and implementation of all data processing and aggregating functionality is held on your end.
You can read more about this approach in our docs: https://www.flexmonster.com/doc/introduction-to-custom-data-source-api/.
Hope you will find our answer helpful. Please let us know which approach works best for your use case, and we will be happy to provide you with more usage examples.
Kind regards,
Solomiia
⋅ November 21, 2023
Hello, Tom!
Hope you are doing well.
Our team is wondering if you had some time to look through our brief description of available approaches to connect Flexmonster to the MySQL database. Could you please let us know if there are any further questions?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ November 28, 2023
Hello, Tom!
Hope you are having a great week.
Just checking in to ask if you have any further questions about connecting Flexmonster to your data source.
Looking forward to hearing your feedback.
Kind regards,
Solomiia
⋅ November 28, 2023
Afternoon Solomiia,
Thanks for getting back to me, it sounds like I will need to do the custom data source at least from initial indicators. Again thanks for getting back to me and feel free to close this ticket
Cheers
Tom.
⋅ November 28, 2023
Hello, Tom!
Thank you for your swift response.
We are glad to hear your feedback.
Feel free to contact us if you have further questions about implementing a custom data source API protocol.
Regards,
Solomiia
