- Newest
- Most votes
- Most comments
Yes, AWS supports Change Data Capture (CDC) implementation for SAP systems through multiple approaches:
-
AWS Database Migration Service (AWS DMS) supports CDC for SAP ASE databases. For ongoing CDC replication, DMS runs
dbcc logtransferanddbcc logcommands 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. -
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.
-
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
Relevant content
- AWS OFFICIALUpdated a year ago
