Qlik > 实例探究 > 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
公司规模
Large Corporate
地区
  • America
国家
  • United States
产品
  • Attunity
  • Amazon Redshift
  • Microsoft SQL Server
技术栈
  • Cloud Computing
  • Big Data Analytics
  • Data Warehousing
实施规模
  • Enterprise-wide Deployment
影响指标
  • Cost Savings
  • Productivity Improvements
技术
  • 分析与建模 - 大数据分析
  • 基础设施即服务 (IaaS) - 云计算
适用功能
  • 销售与市场营销
用例
  • 实时定位系统 (RTLS)
服务
  • 云规划/设计/实施服务
  • 数据科学服务
关于客户
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.
挑战
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.
解决方案
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.
运营影响
  • 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.
数量效益
  • 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

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

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