Qlik > Case Studies > DomainPower Enables Big Data Analytics in the Cloud with Attunity and Amazon Redshift

DomainPower Enables Big Data Analytics in the Cloud with Attunity and Amazon Redshift

Qlik Logo
Customer Company Size
Large Corporate
Region
  • America
Country
  • United States
Product
  • Attunity
  • Amazon Redshift
  • Microsoft SQL Server
Tech Stack
  • Cloud Computing
  • Big Data Analytics
  • Data Warehousing
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Cost Savings
  • Productivity Improvements
Technology Category
  • Analytics & Modeling - Big Data Analytics
  • Infrastructure as a Service (IaaS) - Cloud Computing
Applicable Functions
  • Sales & Marketing
Use Cases
  • Real-Time Location System (RTLS)
Services
  • Cloud Planning, Design & Implementation Services
  • Data Science Services
About The Customer
DomainPower is the leading real-time bidding exchange that connects online advertisers to rich native advertising inventory. The company deals with a high volume of transactional data derived from its online auctions. The data is crucial for the analysis of market trends related to its supply inventory and the value of advertising. To effectively manage and analyze this data, DomainPower decided to explore Amazon Web Services. However, the company faced challenges with daily source data changes, which made it difficult to keep the on-premises Microsoft SQL Server system and the Amazon Redshift data warehouse in sync.
The Challenge
DomainPower, a leading real-time bidding exchange connecting online advertisers to rich native advertising inventory, was dealing with a high volume of transactional data from its online auctions. The company recognized the need for a data warehouse to analyze market trends related to its supply inventory and the value of advertising. They decided to explore Amazon Web Services, but the daily source data changes proved to be a challenge. Daily batch data updates between DomainPower’s on-premises Microsoft SQL Server system and an Amazon Redshift data warehouse would not meet the business needs. This represented an obstacle to using Amazon Redshift, since keeping the environments in sync might require significant development effort and ongoing maintenance.
The Solution
DomainPower decided to conduct a free trial of Attunity software which they found on the AWS Marketplace. The trial proved that it was possible to load transactional auction data to Amazon Redshift while keeping referential customer data and supply inventories continually in sync with the data in Microsoft SQL Server. Predictive analytics were run in Amazon Redshift using queries built by DomainPower, then summary analyses were sent back to the online trading application at regular intervals. Attunity software proved to be easy to set up deploy and to maintain true data integrity. Key aspects leading to the success of the project included Attunity’s ease-of-use approach, faster implementation, and highly responsive customer service.
Operational Impact
  • Attunity’s intuitive user interface eliminated development, consulting, and professional services costs.
  • DomainPower was able to get the Amazon Redshift project up and running faster than initially expected.
  • Attunity customer service was highly responsive, enabling DomainPower to work swiftly towards its successful data loading and near real-time synchronization of information.
Quantitative Benefit
  • Saved an estimated annual cost of nearly $60,000.
  • Implemented an Amazon Redshift data warehouse three months sooner than anticipated.

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.