Preparing a local development environment

Table of Contents

Installing IIS in Windows 10

In order to quickly get started with PowerServer, we will use a local development machine for all roles (development, client, Web server, .NET server, and database server).

Therefore, "a local development environment" in this Quick Start guide does not mean the development PC only; it means all roles in one machine, as illustrated in the following graph. And it can only represent one supported environment (not all), for example, the IIS web server is used as an example here (although Apache and Nginx web servers are also supported), the SQL Anywhere database is used as an example (although PostgreSQL, SQL Server, Oracle etc. are also supported), Chrome is used as an example (although Firefox and Edge are also supported).


The following steps will guide you through preparing such an environment.

Step 1: Prepare a Windows 10 (64-bit) machine.

PowerBuilder IDE can only run on Windows 10 or 8.1.

Step 2: Make sure this machine has Internet connection.

Step 3: Install the following software to this machine.

Role

Requires the following software

Client

  • Install Google Chrome

    The installable cloud app must run through Google Chrome, Mozilla Firefox, or Microsoft Edge (Chromium-based) for the first time.

Database Server

Development

Development

Download the PowerBuilder Installer executable from the Downloads page on the Appeon User Center (login is required) and then run the PowerBuilder Installer to install the following programs or components:

  • PowerBuilder Runtime 2021

  • PowerServer Toolkit 2021

  • PowerBuilder IDE 2021

    During the PowerBuilder IDE installation, double check that the SQL Anywhere engine (or PostgreSQL engine) is already installed and selected in the following screen; this will automatically install the demo database according to the selected engine and create the ODBC data source required for running the PowerBuilder demo application.


    The demo database file is automatically installed to %Public%\Documents\Appeon\PowerBuilder 21.0\ and the corresponding ODBC data source is automatically created during the PowerBuilder installation.

    • If SQL Anywhere engine is installed and selected, the demo database file is pbdemo2021.db and the ODBC data source is PB Demo DB V2021.

    • If PostgreSQL engine is installed and selected, the demo database file is pbpostgres2021.dmp and the ODBC data source is PB Postgres V2021.

    Alternatively, you can download the database file from https://github.com/Appeon/PowerBuilder-Project-Example-Database and create the ODBC data source manually (instructions are provided here).

Web Server

  • Install Windows IIS

    Follow the next section Installing IIS in Windows 10 to install and verify IIS.

    Windows IIS will be used as the Web server in this tutorial to host the client-side of the installable cloud app. You can also use Windows/Linux Apache and Windows/Linux Nginx (instructions are provided here).

.NET Server

  • Nothing needs to be installed

    In the development environment, we will directly run the PowerServer Web APIs on the ASP.NET Core Kestrel web server (a light-weight web server automatically included and enabled in the ASP.NET Core project); and as Kestrel is by default included in the PowerServer Web APIs, there is no need to install any other software.

    Alternatively, you can publish PowerServer Web APIs to a dedicated hosting environment such as Docker, IIS etc. (as described in tutorial 2 and tutorial 3).