- Create a user and grant it minimum permissions required for Integrate.io ETL to read or write data from the database.
- Allow access from Integrate.io ETL’s IP addresses to your database port (Refer to this article if you’d prefer to create an SSH tunnel or reverse SSH tunnel.)
To create a Google Cloud SQL for PostgreSQL database connection in Integrate.io ETL
1
Click the Connections icon (lightning bolt) on the top left menu.
2
To create a connection, click New connection.
3
Select Google Cloud SQL for PostgreSQL and name the connection.
4
Select your access type (direct connection if you’ve whitelisted Integrate.io ETL’s IP addresses.)
5
Enter your database host name.
6
Enter the database name.
7
Enter the user name.
8
Enter the user’s password.
9
Click Test Connection to make sure the connection details are correct.
10
Click Create connection to create the connection.
Note:If you’d like to keep an internet connection secure and safeguard any sensitive data that is being sent between Google Cloud and Integrate.io ETL, we recommend setting up a Reverse SSH Tunnel.