Hello everyone!

[Sergiu]

Can somebody help me with a GCP Architecture (with the required diagram schema) for the following scenario: 

"We are a restaurant with multiple locations. Every location has its own point of sell (hardware with licensed software and sql server) running locally. We often face issues in that our employees forget to turn on the OpenVPN client or turn the POS off so we don't sometimes have data for even a few days. For analytics, we use the same application that is used for POS, but it is very limited without any customization. We need better analytics for planning and understanding our business 

POS - Windows 10, SQL Server Express, OpenVPN

USB Disk - each POS has a USB disk plugged in for backup; disk sometimes fail. We also have problems with restoring a backup

VPN Server - ubuntu 18.04 running openvpn server

Data Server - Windows Server 2019. The server is responsible for downloading data form POS and preparing it before all the data are put in global db. We are using dump method and import on data server and then synchronizing with the global db. 

App VM - Window Server 2019 - we are using this machine only to connect to global db for analytics

Analytics - are very limited to what was implemented in an application, we have problems with our provider adding functionality that we need and they take a lot of time. The data is already in the database it just takes them a lot of time to implement showing them in the application"

Thank you very much for your help!

[venkateshramasa]

What is the business objective ? What are you trying to do when you say Analytics? 

[Sergiu]

The business objective is to move their current infrastructure on GCP.

They also need a more customised analytic tool for their infrastructure in GCP to be able to planning and understanding their business.

Bellow you can find their current architecture diagram:

Any help will be highly appreciated.

Thank you.

[vmdnep]

Dealing with multiple restaurant locations can be quite a challenge, especially when it comes to data management and analytics. Your current setup seems to be causing some operational hiccups, but fret not, there's a solution! Consider leveraging Google Cloud Consulting services to streamline your infrastructure and enhance your analytics capabilities. By migrating your POS systems and data servers to Google Cloud Platform, you can ensure seamless data access, reliable backups, and advanced analytics tools tailored to your business needs. Plus, with Google Cloud's scalable architecture, you can future-proof your operations. Check out Google Cloud Consulting for more insights and solutions.