Qlik > 实例探究 > Wombat Security Technologies uses Qlik Data Integration to migrate data to Amazon RDS

Wombat Security Technologies uses Qlik Data Integration to migrate data to Amazon RDS

Qlik Logo
公司规模
Mid-size Company
地区
  • America
国家
  • United States
产品
  • Qlik Data Integration
  • Amazon RDS
  • Wombat Security Education Platform
技术栈
  • Amazon Cloud
  • Postgres database
  • MySQL
实施规模
  • Enterprise-wide Deployment
影响指标
  • Productivity Improvements
  • Digital Expertise
技术
  • 基础设施即服务 (IaaS) - 云计算
适用功能
  • 商业运营
用例
  • 网络安全
服务
  • 云规划/设计/实施服务
  • 网络安全服务
关于客户
Wombat Security Technologies is a company born from research at the world-renowned Carnegie Mellon University (CMU). While at CMU, the cofounders lead the largest national research project on combating phishing attacks. Their goal was to address the human element in cyber security and develop novel, more effective anti-phishing filtering solutions. With funding from the National Science Foundation and the Department of Defense, they developed a suite of cyber security software training and filtering technologies which are the foundation for Wombat Security Technologies’ line of products. Their Security Education Platform includes integrated knowledge assessments, a library of simulated attacks, and interactive training modules, which have been proven to reduce successful phishing attacks and malware infections by up to 90%.
挑战
When Ian Kane, Senior Data Warehouse Architect, joined Wombat Security Technologies, his job was to build a data warehouse from scratch. With the Wombat Security Technologies already on the Amazon Relational Database Service (RDS) in MySQL, moving the data to a Postgres database Amazon RDS was a natural choice given that they were already on the Amazon Cloud. Most of the ETL coding would be usable on a standard Postgres RDBMS. Because they regenerate their data warehouse every 15 minutes doing ETL, they needed a solution that could do log-based change data capture (CDC) to migrate their data continuously.
解决方案
After performing research on the AWS Marketplace, Kane found Qlik and he used the free, 30-day trial to test how data migration would work to the Amazon Cloud. He found that Qlik could move his data continuously with zero downtime. The change data capture (CDC) offered with Qlik worked to move data near real-time for Wombat’s frequent data loading to a Postgres database on Amazon RDS where they were able to move a half billion records quickly and easily.
运营影响
  • The solution provided by Qlik allowed for continuous data migration with zero downtime.
  • The change data capture (CDC) feature of Qlik enabled near real-time data loading to a Postgres database on Amazon RDS.
数量效益
  • Successfully moved a half billion records quickly and easily.

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 的任何营销电子邮件。
提交

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