JW Player provides video hosting and streaming, advertising services, and analytics for a billion monthly unique viewers in 200 countries. For this SaaS platform, data analytics is key to understanding how our customers interact with our product, and identifying hidden opportunities for product enhancements.
Jonathan Lu, director of analytics at the company, leads the company’s data team, which includes two data engineers, a DBA, two data scientists, and one data analyst. The company integrates data from Salesforce, Recurly, and Jira with internal product data to a Snowflake data warehouse and Amazon S3 data lake, and uses Looker and Mode to create BI reports.
JW Player wanted to add Salesforce to its analytics mix, but no one on the data team had Salesforce expertise, so building a sustainable pipeline for Salesforce data would have been a tedious and time-consuming process. Lu and the team evaluated several ETL-as-a-service options as alternatives. “Stitch was one of several we looked at, and it was the most streamlined in terms of usability and requiring no additional engineering time.
“Native integration with Salesforce worked perfectly out of the box. Initial setup only took an hour or so — then it ‘just worked.’”
Stitch was one of several we looked at, and it was the most streamlined in terms of usability and requiring no additional engineering time.
Director of Analytics
Engineering ETL and data pipelines in general is a hassle, especially when you consider that it requires additional knowledge of each individual data source. Stitch eliminated the need for that work and help reduce the time it took to make data available.
“We retired our old ETL solution, which took about three-quarters of a team member’s time on a daily basis, so Stitch saved us a tremendous amount of time. We also saved time on deployment of data structure and model updates — from two to three days down to four to five hours, including testing.”
Now, Lu says, “Stitch is our go-to ETL tool for any new data sources. Thanks to Stitch, we’re able to gain insights into our business at a quicker pace than ever.”
Thanks to Stitch, we’re able to gain insights into our business at a quicker pace than ever.
Director of Analytics
Join JW Player and start replicating data
Select your integrations, choose your warehouse, and enjoy Stitch free for 14 days.
Set up in minutes Unlimited data volume during trial 5 million rows of data free, forever