Preparations

In this tutorial, we will set up the salesdemo SQL Anywhere database server running in an independent machine.

Set up the database server with the following OS and software:

  • 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 .NET server. The data source in the development PC is for converting DataWindows to models, and the data source in the .NET server is for accessing data from the database. The following sections have detailed instructions for how to create the ODBC data source.

Important

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.