PostgreSQL Connector | Zoho Creator Help

PostgreSQL connector

Overview

PostgreSQL is a powerful open-source relational database management system known for its extensibility and standards compliance. It is widely used across industries for web applications, analytics, and data warehousing. 

The PostgreSQL connector allows you to read, write, and synchronize data from your PostgreSQL database directly within Zoho Creator, without exposing it to the public internet. Connectivity is handled securely through DataBridge, a lightweight agent installed inside your network.

Meta Information

Connector
PostgreSQL
Default port
5432 (configurable)
Data centers
US, EU, IN, AU, CA, SA, and UAE
Applicable for
C6
Website
Privacy policy
Hosting support
Local / On-premise server
Categories
Database Management

Setting up PostgreSQL connectors

To connect Zoho Creator with your PostgreSQL database, follow the steps given below:
  1. In Zoho Creator, go to Operations -> DataBridge. From the list displayed, select the operating system and version that matches your host machine (for example, macOS - 64 bit). The DataBridge package will be downloaded as a zip file.
    Note: If DataBridge is already installed and running on this machine, skip to Step 3.
  2. Install DataBridge on the host machine where your PostgreSQL database is accessible. Once installed, start DataBridge. 
  3. With DataBridge running, you're ready to connect PostgreSQL to Zoho Creator. In Zoho Creator, go to Operations -> DataBridge and confirm that DataBridge shows a status of Active.
  4. Once DataBridge is active, click Add Connection and select the PostgreSQL connector. 
  5. In the Add Connection panel, the DataBridge is automatically selected. Fill in the remaining details and click Create and Authorize.
  6. When the Link Account popup appears, provide the following details: username, password, host, port, and database name. Click Authorize to complete the connection.
For detailed instructions, see Configuring DataBridge help doc.

Where this connector can be used

Data Sources

PostgreSQL data is accessible in Creator through integration forms, integration fields, and integration reports. The table below shows supported components by module.

Module
Integration Field
Integration Form
Integration Report
Records
✓
✓
✓