PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications. This enables users to integrate the server with their PostgreSQL database with the key results. You can get up-to-date information on your check-ins without the hassle of switching between the two accounts

What you can do with PostgreSQL and Profit.co Integration?

Profit.co enables you to integrate and connect your PostgreSQL and create key results via the database server of PostgreSQL.

Step 1

Navigate to Settings from the left navigation panel.

Click on Integrations, On the Connectors page, Select the Business Level tab and click on the PostgreSQL Manage button.

all_my_okrs
integrations

Click on the Connect to PostgreSQL button.

connect_to_postgre_sql

Step 2

On the Connect to PostgreSQL page, provide information for the Connection Name, and other details of your PostgreSQL account.

Note: Enter your Username and password the same as that of your PostgreSQL login username and password.
connect

Now the Profit.co account is successfully integrated with the PostgreSQL account.

delete

Step 3

Now Create a key result Using the Form in Profit.co where you want to integrate the PostgreSQL in a key result.

Enter the Key Result name, and choose the required Key Result type and KPI.

Select the Automate Check-in and choose PostgreSQL from the Connection dropdown.

postgresql

Enter the SQL Query value to run and get the exact value in the database. Finally, Update it.

update

Step 4

Once the Key Result is successfully created, click on the Check-in button and complete the Check-in to update the status value in the key result.

check-in