Setting Additional Connection Parameters in PostgreSQL Connector

When configuring the PostgreSQL connector in Bold BI, it may be necessary to specify multiple additional connection parameters to tailor the connection to your specific needs. These parameters can be used to control various aspects of the connection, such as timeouts, SSL settings, and more.

Steps to Set Additional Connection Parameters

1. Open the PostgreSQL Data Source Configuration:
   Begin by navigating to the data source configuration page within Bold BI where you can set up a new connection or edit an existing one.

2. Locate the Connection Parameters Field:
   Within the configuration settings, find the field where you can input connection parameters. This is typically labeled as “Connection Parameters,” “Advanced Settings,” or something similar.

3. Input Parameters:
   Enter the desired connection parameters in the designated field. To specify multiple parameters, separate each parameter with a semicolon (;). For example, if you want to set the sslmode to Require and the TrustServerCertificate to true, you would enter the following:

   sslmode=Require;TrustServerCertificate=true
   

4. Verify Connection Parameters:
   Before finalizing the connection, it’s important to ensure that the parameters you’ve entered are correct and supported by the PostgreSQL database server. Refer to the PostgreSQL
   documentation for a list of valid connection parameters and their expected values.

5. Save and Test the Connection:
   After entering all the necessary parameters, save the configuration and test the connection to make sure that it is successful and that the parameters are working as intended.

Additional References

• Bold BI Documentation
• Bold BI PostgreSQL connection
• PostgreSQL Connection String Parameters