How to connect Google Cloud SQL data source with JBDC connection string
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
- Refer to the Choosing Google Cloud SQL data source documentation for selecting the data source from the connectors.
- After clicking on the data source, the NEW DATA SOURCE configuration panel opens.
- You need to configure the configuration panel in order to connect to the Google Cloud SQL data source. Google Cloud SQL supports
MySQL
andPostgreSQL
database engines, so you can connect with either MySQL or PostgreSQL databases.
Here, you have the JDBC URL of thePostgreSQL
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.
-
After connecting to the data source, drag and drop the required table from the table schema in the data design view page.
-
Click the
Update
button to view the table data in the data grid.
-
Click Save to save the data source with a relevant name to design a dashboard.