Veritix Created Competitive Advantage Using Attunity and Amazon Redshift

• 基础设施即服务 (IaaS) - 云计算

• 销售与市场营销

• 云规划/设计/实施服务

Veritix’s transactional database was used for both production purposes and reporting. As a result, it wasn’t optimized for analytics and performance was a concern. Running analytics on the production machine would have overwhelmed system resources. Rojas’ team decided to create a separate data warehouse which would store a decade of event data, as well as additional information to enrich analyses such as weather, drive times, and fan income. The project goals were twofold: to develop a high-performance analytics data warehouse and to tune the existing production database for transactions. Veritix was primarily using Oracle, but they also had some Microsoft SQL Server databases. As they looked to expand their data warehouse, they performed a cost analysis of a traditional, on-premises data warehouse and found that it would cost millions to achieve the performance levels that they required.

Veritix (now part of AXS) specialized in digital ticketing, event marketing, and relationship management applications for professional sports teams, artists, and entertainment venues around the world. With their analytics reporting, their customers can target demographic groups more effectively, improve season ticket renewal rates, and bring new fans into arenas.

Veritix looked to the cloud for a solution. By doing a series of cluster tests on Amazon Redshift, they found that the cloud-based data warehouse could deliver the performance that the company needed while supporting multiple database vendors. And, Amazon Redshift pricing was an order of magnitude less expensive than the other solutions they looked at. After deciding to move forward with an Amazon Redshift data warehouse, Veritix began exploring ways to replicate data from their on-premises databases to the cloud. Initially, the team assumed that they would need to build custom tools or rely on an off-the-shelf solution like Microsoft SSIS. They did an initial experiment which started with the team creating a backup. Then they moved it to the cloud, restored the backup to a staging database, and tried to move the staging database to Amazon Redshift. Veritix was disappointed to find that it took seven hours to transfer the data, plus an additional 14 hours to restore it to the staging database. This approach was so time consuming that it would only be possible to move information to Amazon Redshift once a day. One of Veritix’s data scientists mentioned the challenges to the team at Amazon Web Services who recommended Attunity for the job.

• The Veritix team found that it took just two hours to install, configure, and move hundreds of millions of records to the Amazon Redshift data warehouse using Attunity.
• The data warehouse now contains around three terabytes of information, with billions of records available for customer analytics.
• Not only has Attunity met Veritix’s performance requirements, it has also exceeded the team’s expectations in terms of ease of use.

• Reduced data transfer time from 7 hours to 2 hours
• Reduced data restoration time from 14 hours to negligible