Skip to content

Question Regarding CDC Support for SAP on AWS

0

I would like to inquire about Change Data Capture (CDC) support for SAP systems or SAP Databases. Specifically, I would like to confirm:

  1. Does AWS currently support CDC implementation for SAP?
  2. If yes, which SAP versions or specifications are supported (e.g., SAP ECC, SAP S/4HANA, or SAP BW)?
  3. Is there any official documentation I can review regarding CDC integration with SAP on AWS, including architecture, best practices, and the AWS services involved (such as AWS DMS, Glue, etc.)?

Thank you very much for your assistance.

asked a year ago370 views

1 Answer
0

Yes, AWS supports Change Data Capture (CDC) implementation for SAP systems through multiple approaches:

  1. AWS Database Migration Service (AWS DMS) supports CDC for SAP ASE databases. For ongoing CDC replication, DMS runs dbcc logtransfer and dbcc log commands to read data from the transaction log. AWS DMS supports both full load and CDC methods to migrate historic data and ongoing changes with near-zero latency from on-premises to AWS Cloud.

  2. AWS Glue OData connector for SAP uses the SAP ODP (Operational Data Provisioning) framework and OData protocol for data extraction, which supports change data capture through the Operational Delta Queues (ODQ) mechanism. This enables incremental data transfer from SAP sources using delta tokens. The ODP framework supports various SAP data sources including SAP data extractors, ABAP CDS views, SAP BW, BW/4 HANA sources, and HANA information views in SAP ABAP sources.

  3. Partner solutions like Fivetran offer fully managed SAP ERP on HANA connectors that replicate SAP ECC and S/4 HANA data using low-impact CDC. Fivetran's solution connects via the NetWeaver application layer and supports various SAP-specific features like cluster tables, pool tables, and long text tables.

For SAP versions, the supported systems include:

  • SAP ASE (Adaptive Server Enterprise)
  • SAP ECC and S/4 HANA
  • SAP BW and BW/4 HANA
  • SAP ABAP sources with HANA information views

AWS offers various integration options for SAP data extraction including AWS DMS, AWS Glue, and partner solutions that can be selected based on your specific requirements for CDC implementation.
Sources
Using an SAP ASE database as a source for AWS DMS - AWS Database Migration Service
Scaling RISE with SAP data and AWS Glue | AWS Big Data Blog
Migrate from SAP ASE to SAP ASE on Amazon EC2 using AWS DMS and SAP ASE native methods | AWS Database Blog
Accelerate SAP Data Replication with AWS and Fivetran | AWS Partner Network (APN) Blog

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.