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:
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.
OK, I appreciate the help, guys
I appreciate your help thanks
Hi Can you elaborate little more on point no 2
I have my data on amazon aws rds server exactly where this IP need to be inserted,
I am able to connect my data to post bird and PG admin but not appsheet,
so far I have added this Ids mentioned above in my system’s firewall list.
pls pls help me out!
thanks in advance
Finally I figured it out how to connect appsheet with postgres cloud data on amazon
Using Data from MySQL | AppSheet Help Center
point 2 in above mentioned solution I was not able to get than I realized that it is pretty clear that we have to add all the IP addresses mentioned in the article in amazon cloud server security group, select default security grp and edit inbound rule.
add all the IP addresses mentioned above than you will be able to connect
and finally click on
you have to copy and paste addresses one by one in the empty space shown
Amazing I have created my first sql database app on appsheet
thank you all !
Derek - any ideas on the error I’m seeing here:
[Restrict access through specific sql ports?](https://community.appsheet.com/t/restrict-access-through-specific-sql-ports/47556/6) Questions
Scott - we completed the networking items. To build the connection to on-prem, without using DreamFactory, do we choose the cloud database option, even though it is on-prem, but opened up to appsheet? When we choose On-Prem, it only shows the dreamfactory option … So, we were able to authenticate, but got this after clicking “authorize”… The URL was: /Account/addsource?csrf=uFGgwBFKBeFUi1gv6znYMCa8uTVyB3OBb4hufcYKLcSNBgqLAI7GadWqaZcuf5D9j9X8-7PAmB_6rT6_7FmnnIjcYVgc9hsz3W0aVbpH6_5oszWlW9czWfDH…
@Matthew_Brown ,
Please choose Cloud Database instead OM On-Pemises Database.
R,
Scott
Can you make a video on this please . the is too complicated to do and I checked on Youtube but nothing is available on this topic. Thanks!