CapRelo – Data Warehouse

CapRelo was looking to upgrade their aging database. 1Rivet helped to define a solution of a unified data warehouse to manage their data from 2 separate databases (CapView and Phoenix).

  • Client dashboard and reporting integrated to newly created Data Warehouse
  • Stored procedures updated to use newly created data warehouse
  • Reporting to utilize new Data Warehouse

Outcome

  • GAP Analysis of existing Data Warehouse
  • Use of SSIS to fetch the data from Capview to Phoenix to build the new Data Warehouse
  • All reporting migrated to new Data Warehouse
Share This
Industries
Capabilities
Scope Of Service