Case Study

Cisco Case Study

Issue link: https://read.uberflip.com/i/1275050

Contents of this Issue

Navigation

Page 0 of 1

CISCO CLOUD SECURITY CASE STUDY A powerful modern data environment in the cloud Cisco Cloud Security replaces an aging data infrastructure and adds Matillion ETL for Snowflake, opening up new possibilities for generating insights from its data. Company: Location: Industry: Product: Use Case: Reporting & Analytics Tech: Website: Cisco Cloud Security, a Cisco Business Unit San Francisco, CA Cloud Security Matillion ETL for Snowflake Data Warehouse Modernization Tableau www.cisco.com About Cisco Cloud Security Cisco Cloud Security provides cloud security infrastructure products that offer a broad range of protection to improve security and simplify management. The business unit provides solutions that deliver unmatched threat protection, assist with compliance considerations, and reduce bandwidth costs. The Challenge: Replacing an aging infrastructure The Business Intelligence team at the Cisco Cloud Security business unit provides automated systems and analytical content that democratize data and help people make better decisions about how to run the business. However, the unit was outgrowing its existing data storage and reporting solutions. The team had been relying on a single database that no longer met its capacity needs. Because the business unit lacked a well-modeled, centralized data repository, each team had to create and maintain its own reporting processes, resulting in fragmented and limited reporting. Plus, its data warehouse solution was unable to integrate with external data visualization tools. With all of these issues, the entire infrastructure was becoming too costly and resource-intensive to support, and the system engineering team was beginning to withdraw support for it. Cisco Cloud Security needed to find a more scalable, flexible, and affordable solution that would meet its increasing data storage and reporting needs. The Solution: A cloud solution that checks all the boxes After selecting Snowflake as its cloud data warehouse, Cisco Cloud Security chose Matillion ETL for Snowflake because it met all of its criteria: • Matillion is a scalable solution that was created for the enterprise. • It provides a modular and intuitive graphical user interface tool for ETL processes, which eliminates hand-coding (versus Python and Airflow) • Built for Snowflake, Matillion ETL for Snowflake makes it easy for Cisco to take advantage of native Snowflake functionality. • Matillion provides pre-built connectors that integrate with Cisco's primary data source systems, including RDS, SFDC, Zuora and S3. • Matillion ETL allowed the team to automate its data transformation, which reduces the amount of technical support required and allows the Cisco business intelligence (BI) team to focus on its core competencies. Cisco Cloud Security reduced ETL application spend by nearly 84% by switching from Informatica to Matillion. © 2020 Matillion. All rights reserved matillion.com

Articles in this issue

Links on this page

view archives of Case Study - Cisco Case Study