Export historical data - SAP Ariba

[amarkov]

Hi, I'm looking for a convenient way to export some historical data from SAP Ariba.

Preferably via API, however a manual process would also be helpful.

I'm looking to get ALL past data related to:

- Purchase Requisitions (along with all info related to the items, quantity, price, etc.)

- Sourcing Projects (along with documents, tasks, events, etc.)

- Guided Sourcing Projects (along with items, participants, award scenarios and tasks)

I searched and I could find ways to export part of the data, but no good way to get it all.

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

[gabrielmendes]

Hello you should evaluate Analytical Reporting API https://help.sap.com/docs/ariba-apis/analytical-reporting-api-for-strategic-procurement-and-operatio... (and maybe Operational Reporting API) from the Developer Portal API

Difference:

• Analytical Reporting API works with Facts and Dimensions, same used for Ariba reports, so if you can build a report in Ariba with the combination of the Facts(Tables) this is your api, it will give you all details based in Facts so you can combine/join them in an external DB
• Operational Reporting API works based in DocumentTypes (no Facts or reports from Ariba), example, Requisitions, Purchase Orders, Sourcing Events RFx, etc...

Let me know if it helps.

[Neeraj_Jain1]

Hello amarkov,

Please refer below SAP help link.

https://help.sap.com/docs/ARIBA_SOURCING/36a99e6ce8954882ba1cbe6d42056c3e/7c4607af71ea101483e8e16b5d...

Regards,

Neeraj Jain

[amarkov]

Thanks Neeraj, this is how to extract a single sourcing event - my goal is to extract at least a year full of data, so one by one won't do the trick. If you know of a more scalable way that would be amazing!