The scenarios above represent six different integration patterns. Choosing the right pattern depends on your data sources, freshness requirements, and organizational readiness. Here's how to identify the pattern for your problem:
Pattern 1: Scheduled SaaS Sync (CPI + Datasphere)
Use When: You need to join SaaS data (Salesforce, Workday, Concur) with SAP. Data freshness: hourly to daily is acceptable.
Examples: Revenue Intelligence (Scenario 1), E-Commerce Order-to-Cash (Scenario 4, with Event Mesh), IT Service Cost Analytics (Scenario 5).
Architecture: Cloud Integration (CPI) loads SaaS data into Datasphere (JDBC adapter into an Open SQL schema, imported as local tables). Datasphere semantic layer joins SaaS data with SAP transactional data. SAC queries unified model.
Implementation Complexity: Medium. Requires SaaS connector setup, field mapping definition, and reconciliation logic (handling duplicates, mismatches).
Cost Implications: CPI licensing + replication data volume. If replicating large tables (Opportunities, Orders), data ingestion costs increase. Optimize by replicating only changed records (delta mode) and only necessary fields.
Pattern 2: Zero-Copy Multi-Cloud Access (BDC Connect + Datasphere)
Use When: Your analytical data already lives in Snowflake, Databricks, or BigQuery. You want to avoid copying data to SAP infrastructure. Data freshness: live access required.
Examples: Multi-Cloud Analytics (Scenario 2); training AI models in Databricks on SAP data products.
Architecture: BDC Connect shares data products between SAP Business Data Cloud and the external platform in both directions, without copying; data products shared back become discoverable in Datasphere. Other tables can be federated live (Generic JDBC for Databricks and Snowflake, the Google BigQuery connection for BigQuery). SAC queries the Datasphere model.
Implementation Complexity: Low. Set up the BDC Connect connection (for example, Unity Catalog permissions in Databricks or the Zerocopy Connector in Snowflake); define the semantic model on top of the shared data; connect SAC to Datasphere live.
Cost Implications: BDC Connect zero-copy access is consumption-metered on the SAP side, and the external platform (Snowflake, Databricks) charges its own compute credits per query — budget for both. Monitor query patterns; optimize by pushing aggregation to the external platform.
Pattern 3: Federated Semantic Model (Datasphere + CPI)
Use When: You need to join data from multiple systems (SaaS, SAP, third-party, external platforms) in a single semantic model. Data comes from varied sources with different refresh frequencies.
Examples: HR-Finance Alignment (Scenario 3), Supplier Risk and Procurement (Scenario 6), enterprise data mesh (discussed in the BDC scenarios).
Architecture: Datasphere becomes semantic hub. Several paths feed Datasphere: SAP source connections and replication flows, integration flows for SaaS apps such as Salesforce and Ariba, and remote tables for platforms such as Google BigQuery. Semantic model joins across sources at the Datasphere layer (not in SAC). SAC consumes unified model.
Implementation Complexity: High. Requires master data reconciliation (which Salesforce account maps to which SAP customer?), lineage documentation, and change management (when source definitions change, how do we cascade to downstream consumers?).
Cost Implications: High. Multiple connectors, federation logic, and governance tooling. But the payoff compounds: once the unified model exists, every team can build analytics on it.
Pattern 4: High-Volume Transactional Integration (Event Mesh + Stream Processing)
Use When: You need near-real-time analytics on high-volume transactional events. Batch synchronization is too slow.
Examples: Real-time operational dashboards, fraud detection, live inventory tracking.
Architecture: Source systems publish events (orders placed, shipments, returns) to SAP Event Mesh or, for high volumes, advanced event mesh in SAP Integration Suite (AMQP/MQTT/REST). Where you need stream processing, advanced event mesh can bridge events to Kafka, where engines such as Kafka Streams or Apache Flink enrich and aggregate them. A subscriber (or a Datasphere replication flow reading from Confluent) writes the results into Datasphere, which does not subscribe to Event Mesh topics itself. SAC dashboards on a live connection to Datasphere show them as soon as they land.
Implementation Complexity: Very High. Requires event architecture expertise, stream processing logic, and operational monitoring.
Cost Implications: High. Event infrastructure, stream processing compute, storage for event stream archives. Use only when real-time truly matters (financial trading, fraud prevention, operational SLAs).
Pattern 5: Third-Party Data Enrichment (Open Connectors + Datasphere)
Use When: You need to enrich SAP/SaaS data with external data (market data, credit ratings, geolocation, weather). SAP Integration Suite has over 160 pre-built SaaS connectors.
Examples: Enriching customer master with credit ratings, enriching sales orders with weather data, enriching products with market pricing data.
Architecture: Open Connectors integrate third-party APIs. Data flows to Datasphere. Datasphere joins enrichment data with operational data. SAC provides enriched analytics.
Implementation Complexity: Low-Medium. Pre-built connectors reduce custom development. Main challenge: data freshness (how often to refresh enrichment?) and cost (third-party APIs often metered).
Cost Implications: Third-party data subscription + API call volume charges. Optimize by caching slowly-changing data (enrichment) and querying only when operational data changes.