| Feature | Details |
|---|---|
| Environment | Azure only |
| Environment select | azure |
| Run options | SaaS + agent |
| Pricing / 100 sources | https://azure.microsoft.com/en-us/pricing/details/data-factory/data-pipeline/ |
| Supported connectors |
|
| BW data extraction support | ✅ (via ODP) |
| Database layer extraction | ✅ (via SLT and ODP) |
| DeltaLake support | ✅ (https://learn.microsoft.com/en-us/azure/data-factory/format-delta) |
| Application layer extraction | ✅ |
| Filtered historical load | ❌ (https://www.youtube.com/watch?v=WEb5sCuD9eQ&lc=Ugyd8gJvP5aO0xgEH0N4AaABAg) |
| Historical data load (primary system) | via the SAP Application Layer |
| Independent of SAP SLT | ☑️ (SLT is recommended and needed for SAP tables extraction) |
| New records (deltas) processing for CDSViews/HANA Calculation views | ✅ |
| Free of additional costs | ❌ (integration runtime needs additional HW) |
| Real-time support | ❌ (batches only, every 5 minutes) |
| Extractors support | ✅ |
| Schema conversion | ✅ |
| Installation needed | https://learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime?tabs=data-factory needs to be installed on an on-premises computer or on a virtual machine (VM). |
Azure DataFactory Data Ingestion
In Azure, you have basically two options to ingest data from SAP. For most projects, the ADF SAP CDC connector is the best option.