Data Warehouse Modernization Architecture

Client was looking to migrate an aging on-premises data warehouse which was built on batch-based architecture. 1Rivet helped the client in architecting real-time event-driven architecture with Azure based services. The future state architecture recommendation also included outbound events which could be used by a consuming application and a near real time & data streaming to refresh data to the reporting engine.

Outcome

Identified Azure Services for real time event-driven architecture.
Created Event Driven architecture for the future scope.
Future recommendation included intermediate architecture and a future state architecture.
Future state architecture included the primary and secondary recommendations.
Provided cost analysis for secondary recommendations.
Included Solution architecture, deployment architecture and integration architecture.
Provided recommendation for batch-based integration, near real time integration, and real time integration.
Documented all the gap in the current state architecture.
Documented security recommendation for all identified Azure services.