Adding a PostgreSQL Connection

Adding a PostgreSQL Connection

Authenticating a connection to PostgreSQL enables communication between the two platforms. This must be successfully added before Form Connectors can push or Data Source Connectors can pull data.


TABLE OF CONTENTS

Adding a PostgreSQL Connection

The Connections area of the platform is where you can add connections for connectors. Navigate on the side menu to Connected Data > Connections. 

On the Connections page: 

  1. Click the ADD CONNECTION button on the top right to bring up a list of connections
  2. Click on PostgreSQL option to add the connection.

Authenticating PostgreSQL

After adding a connection, fill out all the required properties. 

Connection String

Add the PostgreSQL Connection String to be used by connectors to access your database. 

You must included the Server, Database, User Id, and Password credentials in the string.
The PostgreSQL user specified must have at least CONNECT, USAGE, CREATE, SELECT, INSERT, and DELETE privileges assigned. For the most straightforward configuration grant all privileges to the user. 

Encrypted Connection PostgreSQL will automatically, by default, encrypt the connection if possible. This option will ensure that the Connector uses SSL encryption for all data sent between the platform and your PostgreSQL server.

Click the SAVE on the top-right to store your configuration and automatically verify the connection. 

Additional Info

  1. PostgreSQL connections are only available on Premium accounts, and they must be added by an Administrator level user to see the option. 
  2. The default port for PostgreSQL is 5432. You must ensure this port is open on your firewall and is configured to accept connections form our cloud servers. 



    • Related Articles

    • Adding a Box Connection

      Box is a Secure Cloud Storage Platform designed specifically for the purpose of securely storing your data files. This versatile platform allows users to easily share their files with others, functioning similarly to other popular cloud file storage ...

    • Adding MySQL Connection

      MySQL is an open-source Relational Database Management System that uses SQL to create and manage databases. As a relational database, MySQL stores data in tables of rows and columns, organized into schemas. Our MySQL Connectors allow you to push and ...

    • Adding OAuth 2.0 Connection

      Connecting to REST with OAuth 2.0 OAuth 2.0 is an authorization protocol that allows applications to access user data from other services without sharing the user’s credentials. It enables users to securely grant limited access to their resources on ...

    • Adding a QuickBooks Connection

      QuickBooks simplifies accounting for small businesses by automating tasks such as bookkeeping, invoicing, time tracking, sales tax management, budgeting, bank reconciliation, and inventory tracking. By using apps from our platform, these tasks can be ...

    • Adding a Salesforce Connection

      TABLE OF CONTENTS Configuring Salesforce Creating a New Connected App (Settings Required) Manage Connected App Configuring the Salesforce Connection To add a Salesforce Connection, go to the Connections page which is accessed via Menu -> Connected ...