On-premesis Database Connection

According to this page: https://help.appsheet.com/en/articles/2213968-connecting-to-an-on-premises-database we can connect to an on-premises database without the need for DreamFactory.

Where is the option to do so? I can only find DreamFactory setup into under the option for On-premises Database in my account settings.

Thanks

I suspect you want to choose Cloud Database.

The database in question is hosted on our own site, not in the cloud. The article says that it’s supported to connect to such a database. We’re likely going to go with another option and put the data into a cloud database, but it would be more convenient to have the option available to connect to something we host ourselves.

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:

  1. 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

  2. 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.

  3. 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.

3 Likes

OK, I appreciate the help, guys

1 Like

I appreciate your help thanks