Skip to content
NexusBook a demo

Enterprise use case · Salesforce + SAP + Snowflake

CRM and ERP operational analytics

Sales and finance report from different systems and disagree. Pipeline and ERP data are modelled together in Snowflake for operational reporting.

Systems involved

What each system contributes

Salesforce

73 actions

  • Accounts10
  • Opportunities10
  • Reports10

Trigger source: Salesforce (SOQL polling)

SAP

97 actions

  • Finance20
  • Sales Orders14
  • Products10
Snowflake

35 actions

  • Data Loading & Stages8
  • Tasks & Scheduling7
  • Tables6
  • Views6

Bulk extracts use SAP RFC or OData and Salesforce queries, shaped in Rules + Code.

Architecture

One governed run

Trigger: scheduleIntegration: Salesforce + SAPRules + CodeSystem Action: SnowflakeAudit

How it starts: A schedule starts the run.

Step by step

How the process runs

  1. 01

    Context

    Salesforce accounts, opportunities and reports, and SAP finance, sales orders and products, are read.

  2. 02

    Normalize

    Rules + Code maps accounts to customers and products.

  3. 03

    Load

    Snowflake data loading actions load both sources.

  4. 04

    Model

    Snowflake tasks build tables and views for reporting.

Control

Human decision and exception path

Human decision

A data owner approves mapping and schema changes.

Exception path

  • Unmapped accounts are reported.
  • Failed loads are retried.
  • Schema drift stops the run.

Evidence

What gets audited

  • Source counts.
  • Mapping result.
  • Load and task runs.

Nexus runs on premises, in private or sovereign cloud, or air-gapped. Credentials stay in the vault, roles decide who can approve, and the execution record stays inside your deployment boundary.

Sovereignty and deployment

Related

Patterns, connectors and next steps

FAQ

Questions about this use case

Does Nexus replace any of these systems?
No. Each system keeps its own records. Nexus runs the process between them and records each decision.
How does the run start?
A schedule starts the run.
What if a step is not covered by a pre-built action?
Bulk extracts use SAP RFC or OData and Salesforce queries, shaped in Rules + Code.

Use case review

Discuss this use case

Bring your version of the process. We will map the systems, approvals and evidence it needs.