Extending metadata of SAP Marketing API’s In SAP Cloud Platform Integration – Part 2
This blog is successor to this blog. I highly recommend reading first part before proceed to this one.
In SAP Cloud Platform Integration
In SAP Cloud Platform Integration, you can perform activities as shown in below image.
Finding Corresponding Integration Package and Integration Flow
Since we’re replicating opportunities from SAP Cloud for Sales to SAP Marketing Cloud, searching for SAP Cloud for Customer integration package in design tab in SAP Cloud Platform Integration would be a good start. When you find the integration package “SAP Hybris Cloud for Customer Integration with SAP Hybris Marketing”, navigate to “Artifacts” tab. In listed integration flows, you’ll notice the one for replicating opportunities: “Replicate Opportunity to SAP Hybris Marketing”
Click on the integration flow to go into details.
Left click on OData channel and go edit mode. When you select the OData channel, you are going to see two tabs in the below panel: “General” and “Adapter Specific”. Switch to “Adapter Specific” tab
In “Adapter Specific” tab, scroll down until you see “Resource Path” field. Click on “Select” button.
At first step, choose “Remote” as “Connection Source”. In the “Address” field, type the service URL you noted down in first part of this blog series. Choose “Internet” as “Proxy Type”.
“Authentication” and “Credential Name” should be already filled automatically based on integration setting you did for this integration flow while you were setting up your integration with SAP Cloud for Sales.
Proceed to Step 2
At second step, leave “Operation” as “Create(POST)”. Choose “5” as “Sub-Levels” and choose “Import Headers” as “Select Entity”.
And then you can select relevant fields for your integration. You can mark “Select all fields” to select all fields at once (which I did in my implementation)
Finally you can click on “Finish”
Upon clicking on “Finish”, a prompt is going to ask you if you want to save to-be-generated XSD file as a new file. Click “Yes” to save it as a new file.
A new EDMX as well as XSD file are generated and added to integration flow resources automatically. Note down XSD file name (i.e. ImportHeadersEntityPost15.xsd like in this example)
Now go to mapping block in the middle of integration process. Switch to tab “Properties” in the below panel and click on “Resource” hyperlink to go into details:
The mapping between SAP Cloud for Sales web service (the message named OpportunityReplicationBulkRequest here on the left side) and SAP Marketing Cloud OData service (the message named “Import Headers here on the right side) appears. If you expand nodes of the message “Import Headers” and look for our custom field “Sales Cycle”, you can’t find it. At this moment, it’s pretty normal because we haven’t replaced our message with the new one (that XSD file created in previous step) yet. That’s the new XSD file which includes our custom field.
To replace the message with new one, click on the pencil icon on right corner for the message “ImportHeaders”.
Under “Target Messages”, under “Actions” column, click on “Replace message” – the icon next to trash bin icon.
A value help pops up for “Select Target Message”. Now pick the XSD file you noted down in previous steps (It’s ImportHeadersEntityPost15.xsd in our example)
And click on “OK” button to go back to mapping.
And now, that’s it! You see that existing mappings are taken over automatically and your custom field “Sales Cycle” is waiting for you to map it!
If you now expand the nodes of “ImportHeaders” message on the right side, you can find your custom field as “YY1_SALES_CYCLE…” under “BusinessDocument” entity.
Look for “SalesCycleCode” field in the message “OpportunityReplicationBulkRequest” on the left. Once you find it, drag & drop it onto your custom field “YY1_SALES_CYCLE…” on the right side. A blue line should now appear to represent the mapping between these two fields.
Click on “OK” to go back to your integration flow.
Save your integration flow as new version by clicking on “Save as version”. A pop-up appears with a new version. Provide comments if you like and finally deploy the integration flow by clicking on “Deploy”.
Once your integration flow is deployed, you can now test your mapping by creating a new opportunity in SAP Cloud for Sales.
And you can check the results in “Import Monitor” app in SAP Marketing Cloud.
With this extensibility option, you are able to map any custom field created in SAP Marketing Cloud to any field available in source system’s web service in SAP Cloud Platform Integration. This will enable you to bring more data hence more insight to your business.
Great Blog, very clear explanation! Thank you!
can just say thanks for sharing your knowledge here!
Great blog, understandable also for non-techies.
Thanks Matthias. Great to hear that because I put additional effort to make it comprehensive for every type of user of SAP Marketing Cloud.
Thanks for sharing. Really understandable and professional!
Hopes you could also share your knowledge in other yMKT topics. 🙂
Thank you Kevin. Will surely do that with pleasure...
Great blogs!!! Very useful. Keep them coming.
Detailed Explanation. !!!! Great one.!