Table of Contents

Tutorial 1: Deploying your PowerServer project to remote servers

Overview

Task 1: Setting up the client machine

Task 2: Setting up the database server

Preparations

Configuring Windows Defender Firewall

Starting the database

Task 3: Setting up the Web server

Overview

Preparations

Installing Web Server (IIS)

Deploying app files to Web Server

Task 4: Setting up the development PC

Preparations

Creating the ODBC data source for the remote database

Creating a Web server profile for remote deployment

Uploading the cloud app launcher and the runtime files to the remote server

Modifying and re-deploying the PowerServer project

Task 5: Setting up the auth server

Task 6: Setting up the .NET server

Preparations

Creating the ODBC data source

Publishing the Web APIs

Tutorial 2: Hosting Web APIs in Docker Containers

Overview

Task 1: Setting up Docker

Setting up a docker host (Docker Engine)

Setting up a docker registry

Task 2: Setting up the database server

Preparations

Starting the database

Task 3: Publishing to Docker

Preparing the development PC

Modifying and re-deploying the PowerServer project

Publishing and deploying Web APIs to Docker

Tutorial 3: Hosting Web APIs in IIS (in-process hosting)

In-process hosting vs. out-of-process hosting

Preparations

Installing IIS

Windows Server OS

Windows Desktop OS

Creating an IIS website

Configuring IIS

Configuring SSL on IIS

Installing Web Deploy

Installing ASP.NET Core Hosting Bundle

Publishing and deploying Web APIs to IIS

Using the Web Deploy method

Using the File System method

Tutorial 4: Hosting Web APIs in Kestrel (using reverse proxy server)

Overview

About PowerServer Web APIs and Kestrel

Running Web APIs on Kestrel

Using a reverse proxy server

Configuring Apache reverse proxy server (Windows)

Configuring Apache reverse proxy server (Linux)

Configuring Nginx reverse proxy server (Windows)

Configuring Nginx reverse proxy server (Linux)

Configuring IIS reverse proxy server

Tutorial 5: Load-balancing PowerServer Web APIs

Overview

Configuring Nginx as a load balancer

Using Nginx Sticky Module

Using Nginx Plus

Using IP hash load-balancing

Configuring IIS as a load balancer

Configuring Apache as a load balancer

Tutorial 6: Authenticating your apps

Overview

Using JWT

Preparations

Modifying the PowerBuilder client app

Appendix

Using OAuth 2.0

Preparations

Modifying the PowerBuilder client app

Appendix

Using Amazon Cognito

Preparations

Creating the Amazon Cognito user pool

Modifying the PowerBuilder client app

Modifying the authentication template

(Optional) Testing the Cognito server

Using other authentication servers (e.g. Azure AD)

Azure Active Directory (AD)

Azure Active Directory (AD) B2C

Tutorial 7: Building your PowerServer project with commands

Task 1: Exporting the build file

Preparing the environment

Exporting the build file

Modifying the build file

Task 2: Building with commands

Preparing the environment

Running the command-line tool

Integrating with Jenkins

Tutorial 8: Packaging & Distributing Installable Cloud Apps (for ISVs)

Packaging & deploying the client app

(Optional) Customizing launcher and app entry page

Packaging launcher, runtime and app

Deploying the client app to Web server (for end users)

Configuring the deployed app on Web server (for end users)

Packaging & hosting the PowerServer Web APIs

Packaging the PowerServer Web APIs

Configuring the PowerServer Web APIs (for end users)

Hosting the PowerServer Web APIs (for end users)

Running the installable cloud app (for end users)

Running the installable cloud app

Uninstalling the client app

Tutorial 9: Load testing installable cloud apps

Load testing installable cloud apps with LoadRunner

Dynamic Values in the Recorded Script

Enclosing Parameters in Angle Brackets “<>”

Running the Application in Test Mode before Recording the Script

Recording

Correlating the Session ID

Correlating the Transaction ID

Parameterizing Static Values in SQLs

Replaying

Load testing installable cloud apps with JMeter

Overview

Preparing the installable cloud application

Recording JMeter scripts

Parameterization and correlation

Tutorial 10: Setting up a Web server

Overview

Setting up IIS

Preparations

Installing Web Server (IIS)

Configuring SSL on IIS

Creating an IIS FTP site

Configuring SSL on FTP server

Setting up Apache on Windows

Preparations

Installing Apache HTTP Server

Configuring SSL on Apache

Installing FTP server

Setting up Apache on Linux

Preparations

Installing Apache HTTP Server

Configuring SSL on Apache

Configuring Apache to be case-insensitive

Packaging and copying the client app

Setting up Nginx on Windows

Preparations

Installing Nginx

Configuring SSL on Nginx

Installing FTP server

Setting up Nginx on Linux

Preparations

Installing Nginx

Configuring SSL on Nginx

Configuring Nginx to be case-insensitive

Packaging and copying the client app

Tutorial 11: Deploying installable cloud apps to Kubernetes

Overview

Before you begin

Configuring Azure Kubernetes Service

Creating a Kubernetes cluster in AKS

Connecting to the Kubernetes cluster

Installing ingress controller

Logging into Azure container registry

Creating a database

Containerizing the installable cloud app

Preparing the application

Creating the container images

Pushing images to Azure container registry

Deploying the application to the Kubernetes cluster

Creating the YAML manifest files

Deploying the application

Configuring the domain name

Testing the application

Tutorial 12: Applying a production license to an existing PowerServer project

Accessing the production license code (Order Owner only)

Importing the production license into the project

After compilation

Before compilation

Tutorial 13: Connecting to the Database

Overview

Part 1: Configuring database connection for project compilation

Introduction

Configuring in PowerBuilder IDE

Part 2: Configuring database connection for app runtime

Introduction

Configuring in PowerBuilder IDE

Configuring in PowerServer