Data Export in SAP Marketing

[former_member695645]

Hi Experts,

I am working with data export using export definitions and campaigns. In one of the scenario I have to download information related with the interactions (1:n) and one of the file has a size of 2GB. I experimented some slowness in the process and I feel these can destabilize the system

is there any size limit for data extraction using export file campaigns?

is there any alternative to do the data extraction when the files are heavy?

Thanks

[former_member599277 · Accepted solution]

Hello Kevin,

As we can see in the below Export definition documentation, the export is not designed as a mass export of data, but rather to create export files with contact data for email or phone campaigns etc

Export Definitions - SAP Help Portal

The size of the export file, the number of attributes, the number of contacts, and the data retrieved using segmentation all impact memory consumption and performance. Although the creation of the file is possible, when the file is downloaded, the system will run into errors if the file size exceeds 2.1 GB.

The recommendation to export large data sets is via CDS based extraction. It is a part of the scope item 3SM and below is the link for help documentation where this is mentioned:

Business Scenario: Marketing Analytics - SAP Help Portal

CDS-Based Extraction -> Setting Up CDS-based Data Extraction: You should follow the documentation to setting up this tool.

The relevant CDS view to extract Contact Details is I_MKT_CONTACT. It will provide you all attributes of contacts details.

Extract SAP Marketing Cloud Data with CDS-based Export Services
https://www.sap.com/cxworks/article/508636846/extract_sap_marketing_cloud_data_with_cds_based_export...

Hope this helps.

Regards,
Saravana.

[former_member695645]

Thanks so much saravana92 for your answer.