Connect External Data to Quality Window in Minutes
The Quality Window SQL Wizard is a powerful administrative tool that allows you to turn data from external databases into fully functional Quality Window applications—without writing complex integration code. Whether your data lives in SQL Server, Access, Excel, or another OLE DB–compatible system, the SQL Wizard guides you step by step from connection to analysis.
This video walks through the full workflow of using the SQL Wizard, showing how Quality Window administrators can quickly retrieve process or event data directly from corporate databases and analyze it using the same SPC and SQC tools used for native Quality Window data.
What the SQL Wizard Helps You Do
The SQL Wizard is designed to bridge the gap between operational databases and quality analysis. Using a guided, five-step process, you can:
-
Connect to external databases using standard Windows OLE DB providers
-
Select tables and fields without manual schema mapping
-
Build and test SQL queries with live previews
-
Prompt users for values like Plant, Product, Batch, or Date at runtime
-
Automatically generate a Quality Window application from the results
Once saved, the generated application behaves like any other Quality Window application. Each time it is opened, the SQL query runs, existing data is cleared, and fresh results are loaded—ready for charts, statistics, alarms, Views, and reports.
Designed for Administrators, Not SQL Experts
While the SQL Wizard supports advanced SQL when needed, it is intentionally designed for users who may not be database specialists. Common tasks such as filtering, sorting, selecting date and time fields, or reshaping data are handled directly in the Wizard interface.
Advanced options covered in the video include:
-
Identifying Date and Time fields so data aligns correctly in Quality Window
-
Transposing “long format” historian data into a wide, analysis-ready structure
-
Extrapolating values to handle gaps in time-based data
-
Using prompts to create reusable, parameter-driven applications
Extend and Standardize After Import
After creating an application with the SQL Wizard, administrators can open it in Quality Window Admin to apply limits, rules, calculated variables, naming standards, and Views. This makes the SQL Wizard ideal for standardizing how external data is reviewed, shared, and analyzed across teams.
Go Deeper with the SQL Wizard Admin Guide
This video provides a practical walkthrough, but the Quality Window SQL Wizard Admin Guide is the definitive reference. The PDF covers connection requirements, prompt types, transpose and extrapolate rules, troubleshooting, and examples in detail.
You can download the full guide here: QW SQL Wizard Admin Guide
If you are responsible for integrating external data into Quality Window or want to reduce manual data handling while maintaining consistent analysis, the SQL Wizard is the fastest way to get there.