The client faced a complex challenge: collecting Modbus-based data from remote devices and securely transmitting it to multiple SQL databases, each serving different operational needs. The solution had to be scalable, secure, and resilient to connectivity issues, while minimizing manual intervention.

A robust architecture was deployed using RedLion protocol translators to read Modbus data and convert it into SQL bulk inserts. These inserts were structured to align with the client’s reporting and operational requirements. To ensure secure and reliable data transmission: Meraki firewalls were installed at each site. A site-to-site VPN tunnel was established over SD-WAN, providing redundancy via cellular and satellite internet connections. The VPN tunnel enabled direct, secure access from RedLion devices to SQL servers, protected by access control lists (ACLs). A “phone home” network security model was implemented to prevent man-in-the-middle attacks and enforce least privilege access.

Automated data ingestion into SQL databases with minimal manual oversight. Improved data availability for billing, diagnostics, and monitoring. Hardened network security with layered protections and encrypted tunnels. Scalable deployment model: Each site takes approximately 6 hours to configure at a cost of $2,500 per site.