1. Roel Pollet
  2. SnapDevelop
  3. Thursday, 7 October 2021 08:33 AM UTC

Hello all,

 

For our PB app we use a local Sybase DataBase. We have about 300 customers, so also 300 DB's.

I've created a REST API with SnapDevelop so external parties can Get some info. The API connects to the local DB through ODBC.

For the moment we install the API on a local IIS. But of course, if you have to this 300 times, that's no fun.

 

What's the best way to do this set-up?

I know we could place the 300 local DB's in the cloud. But that's not easy to do/explain. I'm also afraid about the connection speed (ODBC from local client to cloud DB).

We could set up the API in the cloud and connect to the local DB's. Is that ODBC connection fast enough? I guess customers will have to open some ports on the firewall, so is this secure?

Using a cloud API and a local API is an other idea. But this means doing this again 300 times.

 

Any advice?

 

Thanks,

Roel

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 7 October 2021 15:07 PM UTC
  2. SnapDevelop
  3. # 1

You want the connection between the Web API and DB to be local rather than over Internet for security, performance, and stability reasons.  So given what you said about each customer hosts their own database on-premise and you do not want to move the databases to cloud, then unfortunately each of your customers would need to setup an IIS Web server to host the Web API themselves.

Comment
  1. Miguel Leeuwe
  2. Friday, 8 October 2021 00:54 AM UTC
I have 0 experience and knowledge of Docker / Kubernetes, but doesn't this sound like an ideal use case for deployment using containers?

regards.
  1. Helpful 1
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 7 October 2021 14:45 PM UTC
  2. SnapDevelop
  3. # 2

Are the 300 databases in same location/network?

Comment
  1. Roel Pollet
  2. Thursday, 7 October 2021 14:51 PM UTC
No, 300 different customers who all have their own DB.
  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.
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.