What We Do
Who We Are
Industries
Technologies
AWS
Azure
Boomi
Confluent
MuleSoft
Snowflake
Software AG
Events
Insights
INSIGHTS
Blog Posts
Industry News and Updates
Case Studies
Recent Projects
Offerings
Project Accelerators
White Papers & eBooks
Insights and Education
Contact
Contact Us

Snowflake Integration Drives Increased ROI and Decision Making for Entertainment Company

Snowflake
Strategy
WebMethods
Customer Scenario

Even in the entertainment industry, data drives business decisions. That’s why our client, a major entertainment company, wanted to find a way to gain better insight into credit card data across their lines of business and products. However, payment records from the various credit card providers were incongruent and cumbersome to read. The payment providers offered data dumps, but its current technology made it difficult to parse and analyze. They lacked visibility into the insights they desired from multiple angles and perspectives and clarity on rebates owed to the client from the providers. This resulted in additional costs, as the client employed a specialized third-party application for the information. Adding to the challenge was the client’s desire to continue using solutions they were already invested in, specifically WebMethods and Tableau.

Solution

The design of the solution involved first assessing and analyzing the existing data, architecture, and schemas. Once reviewed, a hybrid solution was developed. The solution plan included the client’s existing WebMethods implementation, SFTP, AWS, Tableau, and because massive amounts of data involved, Snowflake for data warehousing. 

The event-driven process is kicked off once the SFTP server receives a file. From there, transformation into a standard CVS format is done and loaded into a JMS topic for multithreading. Batch groups of files are then sent to an AWS S3 bucket, validated, and then consumed into a staging schema by Snowflake’s Snowpipe API. Once reconciliation of the files is complete, joins with various tables permit different stats, like the line of business and product, to be tracked and labeled with primary keys aligned with record and source type. This data was then available for use within Tableau for analysis by the client’s finance team.

Result

The solution created almost immediate business value. The finance team was able to track and analyze credit card data over time by source as well as align it to business units. 

Data-driven business decisions happen more quickly thanks to the credit provider information being normalized and staged for the existing data tools. The client was able to recognize an ROI for the project quickly, thanks to adding a few new elements to existing owned technology stacks.  Additionally, the ability to process and analyze the information reduces their need to rely on external third parties, further reducing cost.

No items found.
subscribe

Sign up to stay on top of the latest news.

We've added you to the list!
Something went wrong. Please try again.
recent Case Studies
From Mule 3 to Mule 4: A Government Agency's Journey Towards Secure Integrations to Ensure Safe Water and Flood Control
Leader in Children’s Play Kits Integrates NetSuite, Shopify, and Boomi to Modernize and Support International Operations
MuleSoft Migration Streamlines and Simplifies ERP Business Processes for Manufacturing Client
View All
No items found.

BUILDING CONNECTIONS IN A DISCONNECTED WORLD

Company
What We DoWho We AreEventsCareersContact us
technologies
AWS
Azure
Boomi
Confluent
MuleSoft
Snowflake
Software AG
insights
Blog Posts
Case Studies
Offerings
White Papers & eBooks
subscribe
Welcome to the Big Compass family!
Oops! Something went wrong while submitting the form. Please try again.
© 2020 Big Compass
  |  
Privacy Policy
  |  
Terms of Service