CRITICAL GUIDELINES
Windows File Path Requirements
MANDATORY: Always Use Backslashes on Windows for File Paths
When using Edit or Write tools on Windows, you MUST use backslashes (\) in file paths, NOT forward slashes (/).
Examples:
- WRONG:
D:/repos/project/file.tsx
- CORRECT:
D:\repos\project\file.tsx
This applies to:
- Edit tool file_path parameter
- Write tool file_path parameter
- All file operations on Windows systems
Documentation Guidelines
NEVER create new documentation files unless explicitly requested by the user.
- Priority: Update existing README.md files rather than creating new documentation
- Repository cleanliness: Keep repository root clean - only README.md unless user requests otherwise
- Style: Documentation should be concise, direct, and professional - avoid AI-generated tone
- User preference: Only create additional .md files when user specifically asks for documentation
Salesforce Data Cloud Integration Patterns (2025)
What is Salesforce Data Cloud?
Salesforce Data Cloud is a real-time customer data platform (CDP) that unifies data from any source to create a complete, actionable view of every customer. It powers AI, automation, and analytics across the entire Customer 360 platform.
Key Capabilities:
- Data Ingestion — Connect 200+ sources (Salesforce, external systems, data lakes)
- Data Harmonization — Map disparate data to unified data model
- Identity Resolution — Match and merge customer records across sources
- Real-Time Activation — Trigger actions based on streaming data
- Zero Copy Architecture — Query data in place without moving it
- AI/ML Ready — Powers Einstein, Agentforce, and predictive models
- Vector Database (GA March 2025) — Store and query unstructured data with semantic search
- Hybrid Search (Pilot 2025) — Combine semantic and keyword search for accuracy
Reference Map
Detailed material lives in references/. Load only what the current task needs.
| Topic |
File |
When to load |
| Data ingestion (CDC streaming, batch API, Snowflake/Databricks Zero Copy) |
references/ingestion-patterns.md |
Configuring data sources, importing CSV/SFTP/S3 data, setting up Zero Copy to a warehouse |
| Identity resolution & authentication |
references/identity-resolution.md |
Defining match rules, reconciliation, custom matching, JWT Bearer auth |
| Real-time activation (Flow, Agentforce, Reverse ETL, calculated insights, segmentation, Data Cloud SQL) |
references/activation-patterns.md |
Triggering downstream actions, segmentation, Agentforce grounding, SQL queries |
| Vector Database & semantic/hybrid search |
references/vector-database.md |
Unstructured data indexing, semantic search, Einstein Copilot Search, multi-language search |
Data Cloud Architecture
┌──────────────────────────────────────────────────────────┐
│ Data Sources │
│ Salesforce CRM │ External Apps │ Data Warehouses │ APIs │
└────────┬─────────────────┬──────────────┬───────────┬────┘
│ │ │ │
┌────▼─────────────────▼──────────────▼───────────▼────┐
│ Data Cloud Connectors & Ingestion │
│ ├─ Real-time Streaming (Change Data Capture) │
│ ├─ Batch Import (scheduled/on-demand) │
│ └─ Zero Copy (Snowflake, Databricks, BigQuery) │
└────────────────────────┬─────────────────────────────┘
│
┌────────────────────────▼─────────────────────────────┐
│ Data Model & Harmonization │
│ ├─ Map to Common Data Model (DMO objects) │
│ ├─ Identity Resolution (match & merge) │
│ └─ Data Transformation (calculated insights) │
└────────────────────────┬─────────────────────────────┘
│
┌────────────────────────▼─────────────────────────────┐
│ Unified Customer Profile (360° View) │
│ ├─ Demographics, Transactions, Behavior, Events │
│ └─ Real-time Profile API for instant access │
└────────────────────────┬─────────────────────────────┘
│
┌────────────────────────▼─────────────────────────────┐
│ Activation & Actions │
│ ├─ Salesforce Flow (real-time automation) │
│ ├─ Marketing Cloud (segmentation/journeys) │
│ ├─ Agentforce (AI agents) │
│ ├─ Einstein AI (predictions/recommendations) │
│ └─ External Systems (reverse ETL) │
└──────────────────────────────────────────────────────┘
Core Workflow
- Identify use case — Ingestion, identity, segmentation, activation, or unstructured/AI search? Pick the matching reference.
- Map data sources — CRM CDC (real-time), external batch (S3/SFTP), or warehouse Zero Copy.
- Define DMOs and matching — Map source fields to Data Model Objects; configure identity resolution match + reconciliation rules.
- Build insights / segments — Calculated insights for KPIs (LTV, churn risk); segments for activation targets.
- Activate — Flow / Platform Events / Agentforce actions / Reverse ETL data actions.
- Validate — Use Data Cloud SQL workbench, check sync logs, monitor identity resolution metrics.
Best Practices
Performance
- Use Zero Copy for large datasets (>10M records)
- Batch imports outside business hours
- Index frequently queried fields in Data Cloud
- Limit real-time triggers to critical events
- Cache unified profiles when possible
Security
- Field-level security applies to Data Cloud queries from Salesforce
- Data masking for PII in non-production environments
- Encryption at rest and in transit (TLS 1.2+)
- Audit logging for all data access
- Role-based access control (RBAC) for Data Cloud users
Data Quality
- Data validation before ingestion
- Deduplication rules at source and in Data Cloud
- Data lineage tracking (know source of each field)
- Quality scores for unified profiles
- Regular data audits and cleansing
Resources
1---
2name: data-cloud-2025
3description: |
4 Salesforce Data Cloud integration patterns and architecture (2025).
5 PROACTIVELY activate for: (1) Data Cloud setup and ingestion, (2) Data Streams (cloud, mobile, web SDK, ingestion API), (3) data model objects (DMO) and source objects (DSO), (4) identity resolution and unified profiles, (5) calculated insights and segmentation, (6) activations to Marketing Cloud, advertising platforms, Salesforce CRM, (7) Bring Your Own Lake (BYOL) with Snowflake, BigQuery, Databricks, (8) zero-copy data sharing, (9) Data Cloud + Agentforce grounding, (10) consent management and compliance.
6 Provides: data-stream selection matrix, identity resolution rules, segmentation patterns, BYOL configuration, and activation playbook.
7metadata:
8 source: https://skillmd.com/skills/josiahsiegel/data-cloud-2025
9---
10
11## CRITICAL GUIDELINES
12
13### Windows File Path Requirements
14
15**MANDATORY: Always Use Backslashes on Windows for File Paths**
16
17When using Edit or Write tools on Windows, you MUST use backslashes (`\`) in file paths, NOT forward slashes (`/`).
18
19Examples:
20- WRONG: `D:/repos/project/file.tsx`
21- CORRECT: `D:\repos\project\file.tsx`
22
23This applies to:
24- Edit tool file_path parameter
25- Write tool file_path parameter
26- All file operations on Windows systems
27
28### Documentation Guidelines
29
30NEVER create new documentation files unless explicitly requested by the user.
31
32- **Priority**: Update existing README.md files rather than creating new documentation
33- **Repository cleanliness**: Keep repository root clean - only README.md unless user requests otherwise
34- **Style**: Documentation should be concise, direct, and professional - avoid AI-generated tone
35- **User preference**: Only create additional .md files when user specifically asks for documentation
36
37---
38
39# Salesforce Data Cloud Integration Patterns (2025)
40
41## What is Salesforce Data Cloud?
42
43Salesforce Data Cloud is a real-time customer data platform (CDP) that unifies data from any source to create a complete, actionable view of every customer. It powers AI, automation, and analytics across the entire Customer 360 platform.
44
45**Key Capabilities:**
46- **Data Ingestion** — Connect 200+ sources (Salesforce, external systems, data lakes)
47- **Data Harmonization** — Map disparate data to unified data model
48- **Identity Resolution** — Match and merge customer records across sources
49- **Real-Time Activation** — Trigger actions based on streaming data
50- **Zero Copy Architecture** — Query data in place without moving it
51- **AI/ML Ready** — Powers Einstein, Agentforce, and predictive models
52- **Vector Database** (GA March 2025) — Store and query unstructured data with semantic search
53- **Hybrid Search** (Pilot 2025) — Combine semantic and keyword search for accuracy
54
55## Reference Map
56
57Detailed material lives in `references/`. Load only what the current task needs.
58
59| Topic | File | When to load |
60|-------|------|--------------|
61| Data ingestion (CDC streaming, batch API, Snowflake/Databricks Zero Copy) | `references/ingestion-patterns.md` | Configuring data sources, importing CSV/SFTP/S3 data, setting up Zero Copy to a warehouse |
62| Identity resolution & authentication | `references/identity-resolution.md` | Defining match rules, reconciliation, custom matching, JWT Bearer auth |
63| Real-time activation (Flow, Agentforce, Reverse ETL, calculated insights, segmentation, Data Cloud SQL) | `references/activation-patterns.md` | Triggering downstream actions, segmentation, Agentforce grounding, SQL queries |
64| Vector Database & semantic/hybrid search | `references/vector-database.md` | Unstructured data indexing, semantic search, Einstein Copilot Search, multi-language search |
65
66## Data Cloud Architecture
67
68```text
69┌──────────────────────────────────────────────────────────┐
70│ Data Sources │
71│ Salesforce CRM │ External Apps │ Data Warehouses │ APIs │
72└────────┬─────────────────┬──────────────┬───────────┬────┘
73 │ │ │ │
74 ┌────▼─────────────────▼──────────────▼───────────▼────┐
75 │ Data Cloud Connectors & Ingestion │
76 │ ├─ Real-time Streaming (Change Data Capture) │
77 │ ├─ Batch Import (scheduled/on-demand) │
78 │ └─ Zero Copy (Snowflake, Databricks, BigQuery) │
79 └────────────────────────┬─────────────────────────────┘
80 │
81 ┌────────────────────────▼─────────────────────────────┐
82 │ Data Model & Harmonization │
83 │ ├─ Map to Common Data Model (DMO objects) │
84 │ ├─ Identity Resolution (match & merge) │
85 │ └─ Data Transformation (calculated insights) │
86 └────────────────────────┬─────────────────────────────┘
87 │
88 ┌────────────────────────▼─────────────────────────────┐
89 │ Unified Customer Profile (360° View) │
90 │ ├─ Demographics, Transactions, Behavior, Events │
91 │ └─ Real-time Profile API for instant access │
92 └────────────────────────┬─────────────────────────────┘
93 │
94 ┌────────────────────────▼─────────────────────────────┐
95 │ Activation & Actions │
96 │ ├─ Salesforce Flow (real-time automation) │
97 │ ├─ Marketing Cloud (segmentation/journeys) │
98 │ ├─ Agentforce (AI agents) │
99 │ ├─ Einstein AI (predictions/recommendations) │
100 │ └─ External Systems (reverse ETL) │
101 └──────────────────────────────────────────────────────┘
102```
103
104## Core Workflow
105
1061. **Identify use case** — Ingestion, identity, segmentation, activation, or unstructured/AI search? Pick the matching reference.
1072. **Map data sources** — CRM CDC (real-time), external batch (S3/SFTP), or warehouse Zero Copy.
1083. **Define DMOs and matching** — Map source fields to Data Model Objects; configure identity resolution match + reconciliation rules.
1094. **Build insights / segments** — Calculated insights for KPIs (LTV, churn risk); segments for activation targets.
1105. **Activate** — Flow / Platform Events / Agentforce actions / Reverse ETL data actions.
1116. **Validate** — Use Data Cloud SQL workbench, check sync logs, monitor identity resolution metrics.
112
113## Best Practices
114
115### Performance
116- **Use Zero Copy** for large datasets (>10M records)
117- **Batch imports** outside business hours
118- **Index frequently queried fields** in Data Cloud
119- **Limit real-time triggers** to critical events
120- **Cache unified profiles** when possible
121
122### Security
123- **Field-level security** applies to Data Cloud queries from Salesforce
124- **Data masking** for PII in non-production environments
125- **Encryption at rest** and in transit (TLS 1.2+)
126- **Audit logging** for all data access
127- **Role-based access control** (RBAC) for Data Cloud users
128
129### Data Quality
130- **Data validation** before ingestion
131- **Deduplication rules** at source and in Data Cloud
132- **Data lineage tracking** (know source of each field)
133- **Quality scores** for unified profiles
134- **Regular data audits** and cleansing
135
136## Resources
137
138- **Data Cloud Documentation:** https://developer.salesforce.com/docs/data/data-cloud-int/guide
139- **Zero Copy Partner Network:** https://www.salesforce.com/data/zero-copy/
140- **Data Cloud Pricing:** Part of Customer 360 platform, usage-based pricing
141- **Trailhead:** "Data Cloud Basics" and "Data Cloud for Developers"