Connecting to Google Cloud SQL in Astera

Google Cloud SQL is a fully managed database service that makes it easy to set-up, maintain, and manage MySQL and PostgreSQL relational databases in the cloud.

There are three types of databases supported in Google Cloud.

1. MySQL

2. PostgreSQL

3. SQL Server

All of them can be connected to by following the same steps in Astera:

Steps to Connect to Google Cloud SQL via Astera

Follow the steps below to connect to Google Cloud SQL via Astera:

1. Create an instance in the GCP Console. Once this is done, the following screen will appear.

2. Go to the CONNECTIONS tab and click Add network. You will have to enter the public IP of your system from where you want to access databases. This will enable you to access the databases hosted on GCP.

3. In the USERS tab, Create user account if you do not have one already.

4. Now, in Astera,

• Select the relevant Data Provider (MySQL or PostgreSQL).

• Provide the User ID and Password that you created in the step 3.

• Provide the Public IP address in the Server Name as shown in the screenshot below:

Now, click Test Connection to see if your connection has been established with the database. When the connection is established, click Next. You can now pick a table from your database and use it in your dataflow.

This concludes connecting to Google Cloud SQL via Astera.