Application Integration - SAP ERP adapter - Change Data Capture

[padmanabhamv]

Use case: We want to synch SAP customer table data to Bigquery tables.

Question: Does SAP ERP adapter offer Change Data Capture (CDC) functionality, which tracks changes in tables and transmits only the modified data to downstream systems ? is this available?

[shaaland]

See this post for some reference information for SAP to BQ sync tooling in GCP : https://www.googlecloudcommunity.com/gc/Data-Analytics/Pros-and-cons-BigQuery-Connector-for-SAP-vs-C... 

If you want to use Application Integration, then there is a GCP provided SAP ABAP SDK which can allow you to publish messages to PubSub, so essentially, ABAP becomes the mechanism to publish your CDC stream, it goes to PubSub, and then using the PubSub Trigger in Application integration, along with the Data Mapping capabilities, and orchestration capabilities, and the BigQuery Connector, you can sync data to BQ.

What if you also incorporated the Vertex AI connector into the flow and made a callout to Vertex AI to add intelligence to the flow?  The possibilities are up to your imagination.

What other activities would you want to do in your other applications when a new customer is onboarded to SAP?  Create an account in ServiceNow for support calls?  This is where Application Integration can add more value to your organization than just a "data sync". 

[padmanabhamv]

thanks @shaaland , let me check.