Skip to Content
Technical Articles

Loading CSV Data with SOAP UI into SAP Hybris Marketing Cloud and SAP Hybris Marketing

You have to call the OData Service CUAN_IMPORT_SRV in order to load master data like contacts or products and interaction data into SAP Hybris Marketing Cloud and SAP Hybris Marketing. Normally you have a middle ware like SAP HANA Cloud Integration (HCI) in place to connect your source system or source CSV File with the OData Service. If you require a test data upload of CSV data, you can use the following tutorial.



  1. Install SOAP UI:
    This tutorial uses the open source product SOAP UI for uploading data. Therefore first install the tool.
  2. Import SOAP UI project:
    Import the SOAP UI project XML by choosing File -> Import Project. You find the XML under
  3. Creating of Communication User:
    1. Creation in SAP Hybris Marketing Cloud:
      Log On to your SAP Hybris Marketing Cloud System. Ensure that your user has access to the business catalogue Communication Management:
      Open the app Communication Systems and choose New. Enter a system ID like SOAP_UI_UPLOAD. The host is localhost. Create a new Inbound User, e.g. MKT_UPLOAD:
      Afterwards open the app Communication Arrangements. Create a new communication arrangement for scenario SAP_COM_0003 (Marketing – Master Data Integration) and SAP_COM_0004 (Marketing – Business Data Integration) and assign your newly created communication system. The inbound communication user should be taken over and you should see the OData service CUAN_IMPORT_SRV in the inbound services section:
    2. Creation in SAP Hybris Marketing:
      Log on to your SAP Hybris Marketing Backendsystem. Copy role SAP_CEI_ECOMMERCE_INTEGRATION and maintain the authorization values. Create a service user and assign your copied role to this user.


Prepare Data Files

The data upload requires 2 files, one CSV File containing the data and one text file containing the mapping of CSV columns to OData Properties.

The CSV File requires a header row. Line items have to be separated by semicolon. This is an example for products:

EXTERNAL;P1;Product 1
EXTERNAL;P2;Product 2
EXTERNAL;P4;Product 4


The metadata file must contain the mapping from the OData Service property to the CSV column separated by colon. The corresponding metadata file for product therefore would look like this:




Your CSV file can contain more columns than you want to upload to the system. Only columns mapped in your metadata file will be uploaded. You can open the OData metadata document with any browser by entering the URL:


https://<your host name>/sap/opu/odata/sap/cuan_import_srv/$metadata?saml2=disabled


You will be prompted to enter a user and password. Logon with your communication user.


Specialties for Contact and Interaction Files

For contacts and interactions you are able to upload depending data. In case of contacts those depending data are facet information. For interactions you can upload products. In order for the tool to find the depending data a key column is needed in the data files. For contacts the data files could look like this:


Contact Data File:





Facet Data File:





If you want to provide a Date of Birth for contacts you have to provide the date in format yyyyMMdd. Timestamps have to be provided in format yyyyMMdd or yyyyMMddHHmmss. If you are not providing a timestamp for a contact, the current time is taken. For interactions a timestamp is always required.


Data Load

  1. Open the imported project in SOAP UI and drill down to your desired data upload:
  2. Double click the upload to open it:
  3. Double click on Inputs to enter the needed upload information:
  4. You can now start the upload. Close the inputs window and press the start button of the upload case:
  5. When the upload was successful the upload will end with a corresponding success message. If the upload fails, your data might have incorrect values. Check the script log for error. You can always start the upload again.
You must be Logged on to comment or reply to a post.
  • hi,

    just recommended it to an ex-SAP colleague to load some 3000 marketing attributes from a CSV file 😉

    thanks for the article,

  • Thanks for the Blog. Can you tell me how to check the raw data being loaded in yMKT? I have interactions apparently loading successfully but I can't see them on the Account or Contact view.
    I can't see the records being added to interactions table CUAND_CE_IA_RT. I suspect there might be some missing configuration?  Is there any staging area table where the data is loaded?

  • Great blog,

    I am facing an issue with on-premise 1709.

    No authorization to upload CSV file for interaction contacts. I have most authorizations I could find and added SAP_MARKETING_BUS_ADMIN_USER to allow importing off test data. Log file shows error however of missing authorization. Is there another role I would need to add to my user?

    I also have composite roles SAP_MARKETING_EXPERT and …_MANAGER but I might be missing one? Where can I set the authorization levels in 1709?

    Thanks Frank


    We found the solution for this issue. One of the back end users was set up as BATCH_USER and did not have the authorizations of my user attached to it. So even the Fiori front end process stated import of 12 records successful the trace showed that the job was canceled. That info is not relayed to the front end unfortunately. Only indication was no update of contact tables etc.

  • Hi Eileen Koehler,


    I use your SOAPUI script very often for uploading test and demo data, so thank you so much for sharing it.

    The service that is used in the script is CUAN_IMPORT_SRV, but that's deprecated. For now it still works, but would there be a new script using API_MKT_CONTACT_SRV and API_MKT_INTERACTION_SRV available?


    • Hi Eileen Koehler, , I just used the script again, it shows that everything ran successfully, however nothing appears in the marketing cloud system, not even in the import monitor 🙁 So I suppose CUAN_IMPORT_SRV actually stopped working now...

      What's the alternative to getting interaction data with product info into a cloud system now? This script was so easy and fast to use...