• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • External application DB connection with Powerserver

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

Resolved External application DB connection with Powerserver

  1. How-to
0
Votes
Undo
  1. Anoop Chaurasia
    Anoop Chaurasia
  2. PowerServer
  3. Friday, 1 March 2024 06:43 AM UTC

I have a Calendar application which needs to connect to same database as powerserver application.

Is there a way to connect external application to database through powerserver?

Appeon Cluster configuration file
Swagger on HTTPs
Responses (4)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Saturday, 2 March 2024 05:02 AM UTC
  2. PowerServer
  3. # 1

What problem are you trying to solve for the calendar app by trying to connect to the database through PowerServer?  Why can't the calendar app just directly connect to the same database used by the PowerServer app?  What language is the calendar app written in.  Please answer these questions so we can guide you what is optimal way to solve the problem.

 

Comment
Anoop Chaurasia
  1. Anoop Chaurasia
  2. Saturday, 2 March 2024 14:31 PM UTC
Hi Armeen,



As calendar is added as a external files/application in the powerserver, it will try to connect from users system and database server is on our internal network and can not be connected from internet. Looking to implement a secured way to connect calendar to same database which is connected to powerserver application.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Sunday, 3 March 2024 21:15 PM UTC
What language is the calendar app developed in?

Is the database used by PowerServer app and calendar app is the same database?

  1. Helpful
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 1 March 2024 16:46 PM UTC
  2. PowerServer
  3. # 2

"Calendar application" -- you would just connect to the database it like it does already.  

 

Remember, the PB part of pb does not "connect to the database". Instead, it uses webapis to request data and/or update data.  the web apis are very specific to the PB application.

Comment
There are no comments made yet.
Anoop Chaurasia
Anoop Chaurasia Accepted Answer Pending Moderation
  1. Friday, 1 March 2024 14:17 PM UTC
  2. PowerServer
  3. # 3

Hi Chris,

Thank you for the response.

Can you please guide how to find PowerServer Web API that PB app is using. and how to consume. also can PowerServer Web API be used to generated entity in .Net application.

If there are any documentation for Payload and endpoints it will help. Can 

 

 

Thank You,

Anoop

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 1 March 2024 15:45 PM UTC
Hi Anoop;

The Web APIs automatically generated by the PS "plug-in" for the PS Project are specific to the PB App and not available to general consumption outside your PB App. However, you can see the C# Web API's generated by the PS Project when you look at the generated C# solution in SnapDevelop. The trick then would be to create "open" Web API equivalent's that any App could call using SnapDevelop. Unfortunately, a bit more work on your part.

Regards ... Chris
  1. Helpful
Anoop Chaurasia
  1. Anoop Chaurasia
  2. Saturday, 2 March 2024 14:26 PM UTC
I think this what needs to be done, looking into to add additional features in powerserver WebAPIs so that it can be used for depending applications. Not sure if SSO can also be an option.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 1 March 2024 12:47 PM UTC
  2. PowerServer
  3. # 4

Hi Anoop;

  Can your calendar application call RestFul Web API 's instead to the data it needs? If so, you might be able to have it call the related PowerServer Web API that your PB app is using.

   Another scenario that might work is if the calendar app can accept external data. Then your PB app could retrieve the necessary result set & save it to an external file for the calendar app to consume.

   A third idea would be to replicate the data that the the calendar app needs in a local DB synchronized by your PB app. Say for example using the SQLite (for example) DBMS. Then have the calendar app use that local DB as it's data source. 

Food for thought. HTH 

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.