Connecting AppSheet to an On-Premise PostgreSQL Database: Requirements and Setup

[Mariano_Sanz_Gi]

Hello,

This question is specifically addressed to the AppSheet team.

I would like to understand how to connect AppSheet to a PostgreSQL database hosted on a company server (on-premise).

1. What type of account or credentials are required for AppSheet to connect to PostgreSQL?

   • Is a standard database user (username/password) sufficient?

   • Or is a specific service account or additional configuration required?

2. What is the recommended procedure to establish the connection from AppSheet to a PostgreSQL database hosted on a corporate server?

   • What requirements should the server meet (ports, SSL, public access, etc.)?

   • Is there any specific configuration needed either in AppSheet or in PostgreSQL?

The goal is to connect an AppSheet application to a PostgreSQL database running on an internal company server, not a managed cloud service.

Thank you in advance.

[Steve]

Not possible. AppSheet requires a public internet presence.

[Jose_Arteaga]

Hello @Mariano_Sanz_Gi,

Welcome back to the Appsheet Community!

As @Steve correctly states, Appsheet requires internet presence. Now, I looked at previous posts in this community and found the following method to enable access to your on-premise database:

On-premesis Database Connection

Hi Nilson, There are two methods to connect AppSheet to your on-prem database. The easiest and most common is to enable public access to your database and whitelist the AppSheet IP addresses. Alternatively, AppSheet also supports connection via DreamFactory. Most users generally go with the first method as it is easier to setup and avoids the additional cost from DreamFactory. To allow AppSheet to connect directly to your on-prem database, you’ll need the following: The server will need a s…

Please let us know how it goes!

[Mariano_Sanz_Gi]

@Jose_Arteaga

As @Steve correctly states, Appsheet requires internet presence. Now, I looked at previous posts in this community and found the following method to enable access to your on-premise database:

Gracias José.

Some time ago I actually tried the same method mentioned in the referenced post to connect AppSheet to a PostgreSQL database hosted on our company server. The connection worked correctly for a while, but later I was informed by AppSheet that the account I was using did not have the required license type to maintain a direct connection to a database, and that if I did not remove that connection the applications would stop working.

So my specific question is: can this method of connecting to an on-premise PostgreSQL database be used with an AppSheet Core account, or does it require a higher-level license (Enterprise or another plan)?

[Jose_Arteaga]

@Mariano_Sanz_Gi

connecting to an on-premise PostgreSQL database be used with an AppSheet Core account

I found the following:

Yes, connecting an on-premise PostgreSQL database to an AppSheet Core account is possible, but it typically requires configuring the database to accept incoming traffic from AppSheet’s server IP addresses via firewall updates. While direct SQL connector access is often listed under Enterprise plans, Core users can connect on-premise sources if the database is accessible via a public IP and configured for SQL connection.

My suggestion though is to contact support for a more technically knowledgeable person to help you on how to make this configuration

[Steve]

Any database server connectivity will require an Enterprise license (at least?), as I understand it.