Wednesday, July 26, 2023

APOS Live Data Gateway Use Case – Snowflake, Retail

High-performance, live data connectivity between
SAP Analytics Cloud and Snowflake Data Cloud

A large, Europe-based retailer running multiple chains of retail stores had consolidated legacy financial data from decades of corporate activities and acquisitions in Snowflake Data Cloud. They needed their analysts to have access to this data in SAP Analytics Cloud to extract KPI and other comparative data to drive better business decisions moving forward.

Requirements

• Live data connectivity to Snowflake Data Cloud
• Live data consumption in SAP Analytics Cloud
• Single Sign-On capabilities
• High-performance with large data sets
• Self-serve data modelling
• Snowflake Data Cloud Roles compatibility

Solution

This organization implemented APOS Live Data Gateway, which gave them:

• Fast, high-performance, single sign-on access from SAP Analytics Cloud to Snowflake Data Cloud
• Semantic layer views on Snowflake Data Cloud for simplified self-service analytics
• Use of Snowflake Data Cloud Roles to limit access to sensitive data and strong data governance

Conclusion

The customer used this implementation of APOS Live Data Gateway between SAP Analytics Cloud and legacy data in Snowflake Data Cloud as a test case for moving current data from legacy data assets to Snowflake. They were well pleased with the performance of the APOS solution, as well as the self-serve analytics capabilities and data governance provisions.
Cathy Ramsli, Account Manager, APOS Systems