SAP HANA Cloud Data Intelligence

Data integration, quality, and catalog on SAP BTP — formerly SAP Data Intelligence Cloud.

Core Capabilities

Data Pipeline

Source (S/4HANA CDS View) → Read → Transform → Quality Check → Write → Target (HANA Cloud)

Pipeline Operators

Connection Types

// ABAP connection to S/4HANA
{
  "type": "ABAP",
  "host": "s4hana.internal.corp",
  "client": "100",
  "authentication": "BASIC",
  "protocol": "RFC"
}

// HANA connection
{
  "type": "HANA_DB",
  "host": "hana-cloud.cfapps.us10.hana.ondemand.com",
  "port": 443,
  "authentication": "DB_USER",
  "encrypt": true
}

Data Quality Rules

-- Mandatory field check
SELECT COUNT(*) FROM input_data WHERE material IS NULL;

-- Duplicate detection
SELECT material, COUNT(*) FROM input_data GROUP BY material HAVING COUNT(*) > 1;

-- Value range validation
SELECT * FROM input_data WHERE quantity < 0 OR quantity > 1000000;

Data Lineage

Lineage tracks how data flows through pipelines:

S/4HANA table MARA
  → CDS View Z_I_PRODUCT
    → DI Pipeline "Product Enrichment"
      → HANA Cloud table Z_PRODUCT_ENRICHED
        → SAC Story "Product Dashboard"

Impact: changing MARA field length → alerts Z_I_PRODUCT consumers.

S/4HANA CDS Integration

S/4HANA CDS View → ODP Extraction → DI Pipeline → HANA Cloud
  (I_Product)     (delta-enabled)   (transform)    (analytical dataset)

ABAP Trigger

" Trigger DI pipeline from ABAP Cloud
DATA(lo_http) = cl_web_http_client_manager=>create_by_http_destination(
  i_destination = cl_http_destination_provider=>create_by_cloud_destination(
    i_name = 'DI_CLOUD' ) ).
lo_http->get_http_request( )->set_text( '{ "pipeline": "Product_Load" }' ).
DATA(lo_response) = lo_http->execute( i_method = 'POST' ).

Gotchas

• DI Cloud is a separate BTP service subscription (not bundled with HANA Cloud)
• ODP extraction requires S/4HANA ODP framework active (transaction ODQMON)
• Data lineage tracked at column level in S/4HANA CDS views
• Metadata catalog auto-discovers HANA Cloud assets; non-HANA sources need manual registration
• Pipeline scheduling via Job Scheduling service or REST API trigger