Connecting Bold BI to Imply (Managed Apache Druid service) with Web API Connector

Connecting to Imply, which is a managed Apache Druid service, can be efficiently done using the Web API Connector. This article will guide you through the steps to establish a connection between your Bold BI dashboard and Imply using the Web API Connector.

Prerequisites

Before you begin, ensure that you have:

• An active Imply account with access to the data you wish to visualize.
• The URL endpoint for the Imply API that you will be connecting to.
• Necessary authentication details.

Steps to Connect

1. Open Bold BI Dashboard Designer:
   Start by opening the Bold BI Dashboard Designer. This is where you will configure the connection to Imply.

2. Add a Data Source:
   Navigate to the data source page and click on the ‘Add Data Source’ button to create a new connection.

3. Select Web API Connector:
   From the list of available data connectors, select the ‘Web API Connector’. This connector allows you to fetch data from various web services that use API endpoints.

4. Configure Connection Details:
   In the connection settings, enter the API endpoint URL provided by Imply. Ensure that the URL is correct and points to the data you want to access.

Url: https://<:domainName>.imply.io/v1/projects/<:projectId>/query/sql
Method: Post
Request body as Row:  { "query": "SELECT * FROM \"druid\".\"cashflows\"" }

Authentication Type: Basic Http Authentication
Username: <:your username>
Password: <:your password> 

5. Enable the Refresh Settings in Connector and Configure the refresh interval to keep the data up-to-date with real-time information.
   

   

6. Click the Connect button once you have provided all the details.
   

   

7. Design Your Dashboard:
   With the data imported, you can now utilize Bold BI’s dashboard design features to create visualizations and insights from your Imply data.

8. Save and Publish:
   Once you are satisfied with the dashboard design, save your work and publish the dashboard for your team or clients to access.

Conclusion

By following these steps, you can easily connect Bold BI to Imply using the Web API Connector. This allows you to visualize and analyze your Imply data within Bold BI, creating powerful dashboards that can help drive data-driven decisions.

Additional References

• Web API Documentation
• Imply Documentation
• Apache Druid API Documentation