Need a special offer?Find out if your project fits.
+

how to connect to clickhouse database using flexmonster admin panel

Answered
mike asked on February 28, 2024

I am trying to connect to a clickhouse DB (using database=MySQL), getting failed to connect. I have tried just about every connection string I can imagine, can you please advise

2 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster March 1, 2024

Hello, Mike!

Thank you for reaching out to us.

Please note that Flexmonster Data Server does not support direct connection with ClickHouse. However, after searching for information about MySQL support in ClickHouse documentation, we have found that ClickHouse supports MySQL interface to integrate with MySQL-compatible tools: https://clickhouse.com/docs/en/interfaces/mysql

We recommend using the MySQL interface to connect ClickHouse and FDS. We do not know about any cases of using this feature with FDS, but based on ClickHouse documentation, this may be the correct tool for such a task. 

In case using the MySQL interface feature would not work, we recommend checking out the following data source options:

  • Flexmonser Data Server as a DLL: Separate flexible .NET module that allows embedding of all the aggregations required for Flexmonster in a .NET server application. This approach allows the implementation of the custom parser for loading the data from any data source.
  • Custom data source API: Our communication protocol that helps you build a custom data source based on your server. All the loading, data processing, and aggregating logic should be implemented on your end.

You can find more information about these and other data sources with their comparison on this page: https://www.flexmonster.com/blog/how-to-choose-the-best-data-source-to-use-with-flexmonster/ 

We are looking forward to hearing your feedback.

Best Regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster March 21, 2024

Hello, Mike!

Hope you are doing well.
We are wondering if you had time to try some of the suggested approaches for connecting Flexmonster to ClickHouse.
Please let us know which solution fits you more.

Best Regards,
Maksym

Please login or Register to Submit Answer