Retail Enterprise Data Synchronization and Control
Rooms To Go needed a reliable stream of updates from their mainframe ERP to cloud databases
The Overview
Rooms To Go (RTG) is America’s #1 independent furniture company known for a broad range of stylish custom furniture displayed and packaged in complete room settings. With over 200 stores in 11 states/territories, Rooms To Go’s brick-and-mortar and online stories carry the nation’s largest furniture inventory. Rooms To Go needed a reliable stream of updates from their mainframe ERP to cloud databases, and their legacy system wasn’t cutting it. MercuryWorks implemented an enterprise replication and coordination system between the source and destination using a redundant cloud- and queue-based integration system.
The
Challenge
Rooms To Go’s enterprise-scale ERP operates on an on-premises legacy mainframe ERP system that serves as the system-of-record for considerable core business data. The mechanics of the legacy ERP are such that direct reads from cloud-based systems was undesirable. To support other applications within the RTG cloud ecosystem, RTG needed to reliably stream changesets/updates from the mainframe ERP to cloud databases.
The
Solution
Implement an enterprise replication and coordination system between the internal enterprise system (source) and Azure cloud-resident data system (destination) to be leveraged by RTG’s cloud services, intended to power in-development cloud applications. Throughout development and operations, deploy with disaster recovery-compliant DevOps procedures and verify accompanying SLA-compliant operation.
The
Results
At completion, the production solution provides a redundant cloud- and queue-based integration system that keeps the RTG Azure cloud database up to date with continual on-premises mainframe ERP data. A modern (and mobile-optimized) administrative dashboard provides insight into recent system updates, any data update failures and the ability to suspend operation as needed.
Dig In
App Features
Visualize
App Gallery
"So glad that we connected with MercuryWorks. Their ability to take proof-of-concept technology and get production- and operations-ready along with new features is nothing short of amazing!"
Todd Daniell
Director, Rooms to Go
Behind The Curtain
Core Technology
.NET Core
C# and Entity Framework were used to implement the system’s server-side framework for API endpoints including secure interchange, serverless execution and is coupled with OpenAPI/Swagger for service tier documentation.
SQL Server
Provides a robust data storehouse and query platform to store all enterprise data, marshal data for integration and provide a source to the app’s API tier. In-cloud SQL Server was used to provide instant scalability and rapid querying.
Microsoft Azure
Provides database storage, web app, authentication and web services. Azure provides an ideal solution for back end mobile applications with a multi-data center Platform as a Service (PaaS) cloud solution that requires extremely little oversight.
React
The React JavaScript framework provides the UI base for the entire system, providing rapid and smooth data fetching, storage and screen painting. React drives the administrative application, reporting and control screens.
