Hello,
I'm trying to figure out the best solution to store and forward SQL data at a remote site. The current system setup looks like this.
Central site - Ignition Gateway with SQL bridge with transaction group pushing data to Azure SQL instance. Data is pushed once a minute based on trigger tag.
- Site to Site VPN to remote site
- Central gateway pulls data from 2 PLCs at remote site and pushes to Azure SQL
- If site to site VPN goes down, data is lost
Remote site - Ignition Edge Panel and Sync Services (not configured yet, need to create project)
I need to be able to store and forward data from remote site to Azure SQL when site to site VPN goes down between central and remote site. I know this is possible with Edge Sync services for the central historian (currently Mariadb) but I need store and forward capability for the 1 minute SQL data to Azure.
One option appears to be buying the SQL bridge module for the remote site and setting up a gateway there just for this purpose. Then creating a transaction group for the remote site that pushes directly to Azure SQL. So if central/remote VPN connection goes down or Internet at remote site goes down the SQL data will store and forward.
Curious if anybody has run into a similar issue and what the solution was.
Thanks!