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.