Connecting to Google Cloud Platform Database

Overview

Google Cloud Platform offers managed database services that allow you to deploy, manage, and scale relational databases in the cloud. This guide will walk you through the process of connecting your Outerbase application to a GCP Database instance.

Prerequisites

Before you begin, ensure you have the following:

  • A Google Cloud Platform account with active access.
  • A GCP Database instance set up with your desired database engine (e.g., Cloud SQL for MySQL, Cloud SQL for PostgreSQL, etc.).
  • Access credentials for the database (username and password).
  • The connection details for your GCP Database instance.
  • Outerbase application environment details.

Step 1: Configure Database Access

To allow your Outerbase application to communicate with your GCP Database instance, you need to configure database access settings.

  1. Log in to your Google Cloud Console.
  2. Navigate to your GCP Database instance.
  3. In the "Instance details" section, find the Access control settings.
  4. Add the following IP addresses to the allowed IP list:
    • 44.205.184.114
    • 54.172.85.237
  5. Save the changes to update the allowed IP addresses.

Step 2: Obtain Connection Details

Before you can connect to your GCP Database instance from Outerbase, gather the following information:

  • Instance Connection Name: The unique identifier for your GCP Database instance.
  • Username and Password: The credentials for accessing the database.
  • Database Name: The specific database you want to connect to.

Step 3: Connect from Outerbase

With the required information on hand, configure your Outerbase application to connect to your GCP Database instance.

  1. Open your Outerbase application's configuration.
  2. Find the database configuration section.
  3. Use the Instance Connection Name as the database host.
  4. Enter the username and password you set up for authentication.
  5. Specify the database name you want to connect to.
  6. Save the configuration changes.

Conclusion

Congratulations! You have successfully established a connection between your Outerbase application and your Google Cloud Platform Database instance. This allows your application to interact with the managed database service provided by GCP.

Always ensure the security of your credentials and connection details, and regularly review and update your security settings as necessary.

For more detailed information and troubleshooting, consult the Google Cloud Database documentation.

Next
What is Outerbase?