Data Federation
Data Federation covers how SAP Datasphere and SAP Analytics Cloud access remote data live, without physically copying it into the platform, using remote tables and live connections. This topic explains the business case for federation versus replication, how connections and remote tables are configured, how query pushdown and runtime execution work across source systems, and the performance, security, and governance trade-offs consultants must manage in production landscapes.
Overview
Data Federation covers how SAP Datasphere and SAP Analytics Cloud access remote data live, without physically copying it into the platform, using remote tables and live connections. This topic explains the business case for federation versus replication, how connections and remote tables are configured, how query pushdown and runtime execution work across source systems, and the performance, security, and governance trade-offs consultants must manage in production landscapes.
Lessons in this topic
- Optimizing Performance and Troubleshooting Federated Remote Table QueriesLearn how to diagnose and improve performance of federated (virtual access, non-replicated) remote tables in SAP Datasphere, including query pushdown limits, filter propagation, and common failure patterns in production models.
- What Data Federation Means in SAP Datasphere and SACUnderstand the core concept of data federation in the SAP Datasphere and SAC ecosystem, why it exists, and how it differs from replicating data.
- Configuring Federated Connections and Remote Tables for Production UseLearn the practical steps and considerations for setting up connections and remote tables to support federated access in Datasphere, plus how this surfaces through SAC live connections.
- Understanding Data Federation Fundamentals in SAP Datasphere and SACIntroduces the concept of data federation, why it exists, and how it differs from data replication in SAP Datasphere and SAP Analytics Cloud.
- Configuring and Modeling with Federated Remote Tables in DatasphereWalks through the practical steps of setting up connections, creating federated remote tables, and building models on top of them, including runtime and troubleshooting considerations.
- Tuning and Troubleshooting Federated Query Performance in DatasphereLearn how to diagnose and resolve slow or failing federated queries in SAP Datasphere by analyzing pushdown behavior, join placement, connection limits, and source-system load.