Qlik > 实例探究 > 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
公司规模
Large Corporate
地区
  • America
国家
  • United States
产品
  • Amazon Redshift
  • Attunity
  • Tableau Software
  • Dundas Data Visualization
技术栈
  • Cloud Computing
  • Data Warehousing
  • Data Migration
  • Data Visualization
实施规模
  • Enterprise-wide Deployment
影响指标
  • Productivity Improvements
  • Cost Savings
技术
  • 基础设施即服务 (IaaS) - 云计算
  • 分析与建模 - 数据即服务
  • 分析与建模 - 实时分析
适用行业
  • 医疗保健和医院
适用功能
  • 离散制造
  • 质量保证
用例
  • 预测性维护
  • 自动化制造系统
服务
  • 云规划/设计/实施服务
  • 数据科学服务
关于客户
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.
挑战
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.
解决方案
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.
运营影响
  • 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

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。