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.
MySQL
PostgreSQL
SQL Server
All of them can be connected by following the same steps in Astera:
Steps to Connect to Google Cloud SQL via Astera Centerprise
Follow the steps below to connect to Google Cloud SQL via Astera:
Create an instance in the GCP Console. Once this is done, the following screen will appear.
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.
In the USERS tab, Create a user account if you do not have one already.
Now, in Astera:
Select the relevant Data Provider (MySQL or PostgreSQL).
Provide the User ID and Password that you created in 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.
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.
Last updated