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 stable IP address. This will be the endpoint for the connection. If the db is configured to listen on a non-default port, then you’ll need to include the port number in the IP address. To do this, just append a colon after the IP address, and then the port number. For example, it the port number is 8000, the format would be xx.xx.xx.xx:8000
Generally, the database will have a firewall that prevents outside connections. To enable AppSheet to connect, you need to open up the database’s firewall to AppSheet servers’ IP addresses. A list of AppSheet’s IP address is available here.
Provide a user account through which AppSheet can access the database. For security, we recommend creating a dedicated user account that is used only by AppSheet.
With that information, you’ll be ready to establish the connection. This is done under My Account > Sources > + Data Sources. It is a bit of a misnomer here, but you’ll want to select “Cloud Database”. The "On-Premises Database” option is designed for connecting through DreamFactory.
After selecting “Cloud Database”, you’ll be prompted to enter the info you gathered in steps 1 - 3 above. After establishing the connection, your on-prem database will be accessible from all your Apps.