Creating the PowerServer project

Creating a new PowerServer project

Step 1: In the PowerBuilder System Tree view, right click the SalesDemo workspace and select New. In the New dialog, select the Project tab and then select PowerServer. The PowerServer project painter is opened.

Configure the PowerServer project painter according to the instructions below. Some tab pages that do not need to be configured in this tutorial will be skipped directly. For detailed information on how to use each tab page, refer to the How-to guides.

Configuring the General tab

Step 1: On the General tab, input "pssales" in App name as the application name.

Configuring the External Files tab

Step 1: On the External Files tab, select Files preloaded as compressed packages and then click Create Package. Input a package name (for example "theme"). Then select this package and click Add Folder to add these two folders one by one: JSON and Theme, as shown in the figure below.

Step 2: Select Files preloaded in uncompressed format and then click Add Files to add the files as shown in the figure below.

Step 3: Select Images/videos dynamically loaded and then click Add Folder to add the following folder: image.


Configuring the Runtime tab

Step 1: On the Runtime tab, select WebBrowser Support and RibbonBar Support.


Configuring the Client Deployment tab

Step 1: Select the Client Deployment tab in the PowerServer project painter.

Step 2: In the Deployment mode section, click the Server Configuration button.

Step 3: In the Web Server Profile window that appears, click the Add button.

Step 4: In the Add/Edit Server window, select Local server, set the Web root full path (in this tutorial, C:\inetpub\wwwroot), and then click Test File Path to ensure the path is valid.

This tutorial assumes your OS is installed to the C drive and the IIS Web root is C:\inetpub\wwwroot.

If you encounter any errors when configuring the Web server profile, refer to Permission errors when configuring the Web server profile.


Step 5: Click OK to save the server profile and return to the Web Server Profile window.

Step 6: Click the Upload Cloud App Launcher button.


Step 7: In the Upload Cloud App Launcher and Runtime window that appears, make sure the following are selected: Local, Upload the runtime files for the apps, 32-bit, and 64-bit.

Step 8: Click Upload and make sure the upload is successful.

This section Uploading the cloud app launcher and the runtime files has more details about this window.


Configuring the Web APIs tab

Step 1: On the Web APIs tab, select "Create a new C# solution".

Step 2: Use the default location and name for the solution.

Step 3: Input "Salesdemo" as the namespace for the solution.

Step 4: Specify the URL where the Web APIs will be running. In this tutorial, the URL will point to the IP address and port number of the local computer, for example, http://172.16.100.104:5009.


Step 5: Click the Database Configuration button at the bottom of the Web APIs tab.

Step 6: In the Database Configuration dialog, click New in the upper part to create the database connection that will be used by the Web APIs.

Create the database connection with the following settings:

  • Specify any text (for example "local_sa") as the database cache name.

  • Specify SQL Anywhere (ODBC) as the database provider.

  • Select PB Demo DB V2021 as the data source.

  • Specify "dba" as the user name and "sql" as the password.

  • Click Test Connection to make sure the database can be connected successfully.


Step 7: Click OK to save settings and go back to the Database Configuration dialog; make sure the check box of the database cache is selected; and then click New in the lower part to map the transaction object with the database cache.

Step 8: Input "sqlca" as the transaction object that maps to the database cache.


Importing the PowerServer license

The imported license file will be deployed along with the Web APIs project, and will be activated when the installable cloud app is run.

The following instructions are specific to the beta users.

First of all, make sure you have a valid license for PowerServer 2021 Beta.

  • If you have a preview license, the preview license will no longer work with the beta version.

  • If you already have a PowerBuilder CloudPro license (no matter which version it is), the CloudPro license will automatically work with the beta version.

  • If you have no PowerBuilder CloudPro license, you can apply for a beta license at https://www.appeon.com/ps-beta.

Once you have a valid license for the beta version, you can import the license and deploy it along with the Web APIs project. The license will be activated when the installable cloud app is run.

Step 1: Make sure the computer can connect to the Appeon sites (https://apips.appeon.com, https://apipsoa.appeon.com, https://apipsinfo.appeon.com, and https://api.appeon.com).

Step 2: Go to the Web APIs tab of the PowerServer project, and then click Auto Import to automatically import the license.

PowerBuilder will automatically obtain the license (according to your PowerBuilder IDE login account) from the Appeon sites and then import the license here.