![]() ![]() For MariaDB databases, you can select MySQL. Currently, AppSheet only supports SQL databases (SQL Server, MySQL, MariaDB, and PostgreSQL). In the Info sub-tab, select the appropriate service type based on the type of your database. In DreamFactory, open the Services tab, and click Create to add a new service. To allow DreamFactory to connect to your database, you need to register it as a new service in your DreamFactory instance. Name the new app AppSheet, check the Active check box, select On a remote URL as the app's location, and enter AppSheet's URL ( ).Īfter you click save to register AppSheet, DreamFactory will automatically generate a new API key that AppSheet can use to connect to your DreamFactory instance. Once you have set up DreamFactory, log into your DreamFactory instance as an admin, and open the Apps tab, and register AppSheet by clicking Create. #Sql tabs postgresql superuser how to#See DreamFactory for more information on how to install and set up DreamFactory. #Sql tabs postgresql superuser download#The second approach is to download and install DreamFactory into your on-premise server alongside your database. In this case, you will still need to open your database's firewall to allow the DreamFactory instance to connect to your database. The first method is to create a DreamFactory instance hosted on a web server that is separate from your database's server. There are two ways to install DreamFactory. Install DreamFactoryĭreamFactory is a proxy server that exposes a REST API through which third-party applications can securely connect to your databases. To address this problem, AppSheet now supports DreamFactory, which allows Appsheet to securely connect to on-premise databases. ![]() However, opening the firewalls of an on-premises database is considered an unsafe practice by many. The main advantage of this method is that it is quick and easy to implement. See Manage IP address and firewall information for list of AppSheet's IP addresses. ![]() The simplest way to allow AppSheet to connect to an on-premises database is to open up the database's firewall to AppSheet servers' IP addresses. It will continue to work for existing customer configurations. AVAILABILITY NOTICE: Use of DreamFactory to connect securely to an on-premises database is not available to new customer configurations. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |