Table of Contents

Tutorial 1: Deploying your PowerServer project to remote servers

Overview

Task 1: Preparing the environment

Setting up the client machine

Setting up the database server

Setting up the Web server

Setting up the development PC

Setting up the auth server

Setting up the .NET server

Task 2: Deploying the PowerServer project to remote servers

Creating a Web server profile for remote deployment

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

Modifying the PowerServer project

Building & deploying the project

(Optional) Packaging & copying the app files

Publishing the Web APIs

Tutorial 2: Connecting to the Database

Overview

Stage 1: Configuring database connection for project compilation

Introduction

Configuring in PowerBuilder IDE

Stage 2: Configuring database connection for app runtime

Introduction

Configuring in PowerBuilder IDE

Configuring in PowerServer

Tutorial 3: 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 4: 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 5: 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 Folder method

Using the Web Deploy method

Verifying the Web APIs

Deploying multiple Web APIs to IIS

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

Overview

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 7: 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 8: 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 9: Publishing PowerServer Projects to Azure App Service

Prerequisites

Deployment Architecture

Steps Summary

Cloud Database

Creating the Database Resource

Configuring the Database

Dumping the Database

Restoring the Database

Web APIs

Creating the App Service

Configuring the PowerServer project

Manual Deployment (SnapDevelop)

Direct Deployment (Visual Studio)

Cloud App

With Static Web App

With Azure Storage

Troubleshooting

no pg_hba.conf entry for host

Workflow deployment fails with "Failed to find a default file in the app artifacts folder (/). Valid default files: index.html,Index.html." error

Tutorial 10: Publishing PowerServer Projects to Azure Container Instances

Prerequisites

Overview

Deployment Architecture

Creating an Azure Container Registry

Preparing the PowerServer Project

Containerizing and Deploying Web API

Pushing the container to the Azure Container Repository

Creating the Container Instance

Updating the Web API URL on the PowerServer project

Publishing the Cloud App Installer

Using Nginx Container

Using IIS Container

Creating a home page

Tagging and pushing the image

Creating the container instance

Appendix

Customizing the Containers' URLs

Troubleshooting

Cannot push image to Azure Container Registry

Tutorial 11: 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 Azure Active Directory service

Azure Active Directory (AD)

Azure Active Directory (AD) B2C

Using other authentication servers

Using Okta OIDC (OpenID Connect)

Using Visual Guard

Tutorial 12: 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 13: Packaging & Distributing Installable Cloud Apps (for ISVs)

Verifying system requirements

Packaging & deploying the client app

(Optional) Configuring database connections

(Optional) Customizing launcher and app entry page

Packaging launcher, runtime and app

Deploying the client app to Web server

Configuring the deployed app on Web server

Packaging & hosting the PowerServer Web APIs

Packaging the PowerServer Web APIs

Configuring the PowerServer Web APIs

Hosting the PowerServer Web APIs

Running the installable cloud app

Running the installable cloud app

Uninstalling the client app

Tutorial 14: 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

Changing the compression method to Gzip

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 15: 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

Activating the license