1. Placide Da Silva
  2. PowerBuilder
  3. Thursday, 21 March 2019 22:22 PM UTC

Hello,

I have an application in PB17 R3. I would like to have a table in cloud with the status of the users. So every time a user logs in, the application will check the status in the table in cloud. And accordingly the application will proceed or shut down. My question:

do I need to have the cloud version of PB to accomplish this?

Or Is there another way to accomplish the same thing?

Please help.

Thanks.

Placide

Accepted Answer
Placide Da Silva Accepted Answer Pending Moderation
  1. Friday, 22 March 2019 19:51 PM UTC
  2. PowerBuilder
  3. # Permalink

Hello,

My thanks to you all (Chris, Kevin, Rolland, Armeen). It is heart warming to belong to a community of geniuses willing to share their knowledge. I am grateful.

I am going to try the two solutions immediately and keep you posted on the progress.

Have a great day.

Placide

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 22 March 2019 14:51 PM UTC
  2. PowerBuilder
  3. # 1

Hi Placide;

   That is an excellent idea for your DBMS! The cloud is basically a fancy name for the old "service bureau" term. Cloud providers can house your DBMS on their platform. You can then expose the DBMS via its Cloud IP address. This would normally be done by creating an O/S instance (ie: MS-Windows Server edition). I myself personally use Amazon's EC2 feature to host my SA & SS DBMS. Most cloud vendors offer the same. Once the instance is built, its assigned an internal IP address.

   The next thing I did was to create an Amazon "Elastic" address. This allows the cloud vendor to assign a fixed IP address that is externally visible. It also allows for the EC2 virtual machine to be restarted on any other VM where the IP address is different. However, Amazon always keeps the Elastic IP address pointing to the ever changing internal EC2 machine's IP address. That way, your PB App only needs to connect to (know about) the external Elastic IP address.

   In the case of the Elastic IP address that gets redirected internally - your App really only needs to know what "port" your DBMS is listening to in order to complete the DB connection. In the case of my SS's its port 1433. Note that many other vendors implement this "Elastic" IP concept (ie: RackSpace, IBM. etc).

FYI:  https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/elastic-ip-addresses-eip.html

HTH

Regards

 

Comment
There are no comments made yet.
Kevin Ridley Accepted Answer Pending Moderation
  1. Friday, 22 March 2019 13:33 PM UTC
  2. PowerBuilder
  3. # 2

I agree with Armeen, create a webservice to do this validation and call it from your PB app.

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 22 March 2019 02:11 AM UTC
  2. PowerBuilder
  3. # 3

 

A desktop app can use the GetURL function to grab a text file or run a web script.

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 22 March 2019 00:24 AM UTC
  2. PowerBuilder
  3. # 4

Sounds like it would be best you create a C# Web API using PowerBuilder 2019 and then call this Web API from your PB app using the new enhanced RESTClient (enhanced in PowerBuilder 2019). 

There are some simple tutorials here to help you get started: https://www.appeon.com/support/documents/appeon_online_help/index.html

And yes, you will need the Cloud Edition to create C# Web APIs.

Comment
There are no comments made yet.
Placide Da Silva Accepted Answer Pending Moderation
  1. Friday, 22 March 2019 00:15 AM UTC
  2. PowerBuilder
  3. # 5

Thanks very much for replying. I forgot to say that my clients are not in the same network or location. Just like when you get into PowerBuilder, Appeon validates your subscription. That's the idea. 

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 21 March 2019 23:06 PM UTC
  2. PowerBuilder
  3. # 6

This is a simple table updae and validation.
I'm not sure why the table would need to be in the cloud, but it most certainly can be done in that manner.

You can also do this in a client/server app by loading the contents of the table into the app and updatingthe table as required. Set a time to refresh the table every so often, if required.


Olan

Comment
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.