Qlik > Case Studies > Glidewell Laboratories Gains Deeper Data Insights Faster with Amazon Redshift and Attunity

Glidewell Laboratories Gains Deeper Data Insights Faster with Amazon Redshift and Attunity

Qlik Logo
Customer Company Size
Large Corporate
Region
  • America
Country
  • United States
Product
  • Amazon Redshift
  • Attunity
  • Tableau Software
  • Dundas Data Visualization
Tech Stack
  • Cloud Computing
  • Data Warehousing
  • Data Migration
  • Data Visualization
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Cost Savings
Technology Category
  • Infrastructure as a Service (IaaS) - Cloud Computing
  • Analytics & Modeling - Data-as-a-Service
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Healthcare & Hospitals
Applicable Functions
  • Discrete Manufacturing
  • Quality Assurance
Use Cases
  • Predictive Maintenance
  • Manufacturing System Automation
Services
  • Cloud Planning, Design & Implementation Services
  • Data Science Services
About The Customer
Glidewell Laboratories is the largest dental lab in the United States, manufacturing over three million custom dental products annually. The company's products include crowns, dentures, and custom prosthetics made from molds at dentist’s offices. When Glidewell adopted the CAD/CAM Digital Manufacturing standard, the amount of data the company had to store and analyze exploded tenfold, to over 150 million records. To manage this change, Glidewell aimed to create a more responsive, cloud-based infrastructure to support business intelligence and analytics. However, the company faced challenges in migrating its vast amount of data to the cloud.
The Challenge
Glidewell Laboratories, the largest dental lab in the United States, faced a significant challenge when they adopted the CAD/CAM Digital Manufacturing standard. The adoption led to a tenfold increase in the amount of data the company had to store and analyze, reaching over 150 million records. To manage this change, Glidewell aimed to create a more responsive, cloud-based infrastructure to support business intelligence and analytics. However, cloud migrations can be tricky, often requiring custom coding that slows down the process, reducing the time-based value of analytics for quick business decision-making. Glidewell's on-premises data storage solution included over 80 separate databases, adding to the complexity of the migration.
The Solution
Glidewell identified Amazon Redshift and Attunity as an ideal solution for their data migration challenge. Amazon Redshift, a powerful data warehousing solution from Amazon Web Services (AWS), met Glidewell’s need for a progressive data warehouse and analytics stack. The dynamic, cloud-based platform features low barriers to entry and minimal up-front costs with a self-service model. The fully-managed, petabyte-scale data warehouse service would make it possible to analyze data simply and cost-effectively using Glidewell’s preferred business intelligence tools—Tableau Software for analytics and Dundas Data Visualization for dashboards. For the data migration, Glidewell’s team considered traditional extract, transform, and load (ETL) tools, but the customization, ongoing IT management, and extensive training required rendered it too cumbersome for Glidewell’s needs. That’s when an AWS team member introduced Attunity, an Amazon Partner Network (APN) company. The powerful, yet affordable Attunity for Redshift solution enabled Glidewell to replicate data from Microsoft SQL Server to Amazon Redshift with just a few clicks, without the need for costly customizations or specialized training.
Operational Impact
  • Quick, easy setup with monitoring for peace of mind, control, and auditing
  • Secure data transfer with industry standard SSL encryption
  • Data integrity with check mechanisms
  • Efficient data loading, eliminating the need for a full-time database administrator
  • Easy, fast integration

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.