PostgreSQL
What is PostgreSQL?
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.
What is AppiWorks integration with PostgreSQL?
AppiWorks is an application integration platform. It can create a connection of PostgreSQL in the AppiWorks platform and use it in any client platform such as AppiWorks for Zoho CRM, AppiWorks for Google Forms, AppiWorks Looker Studio Connector, etc.
Setup and Configuration
How to establish a connection?
Search for PostgreSQL in the AppiWorks platform (as shown on the right side)
Click on the PostgreSQL
To connect PostgreSQL databases following elements are required.
Host
Port
Database
User
Password
SSL
If SSL is required you need to set it as a JSON file
eg: { "rejectUnauthorized" : false}
Provide all the required credentials and click on Connect to create the new connection.
You could have your PostgreSQL database running in any of the cloud providers such as GCP, AWS, etc. (can be any other providers) or on your private cloud or on-premises server that is connected to the Internet.
For GCP and AWS you can visit the following links for your reference
GCP - https://cloud.google.com/sql/docs/postgres/create-manage-databases
AWS - https://aws.amazon.com/getting-started/hands-on/create-connect-postgresql-db
Before setting up the PostgreSQL connection in the AppiWorks platform, one must configure the PostgreSQL database to accept connection from AppiWorks infrastructure.
***IMPORTANT NOTE***
The following IP range should be whitelisted in your cloud/ on-premise PostgreSQL database so that AppiWorks Infrastructure can connect with it.
35.238.134.134