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

Resolved web apis

  1. How-to
0
Votes
Undo
  1. ephraim ben-eliezer
    ephraim ben-eliezer
  2. PowerBuilder
  3. Thursday, 16 April 2020 17:38 PM UTC

I need to setup a bunch of REST API's to be accessed by other companies to access my on-premise mssql data via stored procedures.  Our company uses Azure, can I deploy a snapdevelop PB project with APIs to Azure IIS Paas, or do I need VM in Azure.  Also, then can I setup a VPN in Azure through our company firewall to our onprem sql servers?  Anybody had experience with this?

Can TFS 2019 be used with PowerBuilder 11.5?
HTTP POST APPEON 2019
Accepted Answer
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 April 2020 18:23 PM UTC
  2. PowerBuilder
  3. # Permalink

The REST APIs you create with SnapDevelop supports .NET Core framework.  Compared to the old .NET framework, the .NET Core was redesigned by Microsoft to be cloud deployable and also supports multiple OS (e.g. Windows, Linux, etc.).  So to make a long story short... the answer is yes, you can use full cloud features of Azure and you DO NOT have to run VM.  In fact, you can even go farther with cloud features and go serverless using Azure Functions.  

Comment
There are no comments made yet.
Responses (4)
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 17 April 2020 02:49 AM UTC
  2. PowerBuilder
  3. # 1

VPN in Azure through our company firewall to on prem sql 

yes you have those abilities via the azure vpn, but you may need to change your firewall to one that azure supports (they have a list) 

Comment
There are no comments made yet.
ephraim ben-eliezer
ephraim ben-eliezer Accepted Answer Pending Moderation
  1. Thursday, 16 April 2020 20:28 PM UTC
  2. PowerBuilder
  3. # 2

Excellent, thanks.   Can you point me to the best place in the documentation where I can make a Proof of Concept that I can deploy to an Azure Function App

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 16 April 2020 21:01 PM UTC
Azure Functions is a feature of Azure not PowerBuilder. You will need to refer to documentation provided by Microsoft.

What PowerBuilder produces is standard C#/.NET Core project so there is no special instructions/limitations that Appeon needs to provide. You can confirm this by opening up your C# project in Visual Studio and can work on it in Visual Studio without any add-on tools from Appeon.
  1. Helpful
There are no comments made yet.
ephraim ben-eliezer
ephraim ben-eliezer Accepted Answer Pending Moderation
  1. Sunday, 19 April 2020 13:27 PM UTC
  2. PowerBuilder
  3. # 3

Okay, I got a proof of concept working in Azure.  It was really simple actually.   I opened the SnapDevelop project in Visual Studio, right click and Publish to Azure, and it made all the right resources for me up in Azure... it made an Azure App Service.    Would be nice if it could be done directly from SnapDevelop.

To talk to the onprem SQL, I created a Hybrid Connection in Azure.  It made me install a little agent inside my firewall, but it worked almost right away.  This is really cool and very cheap I think.

 

 

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Sunday, 19 April 2020 23:07 PM UTC
We plan to add such integrations to SnapDevelop in the future. It is possible to manually do deploy it, but I understand if it was integrated into SnapDevelop it saves time and hassle.
  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.