Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. The integration between Postgres and Togai requires only a one-time setup. Follow the steps below:

​
Install

  • Navigate to the Integrations section from the left navigation bar in Togai
  • Click on Apps to access the list of apps with integration support
  • Select Postgres from the available apps
  • Click on the +Add connection button
  • Provide a name for the connection and paste your:
    • Connection URI: The connection URI for your Postgres database

​
Connection URI

The syntax for the postgres connection URI using the username and password authentication: 
jdbc:postgresql://username:password@host:port/database

​
Flows

​
Sync customer from Postgres to Togai

  • The flow will be available to be triggered on demand from the Togai dashboard
  • It will execute a SQL query to fetch all the customers from Postgres
  • It will then create the customers in Togai using the Customers API

​
Sync events from Postgres to Togai

  • The flow will be available to be triggered on demand from the Togai dashboard
  • It will execute a SQL query to fetch all the events from Postgres
  • It will then create the events in Togai using the Event Ingestion API