Search results

How to connect polymorphic databases in Bold BI

Bold BI application allows you to connect polymorphic databases in Bold BI. Polymorphic databases can create a single instance and access multiple databases.

Supported polymorphic databases in Bold BI

Providers Data connectors Database Engines
AWS Amazon Aurora • MySQL
• PostgreSQL
Amazon RDS • Amazon Aurora MySQL
• Amazon Aurora PostgreSQL
• MySQL
• MariaDB
• Oracle
• PostgreSQL
• SQL server
Google Google Cloud SQL • MySQL
• PostgreSQL

Connecting polymorphic databases in Bold BI using Google Cloud SQL

  1. Connect your Google Cloud SQL data source with MySQL database engine as follows.

    Google Cloud SQL

  2. After connecting, you can work with the required tables, views, or stored procedures by dragging and dropping them into the data design view page.

  3. Later, you can change the existing database engine of the Google Cloud SQL data source by clicking the edit connection button as follows.

    Edit connection

  4. After clicking, the edit connection dialog opens where you can change the database engine from MySQL to PostgreSQL and configure with the PostgreSQL credentials as follows and click connect.

    Edit connection panel

  5. You can work with the required tables, views, or stored procedures after connecting with the PostgreSQL database engine and click Save to save the data source with a relevant name to proceed with designing a dashboard.

    Save option

  6. Here, you have created a single instance with the Google Cloud SQL connector and connected it to different database engines .

Editing a Data Connection

Data Transformation

Dashboard Designer Walk Through