How to connect data sources with SSH connection in Bold BI

Bold BI application allows you to enable SSH for the supported data sources by following these steps.

Supported data sources in Bold BI with SSH connection

• SQL Server
• MySQL
• CData
• MemSQL
• MariaDB
• Amazon Redshift
• Presto
• Influx DB
• Amazon Aurora
• PostgreSQL
• Elasticsearch
• SparkSQL
• Google cloud SQL

Steps to connect to a data source with SSH connection

1. Refer to the Connecting to Bold BI data sources for successfully connecting to any of the above supported data sources.

2. For connecting to the data source with SSH connection, you need to enable the Enable SSH checkbox and enter the required SSH details along with the existing data source server details and click Connect.

   

In this way, you can enable SSL in the connection by passing the parameters in a connection string.

3. Drag and drop the table from the table schema in the data design view page.

   

4. Click Save to save the data source with a relevant name to proceed with designing a dashboard.