In this blog, I will give you an overview of a solution to extract supplier data from a Sourcing event in SAP Ariba Sourcing, and save it in a mailing list in SAP Qualtrics XM for Suppliers, using BTP services.
Process
First, to extract the information from SAP Ariba Sourcing, I use the Operational Reporting for Sourcing (Synchronous) API to get events by date range, and also the Event Management API which returns supplier bid and invitation information from the sourcing events.
Then, I store the information I need in a SAP HANA Cloud database. I created 3 tables to store the information that I will send to SAP Qualtrics XM for Suppliers: RFx header information, Invitations, and Organizations contact data.
Finally, I send all the information needed to a SAP Qualtrics XM for Suppliers mailing list, which will then handle automatically sending surveys to suppliers that participated in the Ariba sourcing events.
To send the information to SAP Qualtrics XM for Suppliers, I use the Create Mailing List API.
Integration
All this is orchestrated by the SAP Integration Suite, where I created 2 iFlows:
- The first iFlow is to get the information from the SAP Ariba APIs, and store it in the SAP HANA Cloud database.
Get RFx Information from Ariba, and store it in SAP HANA Cloud
- The second iFlow is to get the information from the SAP HANA Cloud database, and send it to SAP Qualtrics XM for Suppliers via the Mailing List API.
Get information from HANA Cloud and Send Contacts information to Qualtrics
The SAP HANA Cloud database was created with a CAP application developed in Visual Studio Code.
Final Thoughts
By using SAP Ariba and Qualtrics APIs, as well as a couple of BTP services, integration between the two can be achieved in a very simple way with only a few steps.
In future blog posts I will detail how to create each artifact, so you can leverage this knowledge in similar integration scenarios.
Follow my profile to be notified of the next blog post; and please, let me know your thoughts or questions you have in the comments section below.
