Creating a Denodo Data Virtualization Layer for Illumina Quality
Wednesday November 13, 2019
Project Goal
Create a Denodo data virtualization layer (that integrates all enterprise data across disparate systems, manages the unified data, and delivers it to business users in real time) to support the data access needs of the Quality department at Illumina.
Results:
Replicated and tested hundreds of views from legacy systems into Denodo virtual databases
Made architectural recommendations and optimization recommendations based on industry best practices exceeding expectations
Created a repository of system views, intermediate views, and business views that can be leveraged by developers to answer future Illumina quality questions not yet asked
Significance:
Engineers, analysts, and other quality data users have access to real-time quality data including up-to-date non-conformances, corrective actions, complaints, audits, and more
Analysts and developers have the foundation and means to create new dashboards and reports using validated data without needing to worry about the complications of underlying data source connections