Cross-Cloud Analytics and Anti-Fraud Engine
Challenge
A global entertainment and gaming company faced data silos that trapped critical information between its CRM systems and its data lakes. The separation blocked proactive fraud detection at the scale the business required, leaving risk teams working from incomplete pictures.
Solution: A zero-copy bridge between Salesforce and Snowflake
Oktana connected Salesforce and Snowflake so fraud signals could be processed where the compute lives and surfaced where the decisions get made.
A global entertainment and gaming company faced data silos that trapped critical information between its CRM systems and its data lakes. The separation blocked proactive fraud detection at the scale the business required, leaving risk teams working from incomplete pictures.
Solution: A zero-copy bridge between Salesforce and Snowflake
Oktana connected Salesforce and Snowflake so fraud signals could be processed where the compute lives and surfaced where the decisions get made.
Solution
Key elements of the solution included:
- Streamlined data access with a zero-copy strategy that eliminated ETL processes across Salesforce Data Cloud and Snowflake.
- Automated fraud detection using in-layer algorithms in Snowflake Snowpark to increase processing speed.
- Centralized global datasets into one scalable, elastic repository in the Snowflake Data Warehouse.
- Surfaced risk insights directly in dashboards through
- Salesforce CRM Analytics to improve decision-making.
- Used Salesforce Data Cloud as the bridge that moves data from Service Cloud into Snowflake for processing and back into the CRM for other departments.
Key elements of the solution included:
- Streamlined data access with a zero-copy strategy that eliminated ETL processes across Salesforce Data Cloud and Snowflake.
- Automated fraud detection using in-layer algorithms in Snowflake Snowpark to increase processing speed.
- Centralized global datasets into one scalable, elastic repository in the Snowflake Data Warehouse.
- Surfaced risk insights directly in dashboards through
- Salesforce CRM Analytics to improve decision-making.
- Used Salesforce Data Cloud as the bridge that moves data from Service Cloud into Snowflake for processing and back into the CRM for other departments.
Results
The engine increased the volume of information processed by 450%, improved efficiency and accuracy by 50%, and made data processing 90% faster. The zero-ETL approach delivered these gains without any increase in Snowflake storage consumption.
The engine increased the volume of information processed by 450%, improved efficiency and accuracy by 50%, and made data processing 90% faster. The zero-ETL approach delivered these gains without any increase in Snowflake storage consumption.