Qlik > Case Studies > 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
Customer Company Size
Mid-size Company
Region
  • America
Country
  • United States
Product
  • Qlik Data Integration
  • Amazon RDS
  • Wombat Security Education Platform
Tech Stack
  • Amazon Cloud
  • Postgres database
  • MySQL
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Digital Expertise
Technology Category
  • Infrastructure as a Service (IaaS) - Cloud Computing
Applicable Functions
  • Business Operation
Use Cases
  • Cybersecurity
Services
  • Cloud Planning, Design & Implementation Services
  • Cybersecurity Services
About The Customer
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%.
The Challenge
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.
The Solution
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.
Operational Impact
  • 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.
Quantitative Benefit
  • 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

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.