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 replicationData federationReading data that lives in another system as if it were local — by federating the query, by copying the rows, or by caching what was read. Three different answers to one question, and the choice is about how stale you can afford to be.SAP and community, narrow by design, which is a CAP service reading data that lives elsewhere as if it were local rather than a warehouse being filled.
Overview
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.
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-clouddbt-sap-hana-cloudA dbt adapter, installed as a Python package beside dbt-core, that lets a dbt project target SAP HANA Cloud as its warehouse through a profile in profiles.yml.sap official, btp adapter, which loads dbt models into SAP HANA Cloud.
Artifacts
Content
Seen working
Details
Coverage
For your agent
- Ref
capability:warehouse-loading- JSON
- /capabilities/warehouse-loading.json
- MCP
- Connecting an agent