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 guide for successfully connecting to any of the supported data sources mentioned above.
2. To connect to the data source using an SSH connection, you need to enable the Enable SSH checkbox and enter the necessary SSH details, in addition to the existing data source server details. After entering this information, 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 onto the data design view page.
   
   
4. Click Save to save the data source with a relevant name to proceed with designing a dashboard.