“Near Real Time” Updates to SQL Server Data Warehouse
CAV Systems Ltd, a leading Israeli software company, recently completed delivery of a custom “data extraction” solution for Gillette Children’s Specialty Healthcare in St. Paul, Minnesota. Gillette is a nationally and internationally recognized leader in the diagnosis and treatment of children, teens and adults who have disabilities and complex medical conditions.
In the summer of 2013, Gillette embarked on an Enterprise Data Warehouse (EDW) initiative to analyze patient data with a view to identifying statistical patterns that could point to potential improvements across the organization’
While many EDW projects deliver valuable results from historical data, in the case of Gillette Children’s Specialty Healthcare, the requirements were more demanding with an initial goal that the EDW data being analyzed be no more than one day old, and a long term goal of “near real time”.
While the conceptual solution to these issues was obvious, namely, to incrementally update the SQL Server database with only the changes that occurred to the QCPR database following the initial build of the Data Warehouse, achieving this proved to be a challenge entailing a global search for possible solutions.
In January 2014, Gillette discovered CAV Systems Ltd and an intensive dialogue took place resulting in an onsite visit by CAV Systems’ IT professionals to Gillette’s facilities in St. Paul, MN at the end of March 2014. Today, six months later, Gillette’s Enterprise Data Warehouse initiative is on track and delivering valuable insights into the organization’
In the words of Tim Getsay, Vice President of Information Systems at Gillette, “CAV Systems’ expertise and mastery of bridging the worlds of MUMPS/Caché and relational databases was apparent from the very first day of their onsite visit in St. Paul”.
About CAV Systems Ltd
CAV Systems Ltd is engaged in the delivery of enterprise applications in the ERP, banking, and tourism sectors and is now deploying its solutions also in the mobile sector. The company is also engaged in projects where MUMPS expertise is essential to ensure a successful outcome.