Creating a Denodo Data Virtualization Layer for Illumina Quality

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

You might also like