In SAP Datasphere (previously known as SAP Data Warehouse Cloud), Remote Data Sources refer to external systems or databases that you connect to SAP Datasphere without physically replicating the data into it. Instead, data remains in its original source, and virtual access is provided for querying, modeling, or analysis.

🔹 Key Features of Remote Data Sources in SAP Datasphere:

  1. Virtual Data Access (Federation): Data is not physically stored in Datasphere. Queries are pushed down to the source system for execution. Useful for real-time access to large datasets.
  2. Integration Across Landscapes: Connect to a variety of sources like: SAP systems (e.g., SAP S/4HANA, SAP BW) Non-SAP databases (e.g., Oracle, SQL Server, Snowflake, Google BigQuery) Cloud storage (e.g., Amazon S3, Azure Blob)
  3. Consumption in Models: You can use remote tables in your Analytical Models, Graphical Views, or Data Flows.
  4. No ETL Overhead: Since there’s no extraction and load involved, it reduces duplication and helps maintain data governance.
  5. Option to Persist Later: If needed, remote data can later be persisted (replicated) into Datasphere for performance or historical archiving.

🔧 Common Use Case Example:

You have a large dataset in SAP S/4HANA. Instead of loading it into SAP Datasphere, you connect it as a remote source and:

  • Build a virtual model using that live data
  • Combine it with other data (e.g., from SAP SuccessFactors or Snowflake)
  • Perform analytics without copying data

🧩 How to Connect a Remote Data Source:

  1. Go to the Data Builder or Connections section in SAP Datasphere.
  2. Choose Create Connection.
  3. Select the remote source type (SAP HANA, OData, BigQuery, etc.).
  4. Configure the connection settings (host, credentials, etc.).
  5. Once added, you can browse remote tables and use them directly

Mail us on contact@anubhavtrainings.com

Call us on +91-84484 54549

Website: Anubhav Online Trainings | UI5, Fiori, S/4HANA Trainings

Comments

Popular posts from this blog