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

Resolved PowerBuilder : Exposing API's

  1. How-to
0
Votes
Undo
  1. Marc Schmidtmayer
    Marc Schmidtmayer
  2. PowerBuilder
  3. Friday, 5 July 2024 12:06 PM UTC

Hi,

We are going to migrate from PowerBuilder 12.5 to PowerBuilder 2022.
The (urgent) question I have (and sorry if it's already discussed but couldn't find it), is if PowerBuilder 2022 can expose API's?
Calling it, yes... but exposing?

If not possible, what's the "way to go": .NET datawindow, PowerServer?
Any thoughts that could point me out in the right direction?

Thanks for any help,
Appreciated,
Marc.

Trouble with Yield()?
What values are set for PBESCAPEMENTMODE???
Responses (5)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 5 July 2024 18:02 PM UTC
  2. PowerBuilder
  3. # 1

You can use .NET DataStore (non-visual DataWindow) to create REST APIs with the productivity benefits of DataWindow technology: https://www.appeon.com/products/dotnet-datastore

By the way, it is included with your PowerBuilder subscription so nothing extra to buy.

Comment
Marc Schmidtmayer
  1. Marc Schmidtmayer
  2. Tuesday, 16 July 2024 10:31 AM UTC
Hi Armeen

Sorry about the late reply but was on holiday last week.

Thanks for your answer.

But it's not PowerBuilder but C# with a "converter" (for PowerScript to C#) and a/the datastore objects/class present to benefit from what's available in PowerBuilder.

  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 16 July 2024 22:03 PM UTC
Correct, the latest versions of PB has moved to true .NET for server-side programming. PowerScript is our standard for client-side programming. REST APIs are server-side so you need to code in C# not PowerScript.
  1. Helpful
There are no comments made yet.
Marc Schmidtmayer
Marc Schmidtmayer Accepted Answer Pending Moderation
  1. Friday, 5 July 2024 14:45 PM UTC
  2. PowerBuilder
  3. # 2

Hi Mike,

Thanks for your time.
And indeed, I also found that 3rth party software as an option.
But was looking if it was possible directly from PowerBuilder.
But apparently it is not... but possible via:

  • 3th party software
  • create something "external" (C#) and call it

Thanks again for your input... appreciated.

So the answer is: exposing API's can't be done directly from PowerBuilder 2022.

Thanks agian,
Marc.

 

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 5 July 2024 13:27 PM UTC
  2. PowerBuilder
  3. # 3

if you have NVOs (nothing visual), you can run them using:

you can use Topwiz Software - TopwizWeb (topwizprogramming.com) to create callable PB apis.

you can create an api in c# or something similar and use that to call powerbuilder code

these options allow you to use powerscript.  

 

 

.NET datawindow requires you to rewrite in c# what you have coded in powerscript, but allows you to keep the datawindow itself

powerserver is to enable you to run your full powerbuilder application as a cloud app (run fast/secure on the internet)

 

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 16 July 2024 19:57 PM UTC
Hi Mike;

FWIW: I support TopWizWeb in my STD Framework and I can attest to it's great ability to host NVUO's within IIS. Roland's new version uses the "FAST CGI" implementation and this makes the PB code execution way faster than Sybase's old PBWeb implementation. It also allows NVUO's to be exposed as either SOAP or REST Web API's.

Regards .. Chris
  1. Helpful 1
There are no comments made yet.
Marc Schmidtmayer
Marc Schmidtmayer Accepted Answer Pending Moderation
  1. Friday, 5 July 2024 12:56 PM UTC
  2. PowerBuilder
  3. # 4

Hi Chris,

Thanks for your reply... appreciated.
We're now using API calls (not SOAP because that's already possible) via a 3th party library.
So in terms of calling API's, I think we're ok (keeping the 3th party library or changing to the build-in functionalities of PowerBuilder 2022).

I'm rather looking for the possibilities to expose API's.
People (in our company) thought that this would be possible with the PowerBuilder (classic) 2022 (and already making technical designs) but I couldn't find any info that it is.
And I don't think it is possible, correct?
What are the options then: .NET datawindow or PowerServer?
And if possible, can you briefly explain what this would mean in regard with PowerBuilder (classic) 2022?

Thanks,
Marc.

 

 

 

Comment
Load more comments
Marc Schmidtmayer
  1. Marc Schmidtmayer
  2. Friday, 5 July 2024 14:52 PM UTC
Hello Chris,

For the SOAP calls: we just use standard PowerBuilder (only for the others (http or rest we use a 3th party software).

But then again, it's about exposing API's.

What I think I understand from your answer:

Can we stay in PowerBuilder 2022 (classic) and then need to buy .NET Datawindow and develop there some API's there so we can call them from PowerBuilder 20233 (classic)?

Is that a possibility?

So staying in PowerBuilder 2022 (classic) and do some dev in .NET Datawindow for the part that would need to expose API's?

Let me know if I'm off on this... :-(

Thanks again,

Marc.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 5 July 2024 16:54 PM UTC
For PB 2022 Rx, exposing NVUO's as Web Services you would now use the SnapDevelop product to build & expose your Web API;s.

For PowerScript to C#: https://docs.appeon.com/powerscriptmigrator2022/Working_with_PowerScript_Migrator/index.html

For the PS migrator, you would be migrating NVUO's

For DWO's to .NET DW's: https://docs.appeon.com/dwconverter2019r2/Working_with_DataWindow_Converter/index.html

HTH
  1. Helpful
Marc Schmidtmayer
  1. Marc Schmidtmayer
  2. Tuesday, 16 July 2024 10:35 AM UTC
Hi Chris

Sorry about the late reply but was on holiday last week.

Thanks for your answer.

I checked out the .NET DataStore but it's not PowerBuilder but C# with a "converter" (for PowerScript to C#) and a/the datastore objects/class present to benefit from what's available in PowerBuilder.

But indeed, that way it is possible.

Thanks for your time (and I will check out your links further in detail).

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 5 July 2024 12:29 PM UTC
  2. PowerBuilder
  3. # 5

Hi Marc;

  What is / are the API feature (s) that you are using in PB 12.5 that you need replicated in 2022 R3?

Regards ... Chris 

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.