We have a need for a new App that needs to reside in the cloud. The app needs to get updated by our internal data on an hourly basis. The internal system has DBF, and Microsoft Sql Server data. We are using Web Connection with some apps running as Foxpro clients and other apps using React and Bootstrap.

The cloud data in the future may need a CMMC/Hippa component so the thinking is to use AWS or Azure. React and Bootstrap would obviously be the client.

What has been the experience of others in implementing Web Connection on either of those platforms? Pitfalls and tips?

Thanks,

Josh

Define by what you mean by 'in the cloud' as that can mean many things.

For Web Connection I think the only realistic option is a virtual machine. Where you host it is really going to make zero difference in security (other than physical location security).

That said you can host Web Connection in a VM anywhere you like and it'll work the same anywhere. Long detailed info on configuration and setup can be found in this Southwest Fox White Paper here:

Deploying and Configuring Web Connection Applications

While there are other services like Azure Web Sites or other hosted Web services, they're not well suited to Web Connection apps due to the runtime install requirements of FoxPro which won't be present, and the fact that they are basically static installations that can be nuked and re-flated on a different box. No state is preserved when that happens - ie. any app deployed has to be in the exact run state it needs. It can be done, but it's not the way most people are building Web Connection applications with basically no state whatsoever on the server box (ie. using Azure services like SQL Server, Configuration storage in Azure etc.).

That's why I asked, as 'in the cloud' can mean many very, very different things...