Articles in this section
Category / Section

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

Published:

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

JDBC connection string

You cannot directly pass the JDBC URL in Bold BI, but you can connect to a Google Cloud SQL data source using the JDBC URL parameters. The general format of the JDBC connection string is 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 selecting the data source from the connectors.
  2. After clicking on the data source, the NEW DATA SOURCE configuration panel opens.
  3. You need to configure the configuration panel in order to connect to the Google Cloud SQL data source. Google Cloud SQL supports MySQL and PostgreSQL database engines, so you can connect with either MySQL or PostgreSQL databases.
    Here, you have the JDBC URL of the PostgreSQL data source.

jdbc:postgresql://demoserver:5740/postgres

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

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

    drag-cloud-sql.png

  2. Click the Update button to view the table data in the data grid.
    update-cloud-sql.png

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

    save-cloud-sql.png

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
NG
Written by Nisanth Gunasekaran
Updated:
Comments (0)
Please  to leave a comment
Access denied
Access denied