Skip to Content
Product Information
Author's profile photo Josef Ehbauer

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).

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Silvia None
      Silvia None

      Hi Josef,

       

      thank you for sharing and the update.

      I have 2 queries here

      1.For the retraction back from SAP BPC 11.0 on BW4HANA (on-premise) to SAP Marketing Cloud (e.g. retraction the approved budget from SAP BPC) what will be the best practice ?

      2.Is there any standard retraction tool from either SAP Marketing Cloud or BW4HANA ?

       

      Cheers,

      Silvia

      Author's profile photo Josef Ehbauer
      Josef Ehbauer
      Blog Post Author

      Hi Silvia,

      the described capability aims to provide a one-way integration of mass data from marketing cloud into BW/4HANA. For retraction of data from BW back to SAP Marketing Cloud you can use our integration technology on CPI, implementing iFlows and our available APIs.

      Bes Regards,
      Josef

       

       

       

      Author's profile photo Markus Grant
      Markus Grant

      Hello Josef Ehbauer ,

      We've set up CDS-based extracts to an external reporting system and it's working quite well.

      However, we've noticed that there are several CDS views which have not yet been made available for extract, for example, I_MKT_ContactRelation and I_MKT_Company.

      What is the process for adding missing CDS views? Is SAP rolling them out according to some release schedule? Can customers request specific CDS views?

      Kind Regards,

      Markus

      Author's profile photo Josef Ehbauer
      Josef Ehbauer
      Blog Post Author

      Dear Markus,

      thanks for your feedback and we are happy to hear that you benefit from this capability. We have added further marketing objects in 2011 release with marketing plans and programs and in 2102 with scores. We plan to provide also extraction for with marketing events.

      However, we decide on individual business objects, and not so much on individual CDS views. And we assess which are the most relevant business objects, also from a data load volume perspective. Nonetheless we are interested to understand your needs, and you can submit a influence item to articulate your requirements.

      With regard to the CDS views you have been asking for: For the extraction of Accounts you can use the CDS view I_MKT_ContactAll, but for relations between contacts and accounts we are still lacking the capability.  For details about the structure of the CDS views kindly refer also to the documentation in the integration guide.

      Kind Regards,
      Josef Ehbauer
      Product Management, SAP Marketing Cloud