John Hohn

About author

Jason Anderson is a Partner at Comp Three Inc. He specializes in database design, data migration and BI architecture.

Author's posts

PDMW: A Data Warehouse for Windchill

Like most useful products, PDMW was inspired by actual customer needs.

Defect Reporting Case Study

1. Case Overview The customer needed enterprise-wide strategic and operational quality assurance and defect reporting, for standard measures like Defects Per Unit, First Pass Yield and Defects per Million Opportunities.

Building Custom ETL Tools When Necessitated by Massive Data Volumes

Overview This blog will show some tips and tricks that Comp Three employed to develop a custom ETL process for a full and delta load from a multi-billion row transactional Product Engineering SQL database, to a simplified data store useful for BI tool connectivity, integrations to other downstream systems, or data migrations off the source system.

Windchill Migration Case Study

{ border: 1px; } th, td { padding: 5px; text-align: center; vertical-align: top; } 1.