Case Study
Data Warehouse Migration and Multi-tenancy for Large IDN
Data Warehouse Migration and Multi-tenancy for Large IDN www.citiustech.com Client Requirement CitiusTech Solution Solution Design CitiusTech’s solution had the following features: Integration of clinical, claims, pharmacy, laboratory, prior-authorization, drug formulary and survey data into IBM UDMH in IBM PDA (Netezza) environment Development of a HIPAA compliant multi-tenancy architecture which included identification of user groups on the basis of their data access needs Use of CitiusTech’s accelerators such as File Reader and Data Quality Framework (built using IBM DataStage technology) to extract, transform and load data to IBM UDMH Atomic Warehouse Model (AWM) and Dimensional Warehouse Model (DWM) IBM tools like IIS and Aginity to develop ELT jobs, FastTrack for maintaining mappi