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

Edit This Case Study Record

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

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

Qlik

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

Impact #1	Attunity’s intuitive user interface eliminated development, consulting, and professional services costs.
Impact #2	DomainPower was able to get the Amazon Redshift project up and running faster than initially expected.
Impact #3	Attunity customer service was highly responsive, enabling DomainPower to work swiftly towards its successful data loading and near real-time synchronization of information.

Impact #1

Attunity’s intuitive user interface eliminated development, consulting, and professional services costs.

Impact #2

DomainPower was able to get the Amazon Redshift project up and running faster than initially expected.

Impact #3

Attunity customer service was highly responsive, enabling DomainPower to work swiftly towards its successful data loading and near real-time synchronization of information.

Benefit #1	Saved an estimated annual cost of nearly $60,000.
Benefit #2	Implemented an Amazon Redshift data warehouse three months sooner than anticipated.

Benefit #1

Saved an estimated annual cost of nearly $60,000.

Benefit #2

Implemented an Amazon Redshift data warehouse three months sooner than anticipated.

Download PDF Version

Overview

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

Operational Impact

Quantitative Benefit