Search results

How to connect Google Cloud SQL data source with JBDC connection string

Bold BI application allows you to connect Google Cloud SQL data source with JDBC connection string parameters.

JDBC connection string

You cannot directly pass the JDBC URL in Bold BI, but you can connect to Google Cloud SQL data source using the JDBC URL parameters. The general format of JDBC connection string is mentioned as follows.

jdbc:<data source>://<server name or hostname>:<port>/<database name>

Connecting Google Cloud SQL with JDBC URL

  1. Refer to the Choosing Google Cloud SQL data source documentation for choosing the data source from the connectors.

  2. After clicking the data source, the NEW DATA SOURCE configuration panel opens.

  3. You need to configure the configuration panel to connect to the Google Cloud SQL data source. Since Google Cloud SQL supports MySQL and PostgreSQL database engines, you can connect with MySQL or PostgreSQL databases.

    Here, you have the JDBC URL of the PostgreSQL data source.

    jdbc:postgresql://demoserver:5740/postgres

    Here, the values for Server name, Port, and Database from the above JDBC connection string parameters for connecting the Google Cloud SQL data source with the PostgreSQL database engine in Bold BI are specified as follows. You can also set the additional connection parameters using this documentation.

    Configuration panel

  4. After connecting to the data source, drag and drop the required table from the table schema in the data design view page.

    Drag table

  5. Click the Update button to view the table data in the data grid.

    Update records

  6. Click Save to save the data source with a relevant name to design a dashboard.

    Save data source