Download PDF
DomainPower Enables Big Data Analytics in the Cloud with Attunity and Amazon Redshift
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
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.
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 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
Quantitative Benefit
Related Case Studies.
Case Study
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.
Case Study
Samsonite Track&Go
Travellers spend their lives discovering new places and meeting new people from all around the world. It can be such a wonderful experience, but sometimes it can turn into a disaster when your luggage gets lost. In 2014 alone, more than 24 million pieces of baggage were lost. Fortunately, 95% of them were found and returned to their owners. However, that leaves more than 1 million items of baggage that have never been recovered.
