Loading a warehouse

Getting data into an analytical store and keeping it current — connections to source systems, replication and the other integration tasks, import jobs and their lifecycle, and the monitoring that tells you a load failed before a report does. Distinct from replication, which is a CAP service reading data that lives elsewhere as if it were local rather than a warehouse being filled.

Overview

SAP SHIPS

The product owns the pipeline and the roles around it: in Datasphere, a space administrator or integrator creates connections to source systems and databases and schedules and monitors data replication and other data integration tasks, alongside importing business content and controlling access to the space.

Not covered: At the tenant's own scheduler and monitor. What ran, what failed and what has to be re-run is visible in the product, and getting that into whatever else watches your landscape is nobody's job by default.

SAP's answer here is a product rather than a service you bind, and the products are now entries — Datasphere, Analytics Cloud, Business Data Cloud and HANA Cloud as BTP services, BW/4HANA as an external because it is installed rather than subscribed. Both sides of this assessment are artifacts.

THE COMMUNITY ADDS

Tools that reach the loading surface from outside the product: BW's Push API and request monitor, SAC's import-job lifecycle, Datasphere's ETL extraction, and SAP's dbt-sap-hana-cloud adapter, which loads dbt models into SAP HANA Cloud.

Artifacts6

6 of 6 artifacts
ArtifactSignals
MCP servers3
@mariodefe/sap-datasphere-mcpMCP server with forty-five tools across a Datasphere tenant
Signals
Functional boundary
bw-modeling-mcpMCP server for BW/4HANA modelling objects
Signals
Functional boundary
sap_analytics_cloud_mcpMCP server for the SAP Analytics Cloud REST API
Signals
Functional boundary
Packages1
dbt-sap-hana-clouddbt adapter targeting SAP HANA Cloud as its warehouse
Signals
none
Services2
SAP Analytics CloudSaaS for business intelligence, planning and predictive analytics
Signals
Functional boundary
SAP DatasphereCloud data warehouse with spaces, views and analytic models
Signals
Functional boundary

Content5

Group by
Piece, what it offers
Strategy and Tool Updates on BW Modernization with SAP Business Data Cloud
YouTube — SAP Developers playlists, SAP Developers, Talk
SAP Datasphere Integration Patterns: Lessons Learned from Two Years of Implementations
SAP Community, saikrishna_kalivarapu2, Blog
Explore your Hyperscaler data with SAP Business Data Cloud
SAP Architecture Center, SAP Architecture Center, Reference architectureThe reasoningA reference
Medallion Reference Architecture for Big Data Processing in SAP HANA Cloud
SAP Architecture Center, SAP Architecture Center, Reference architectureThe reasoningA reference
Transform business data into AI-supported insights
SAP TechEd — session catalogue, TalkA recipe
Strategy and Tool Updates on BW Modernization with SAP Business Data Cloud
YouTube — SAP Developers playlists, SAP Developers, Talk
SAP Datasphere Integration Patterns: Lessons Learned from Two Years of Implementations
SAP Community, saikrishna_kalivarapu2, Blog
Explore your Hyperscaler data with SAP Business Data Cloud
SAP Architecture Center, SAP Architecture Center, Reference architectureThe reasoningA reference

Seen working2

ArtifactSignals
Samples2
SAP-samples/sap-bdc-explore-hyperscaler-dataGuides connecting hyperscaler sources into SAP Datasphere in BDC
none
SAP-samples/teched2025-DA260TechEd 2025 workshop on SAP Business Data Cloud connectivity options
none

Details

Coverage
statecore and community, BTP/BAIP
assessed
relationshipunassessed
also inABAP
For your agent
Ref
capability:warehouse-loading
JSON
/capabilities/warehouse-loading.json
MCP
Connecting an agent