How to connect PostgreSQL to Albato

PostgreSQL: Database integrations
PostgreSQL
·
9/19/2023
·
1 min. read

PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.

Available actions

Actions are what Albato performs when your automation is running, Actions also allow you to transfer data to other apps and systems

  • Create new rows
  • String search
  • Update a row
  • Custom request

Before setting up integrations with PostgreSQL, connect the tool to Albato.

To do this, go to the Apps section and click the Add a connection button.

Example.png

Select the app and click the Add a connection button.

PostgreSQL.png

Come up with a name for your connection.

In the Login and Password fields, enter the data for accessing your database.

In the Host and Port field, enter the IP address of your database and the port. For example, IP address: 85.67.44.23, Port: 3306.

In the Database field, enter the name of your database.

In the Scheme field, type "public".

PostgreSQL (1).png

Click the Continue button.

The connection is ready!


PostgreSQL