Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved What to learn for PowerServer?

  1. Advice
0
Votes
Undo
  1. Jay Hastings
    Jay Hastings
  2. PowerBuilder
  3. Friday, 16 December 2022 00:23 AM UTC

I'm a PowerBuilder programmer for a number of years.  Probably started on 6 and now on 2019.  Its an internal app with nothing special.  I'm NOT and IT guy.  I don't do servers.  I do my own Oracle stored procedures/triggers etc but we have DBA that runs the database(s).

I don't do C# or Java or any of that.  I'm old.  I started with keypunch cards.

Anyway we're starting to look into using Appeon PowerServer as our app is run in numerous cities within our company and deploying is a strain.

What would you suggest I should look at learning first that will assist me.  We'll have then infrastructure team set up the server so I'm not interested in that.  Would learning C# assist me more than anything else?

 

Thanks for any tips

 

Jay

Database parameter
ODBC connection error
Accepted Answer
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 16 December 2022 21:59 PM UTC
  2. PowerBuilder
  3. # Permalink
having some c# skills will help. there are a ton of free videos on that, and you can easily find c# classes to pay for. You will be able to quickly understand the basics of the c# stuff, and you will be looking at c# code. You have to deploy the c# web services so that code will be in front of you. And you may need to change it depending on what you are doing. depending on HOW you are going to deploy, having an understanding of the software that PS runs on will be a big help. if you use IIS for example, then you will need to have an understanding of that. if you will be using other services instead of or in addition to IIS for hosting the web apis (containers, cloud services etc) then again you need to have an understanding of that. Deployment of the actual application can either be very manual, or you can figure out how to setup everything as a job/command line. That requires learning all of that and it all depends on the toolsets you will be using to deploy/build to. Its all very doable, and you can simply learn the bits you need to.
Comment
There are no comments made yet.
Responses (3)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 16 December 2022 17:26 PM UTC
  2. PowerBuilder
  3. # 1

If the only "pain" is deployment of your application, maybe an easier and cheaper solution would be to create a PowerClient project. It takes care of all of the deployment, once you have configured it correctly. It also doesn't mean many changes in your code. If I remember well, the only restriction is that you cannot deploy parallel directories: all folders have to be a subfolder of the main application folder. (I'm probably not explaining myself too well here).

Going to PowerServer will also mean a lot of changes in how you manage users, unless you pay a license for each user and "keep accessing the DB with all current users, instead of a single one", etc. 

Just my 2 cts.

regards

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 16 December 2022 21:01 PM UTC
Hi Mike,

Indepently of inside or outside of corparate network: For example, our application uses a separate Oracle user (schema) for each user. If we'd want to maitain that functionality in PS, then we'd have to pay a license for each one of them (unless I've been told wrong in the past). So for us to be able to affort PS, we would have to use a single (or few) connected user on the Server and all users would use that single Oracle scheme. This would mean we would have to introduce a user_id somehow in all of the tables, stored procedures, etc. for logging, auditing, different security per user, etc. The bult in user id of oracle would no longer indicate which of our users is running the app. We'd have to pass that in everywhere. A lot of refactoring in our case.

regards
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Saturday, 17 December 2022 16:00 PM UTC
Hi Miguel, You misunderstand how PowerServer is licensed. It is licensed per company regardless of # of applications or # of database or # of schema.... etc. The price of the license per company depends on total online user sessions (regardless of # of servers) and there is unlimited option if you don't want to have to worry about user session count. Please refer to pricing page: https://www.appeon.com/pricing#powerserver
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Saturday, 17 December 2022 18:15 PM UTC
Hi Armeen, I haven't said anything about licensing per company, or database. Per Oracle Schema = User ... yes! You'r confirming what I've said about having to pay for every user session (our setup is that every user has it's own Oracle schema in a single database ).

I do admit though that I should have used the word "user session" instead of "license per user".

Thanks for clearing it up!

Looking at the link you provided, it's not even that expensive, but for half of our customer it might be too expensive (they also have to pay "us" aside of that)

:)

  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 16 December 2022 01:39 AM UTC
  2. PowerBuilder
  3. # 2

To use PowerServer you really only need PB skills.  Most of the learning is around how to configure and deploy.  I suggest you contact our sales department for a free 1 hour training called jumpstart session.  In meantime, watch this 5 minute video to understand what PowerServer is:  https://youtu.be/66DIsDsisbE

 

Comment
Load more comments
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 16 December 2022 17:22 PM UTC
No, you are not required to take a class. I just think the 1 hour spent in the FREE training session is going to save you many many hours of making silly mistakes. But up to you.

As Chris mentioned, the documentation is valuable resource to learn PowerServer. There are many how-to guides and tutorials. Please spend time take a look at the docs.
  1. Helpful
Jay Hastings
  1. Jay Hastings
  2. Friday, 16 December 2022 17:27 PM UTC
Ha...no...I'm required by my work to take a training class so I'm looking for something. I can't do another SQL or Oracle APEX class.



Thanks again.
  1. Helpful
Jay Hastings
  1. Jay Hastings
  2. Friday, 16 December 2022 21:59 PM UTC
Thank you all.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.