Connecting to Google Cloud SQL in Astera Centerprise

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 Centerprise:

Steps to Connect to Google Cloud SQL via Astera Centerprise

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

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

image-20200625191317244

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.

image-20200625191349618

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

image-20200625191358171

4. Now, in Centerprise:

  • 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:

image-20200625191410541

image-20200625191417597

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.

To learn more about how to pick a table from a database source and specify other reading options, click here.

This concludes connecting to Google Cloud SQL via Astera Centerprise.