News about the SAP Analytics Cloud Data Export Service (+ an exciting announcement)
The Data Export Service surely was a highlight on the 2022 SAP Analytics Cloud roadmap. It enables countless new use cases given its flexibility and speed. Bi-directional data transfer for planning with SAP Data Warehouse Cloud, insight to action with LOB applications, and enhanced on premise integration are just few examples for that. Make sure to review all the great blog posts that have been published until now: Data Export Service blog posts
In this blog post, I want to give you an update on new features coming your way with QRC1.2023. I recommend reading it all the way to the end if you do not want to miss out on an exciting announcement 😉
Delta export – monitoring and configuration UI
In Q4 2022, the delta export capability was introduced to the Data Export Service. The delta functionality allows you extract any data changes such as insertions, deletions and updates, in a planning model. This simplifies and reduces the time of your export operations as it avoids full data extraction to retrieve the latest data from the planning model. If you store planning analytics or forecasting data in an external system for example, there’s no longer need to truncate the table and run a full export. Instead, export the delta and adjust the target table performing upsert and/or delete based on the delta.
The delta functionality works along with a subscription concept, introduced by the Cloud Data Integration specification (CDI). You need to create a subscription on a given planning model to extract the delta data from that model. This allows you to retrieve the differences in data over a specified period. These subscriptions track the changes made to a particular model, over a specified time period.
With QRC1.2023, we are adding a UI inside the Data Management space of the SAC model itself to help you manage these delta subscriptions. It provides you with detailed views of subscription chains. You can create, delete, and examine subscriptions for a model with selections and filters, and view recent subscription activity in chronological order through the access timeline.
Streamlining of export job configuration
As you can see above, the Data Management space is currently being redesigned to offer a visual interface to manage the Data Export Service subscriptions directly within SAP Analytics Cloud. To prepare for these changes, we’ve changed the way the way to push data to SAP S4/HANA, SAP Business Integrated Planning, SAP BW and SAP BW4/HANA using OData services. By default, only the file and the SAP BPC options are now available. To be able to push data to other applications, you can now enable the Enable Legacy Export option first. Please note that as a best practice, we recommend using the Data Export Service whenever possible to export data.
What will be next?
In the area of the Data Export Service API, we plan to enable the export of currency rate tables in Q2 2023.
And most importantly, we add a new member to our API family! Please, stay tuned for our Data Import API that is planned to be available on the SAP API Business Hub in in Q2 2023! Once more, this is a generic API – this time to push data into both fact tables (public versions) and local dimension master data (public dimensions to be added asap). It shall allow data workflows to go all the way to the model, for example, using Data Intelligence or SAP Cloud Integration Suite.
So, that’s it… but just for now 😉 Our data integration team will continue to ship exciting innovation to you. So much is for sure.
Thank You so much for the sharing, Maximilian!
Few questions would like to ask:
Thanks for your comment.
Can you share the help page that you are referring to ("the suggested option to export data to S/4HANA is still using the "S/4HANA export" option instead of API")?
As of now, I can recommend you this blog post: https://blogs.sap.com/2022/10/25/using-sap-analytics-cloud-api-data-export-service-from-sap-s-4-hana/
Thanks for the reply.
Please check below for the latest help document for exporting data from SAC to S/4HANA and S/4HANA Cloud:
S/4HANA: Exporting Plan Data to SAP S/4HANA or SAP S/4HANA Cloud | SAP Help Portal
S/4HANA Cloud: Exporting Plan Data to SAP S/4HANA or SAP S/4HANA Cloud | SAP Help Portal
Both guidelines are the latest one for data export from SAC to S/4 and are actually the same. They mentioned "In the Export Jobs area, choose the Export button and select Export Data to SAP S/4HANA."
Also great to know that SAP is working on the standard content/ best practice for the integration with S/4HANA on-premise. As it helps a lot if we need to change the legacy option to API to export the data back to S/4 some day in future.