In this tutorial, we will set up the salesdemo SQL Anywhere database server running in an independent machine. For other supported databases, please refer to Database in installation guide.
-
Windows Server 2019 (64-bit)
-
SQL Anywhere 17
Click here to download the installer for the free trial of SQL Anywhere developer edition.
This tutorial takes SQL Anywhere database as an example. You can also install the other databases by following the documentation from the vendor.
Note that the SQL Anywhere database can only be connected through an ODBC driver. You will need to create the same ODBC data source in both the development PC and the web server. The data source in the development PC is for converting DataWindows to models, and the data source in the web server is for accessing data from the database. The following sections have detailed instructions for how to create the ODBC data source.
Note
For optimal runtime performance, it is highly recommended that the PowerServer Web APIs should be published to a server that locates on the same LAN as the database server. If the database is not on the same network as the Web APIs, every request has to go a long way from PowerServer to the database, it is highly possible that there will be performance and security issues.
