GitHub user venkatamandavilli-code added a comment to the discussion: SAP HANA Provider Package
Hi @j6takish — really glad you published this provider. I wanted to add enterprise context to this discussion that might be helpful for anyone evaluating the SAP HANA provider for large-scale deployments. **Background** I'm an SAP S/4HANA Project Manager with 21+ years of ERP implementation experience. I've managed data migration pipelines and batch job orchestration across five major S/4HANA implementations including: - PepsiCo (worldwide plants, 100,000+ users, $91.85B revenue) - Levi Strauss (multi-country SAMEA + Asia Pacific rollout, 10,000+ users) - Compass Group (3-plant migration, Europe's largest foodservice company) - King's Hawaiian ($50M implementation budget) In each of these projects, nightly batch workflows, data validation pipelines, and multi-phase migration sequences were central to the implementation — exactly the scenarios where an Airflow + SAP HANA provider would be most valuable. **Enterprise Use Cases Not Yet Covered in Documentation** Based on my production experience, here are the SAP HANA pipeline scenarios that enterprise teams will need support for: 1. **Multi-Plant Batch Orchestration** — Running parallel DAGs per SAP plant/company code, each connecting to a different SAP HANA schema, with dependency gates between regional go-lives (e.g., Americas runs before EMEA cutover begins) 2. **Legacy ECC → S/4HANA Migration Pipelines** — Extracting from SAP ECC 6.0 source tables, transforming (cleansing, deduplication, enrichment), and loading into SAP S/4HANA target structures — specifically for OTC (VBAK/VBAP), FICO (BKPF/BSEG), and PTP (EKKO/EKPO) data objects 3. **Delta/Incremental Load Patterns** — Using SAP HANA Change Data Capture (CDC) or timestamp-based delta extraction to sync data incrementally between SAP and downstream analytics platforms (Airbyte, Superset, Metabase) 4. **Go-Live Cutover Sequencing** — Using Airflow SLA sensors to gate cutover steps — e.g., only proceed to SAP production activation after data migration validation DAG returns a success signal with zero error records 5. **Post Go-Live Monitoring Pipelines** — Scheduling automated data quality checks (completeness, duplicate detection, reconciliation) against SAP HANA in the weeks following go-live across multiple organizational units **My Offer** I'd like to contribute to the existing provider by: - Writing enterprise-focused documentation covering the above use cases - Adding a SAP HANA connection setup guide specifically for SAP HANA Cloud (SCP) vs. on-premise deployments - Contributing DAG examples for the migration and batch orchestration patterns above @j6takish — is there a preferred way to contribute to your provider repo? Happy to submit GitHub link: https://github.com/apache/airflow/discussions/44768#discussioncomment-16385517 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
