Connecting Apache Doris to Bold BI using MySQL Connector

Introduction

Apache Doris is an open-source, high-performance analytics database optimized for real-time analytics. Bold BI, on the other hand, is a business intelligence platform that allows users to connect to various data sources, create dashboards, and generate insights. To leverage the capabilities of Apache Doris within Bold BI, you can use the MySQL connector. This article will guide you through the process of connecting Apache Doris to Bold BI using the MySQL connector with a specific configuration.

Prerequisites

• Apache Doris server up and running.
• Bold BI installed and accessible.
• MySQL client library installed in Bold BI.

Steps to Connect Apache Doris to Bold BI

1. Open Bold BI Dashboard Designer:
   Start by launching the Bold BI Dashboard Designer.

2. Navigate to Data Sources:
   Go to the data sources section to add a new connection.

3. Select MySQL Connector:
   Choose the MySQL connector from the list of available data source options.

4. Enter Connection Details:
   Provide the necessary connection details for your Apache Doris instance, including the server name, port, username, password and database.

5. Modify Additional Connection Parameters:
   In the additional connection parameters section, add the following property:

   Pooling=false
   

   This parameter is crucial as it disables connection pooling, which is required for connecting to Apache Doris.

6. Test Connection:
   Before proceeding, test the connection to ensure that all details are correct and that Bold BI can successfully connect to Apache Doris.

7. Save the Data Source:
   Once the connection is successful, save the data source. You can now use this data source to create dashboards and reports in Bold BI.

Conclusion

By following these steps, you can easily connect Apache Doris to Bold BI using the MySQL connector. Remember to include the pooling=false parameter in the additional connection parameters to ensure a smooth integration.

Additional References

• Apache Doris Documentation: https://doris.apache.org/
• Install and configure Apache Doris in Ubuntu Environment: Install Apache Doris in Ubuntu
• Bold BI Documentation: https://help.boldbi.com/
• MySQL Connector Documentation: https://mysqlconnector.net/

Please note that the steps and parameters may change with updates to the software involved. Always refer to the latest documentation for the most accurate and up-to-date information.