Question Regarding AWS Glue and AWS AppFlow Integration with SAP ECC

Based on the available information, I can provide details about AWS Glue and Amazon AppFlow integration with SAP ECC.

For AWS Glue:

1. Yes, AWS Glue supports incremental data loading (similar to CDC) from SAP ECC using the SAP OData connector. This can be implemented using state management for timestamp-based incremental transfers.
2. AWS Glue can connect to SAP systems that support OData APIs, including SAP ECC. The specific versions aren't explicitly mentioned in the sources, but it requires a compatible SAP NetWeaver stack version with enabled catalog service and OData V2.0 or V4.0 services.
3. Prerequisites include:

• SAP system configured for OData access
• Entities that support incremental transfers
• Authentication credentials (AWS Glue supports both CUSTOM/BASIC authentication and OAUTH authentication methods for SAP)

4. For implementing incremental data loading from SAP ECC, you would use the StateManagerFactory in AWS Glue to manage the state of your data transfers, specifying a timestamp column to track changes.

For Amazon AppFlow:

1. Yes, Amazon AppFlow supports integration with SAP through its SAP OData connector.
2. AppFlow can transfer data from SAP S/4HANA and on-premises systems through OData APIs. It supports both full data transfers and incremental updates for ODP data.
3. Requirements and limitations include:

• Compatible SAP NetWeaver stack version
• Enabled catalog service
• OData V2.0 or V4.0 services
• Client-side pagination support
• Authentication via Basic or OAuth 2.0
• Note that while AppFlow supports SAP OData as a destination, it does not support ODP data as a destination

4. When using AppFlow with SAP, you can choose between incremental and full data transfers. Incremental transfers subscribe to the operational delta queue of the ODP provider and transfer only changed records.

Both AWS Glue and Amazon AppFlow serve distinct roles in SAP data integration. AWS Glue excels in complex ETL operations and specialized scenarios like SAP ODP-based extraction, while AppFlow provides a more streamlined, no-code solution for API-based data transfers with a user-friendly interface.

For secure connectivity, you can use AWS PrivateLink to establish private network connections between AWS services and your SAP systems, eliminating exposure to the public internet.
Sources
SAP OData connector for Amazon AppFlow - Amazon AppFlow
Data integration - General SAP Guides
SAP Authentication - AWS Glue
load data incrementally in sap o data (sap ecc) using aws glue | AWS re:Post
Secure SAP HANA Cloud connectivity using AWS PrivateLink | AWS for SAP