Bold BI application allows you to connect polymorphic databases in Bold BI. Polymorphic databases can create a single instance and access multiple databases.
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 Cloud SQL |
• MySQL • PostgreSQL |
Connect your Google Cloud SQL data source with MySQL database engine as follows.
After connecting, you can work with the required tables, views, or stored procedures by dragging and dropping them into the data design view page.
Later, you can change the existing database engine of the Google Cloud SQL data source by clicking the edit connection
button as follows.
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.
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.
Here, you have created a single instance with the Google Cloud SQL connector and connected it to different database engines .