IN ANNUAL REVENUE
YEARS' DATA MOVED IN 1 WEEKEND
“We needed a centralized data warehouse to provide a single source of truth for all users that we could scale up and down as our business fluctuates,” says Kancharla. “We decided to follow a cloud-first strategy, because we just couldn’t scale cost effectively on-premises.”
To make data consistently available for reporting and analytics, Kancharla and his team searched for a cloud platform that could scale on demand and connect to any on-premises or cloud data source. They chose an integrated, cloud-native solution that combines a Snowflake Data Cloud with Informatica Cloud Data Integration and Informatica Cloud Mass Ingestion, using Snowflake’s transformation capabilities to process the data after it is loaded.
“We chose Informatica and Snowflake because the tools are easy to use, they do everything we need, and we only need to train our team on two technologies,” says Kancharla. “The power of Informatica is that we can do ETL, ELT, and mass ingestion at scale, all with a single integrated cloud platform, to deliver trusted information to our data consumers.”
By combining multiple data sources in the cloud for analysis – including SAP ERP and SAP CRM, among other sales and manufacturing systems –Kancharla’ s team now supports more detailed and user-friendly reporting, so that teams can predict demand across complex and often customized product groups.
Inside the solution
Deliver Faster, Simpler, and More Cost-Effective Cloud Data Integration for Analytics