Extract Data from Marketing for Use in External Analytics Solutions
SAP Marketing Cloud Marketing uses real-time access through Core Data Service (CDS) Views to expose Marketing Analytics in SAP Analytics Cloud via Analytics Stories and Dashboards.
However, there are business scenarios, where customer need a different solution for Analytics: For example, if customer run a centralized Analytics, they need to extract data from SAP Marketing Cloud into other systems, for example into a central global Business Information Warehouse. Other example are scenarios, where marketing effectiveness shall be visualized in a dashboard, which exposes performance results of digital marketing together with success data of email campaigns from SAP Marketing Cloud.
Such scenarios can be supported, if mass data are extracted from Marketing Cloud into a corresponding external system being used for the required Analytics. This can be achieved by means of CDS based data extraction, which uses a mechanism named CDC (Change Data Capture).
You can find a how to documentation in the set up instructions of the SAP Best Practice Package Custom Reports and Analytics Stories (3SM) in chapter CDS Based Data Extraction. Both can be accessed from our the integration guide of SAP Marketing Cloud
In addition the following CX work article provides helpful information if integration shall be leveraged via SAP Integration Services (CPI).