Case Study: Learn how Citrix saves time and money on analytics with Matillion ETL for Amazon Redshift

You may be wondering what your organization could gain from implementing a tool like Matillion. There are a number of benefits that could save your business time and money, and that’s why customers like GE, Converse, and Docusign use Matillion every day.

These benefits include:

  • An instant-on purchase experience, to get you up and running in just a few clicks
  • A pay-as-you-go billing model, to eliminate lengthy procurement processes
  • An intuitive user interface, to minimize technical pain and speed up time-to-results

But don’t just take our word for it. Read on this case study to find out how Citrix’s ShareFile was able to actualize these benefits, and save time and money on their analytics project to reduced Matillion ETL development and maintenance efforts by around 50% faster than hand-coding with Amazon Redshift and Matillion.

Case Study: Learn how Citrix saves time and money on analytics with Matillion ETL for Amazon Redshift
Case Study: Learn how Citrix saves time and money on analytics with Matillion ETL for Amazon Redshift

Citrix, a cloud computing company focused on enabling mobile workstyles, is the creator of ShareFile, a secure file sync and sharing platform that helps business users collaborate internally and with their customers.

To optimize ShareFile and drive customer satisfaction, Citrix knew it needed to gather data related to how people were utilizing the application. With limited resources, and over 400 data events per second hitting the ShareFile pipeline on a typical day, Citrix required an advanced solution that featured speed, power, and accuracy.

The decision to use Amazon Redshift and Matillion ETL

In 2016, Citrix began using Amazon Redshift from AWS, a fast, fully managed data warehouse that allows it to run complex analytic queries that help gain new insights into how customers use ShareFile. The application produces an event data pipeline that is written into Amazon Redshift, which delivers fast query performance by using columnar storage technology to improve I/O efficiency and by parallelising queries across multiple nodes.

When the executive team at Citrix recognised the need to bolster their use of Amazon Redshift to improve their data and reporting efforts, they turned to Matillion ETL. Built specifically for Amazon Redshift, Matillion ETL is a data integration tool that allows Citrix to aggregate data from multiple databases and provides structure to the insights and data visualisations the organisation needs. Procured from AWS Marketplace in a matter of minutes, Matillion ETL allowed Citrix to quickly move relational data sources into Amazon Redshift, and to embellish event-based data stored there with customer and location information from Microsoft SQL Server.

Time-to-value accelerated

Matillion ETL and Amazon Redshift have enabled Citrix to easily identify the most popular ShareFile features, as well as those that may be underperforming. With this knowledge in hand, Citrix can make informed decisions regarding where to focus product improvement efforts. The ability to load millions of rows of data into Amazon Redshift in minutes means Matillion ETL has greatly increased the efficiency and agility of Citrix’s analytics initiatives.

Optimising collaboration

Citrix can now gather, collate, and analyse user data faster and on a more granular level than it ever could have when its data teams were handcoding analytics workloads. Matillion ETL and Amazon Redshift enable the organisation to quickly process critical information regarding user location, feature use, multiple users associated with a single account, and much more. Because these kinds of details have typically been stored in scattered data warehouses, the process of extracting a meaningful story from all these disparate elements used to be a long and tedious one.

We were in a place where we had access to a lot of really good information and data on our events platform, but not enough to tell the whole story. That’s where Matillion came in. – Sheeya Gem, Staff Database Engineer, Citrix

Because of the efficiency Matillion ETL provides, Citrix saves time and money by dramatically reducing the effort required to perform complex analytics operations. Matillion ETL’s graphical interface features live feedback, validation, and data preview so Citrix can see data being processed in-job, eliminating the need for time-consuming test cycles like there is with typical ETL tools. This reduces ETL development and maintenance efforts by around 50%.

An ETL solution that drives innovation and customer satisfaction

Matillion ETL’s push-down data transformation model harnesses the processing power of Amazon Redshift for transforming data. This helps deliver the performance and scalability Citrix needs to process massive amounts of event data – 50% faster than it was able to previously, when its data science team was hand-coding ETL workloads. As Citrix continues to improve ShareFile for its customers, Matillion ETL puts powerful orchestration tools at its disposal. The tool enables Citrix to choreograph data transformations and offers additional useful features like error handling – which helps the data science team verify the quality and accuracy of its query results – as well as iteration, logging, scheduling, version control, monitoring, collaboration, and environment support.

When data-driven insights are critical for making decisions around product development and improvement, customer service, and operational agility, Matillion ETL and Amazon Redshift help you reach those insights quickly and affordably.

Matillion is a fantastic fit for us. It’s great for expert-level data technicians who write customised data queries, but also great for business users who need a tool that’s easy to configure. – Sheeya Gem, Staff Database Engineer, Citrix

Matillion ETL: Accelerating Time-To-Value for Amazon Redshift Workloads

  • Pushes data transformations down to Amazon Redshift, enabling you to process millions of rows in seconds, with real-time feedback.
  • Features a modern browser-based environment that includes collaborative tools, version control, graphical job development, and more than 70 data read, write, join, and transform components.
  • Deploys quickly and easily via Amazon Machine Image (AMI) so you can be developing ETL jobs within minutes.

Challenge: Citrix needed to efficiently and accurately analyse customer data from its ShareFile data pipeline – up to 400 data events per second in a typical workday.

Solution: Matillion ETL is designed specifically to streamline and accelerate data loads and transforms in Amazon RedShift.

Results: Matillion ETL and Amazon Redshift empower Citrix to efficiently process their data to identify popular application features and allocate more resources to optimise their service and customer experience.

Source: Matillion ETL for Amazon Redshift