McCann – Data Strategy

Conducted an in-depth evaluation on the current on-premises data warehouse and provided future state recommendation on building a real-time event-based architecture on Azure.

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.


  • 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.
Share This
Scope Of Service