Export data from SAC model to oData Service
Export to oData Service
You can create a connection that allows you to export data to data sources using oData services.
Export transaction data from SAC to BW
As the first user case for export data to OData Services, we support exporting data to SAP BW/4HANA 2.0 or BW 750 system using oData service(Refer to BW note 2838883 for detailed support packages). But we do NOT support exporting data to sources other than BW.
With oData services, user can:
- Export fact data filtered by the selections to BW. Only BW Standard ADSOs with write change log (optional) and write interface-enabled are supported
- Map dimensions between SAC and BW, or map a property of SAC dimension to that of a dimension of BW
- Set default value for the dimension of BW if there is no source dimension to be mapped
- Choose to export the data once, or on a recurring schedule.
SAC/BW Import & Export
User can import data from BW to SAC via BW connection, and can export data from SAC to BW via oData service connection.
Can you contact me about joining the pilot program via firstname.lastname@example.org?
Martijn van Foeken | Interdobs
It's avaiable in BW4/HANA 2.0 SP04 now. You can refer to note 2838883.
I would like to join the pilot program as well. Could you please contact me on email@example.com.
Many thanks and regards
David Šinkmajer, MIBCON NDC
I would like to join the pilot program as well. Could you please contact me on firstname.lastname@example.org . I am working on connectiong SAC with S/4HANA using oData for Pricing records update from SAC platform.
Thanks in advance.
Lakshmi Narayana N
Any news? When will this feature be available?
I can see the ODATA export connection in SAC, however, cannot find any documentation.
you raise a good point. I was looking at the 'fastrack' (biweekly) help pages in this area (Wave 5 2020 at time of writing) : https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2020.5/en-US/986358761788405e938e68204723676c.html
and indeed there is no mention of it yet!
I expect the 'mapping' and 'filtering' of the export will be broadly similar to BPC, S/4H, and IBP - these are all very similar in their approach.
However i think it's important that we ask Sarau Shen to ensure the documentation is brought into line. I will email internally also.
Thanks for bringing this to our attention.
Documentation is here:
Hi Sarau Shen,
so it's not possible to export data from SAC to custom table on a database (es HANA) or on S/4 ?
Maybe you can clarify this doubt.
Thanks in advance
Hi Daniele Comincini,
It's not supported currently. Exporting via oData service requires oData services implemented in target system. These oData services are only implemented by BW currently hence only BW is supported as the export target system.
Can you explain your statement a little more? “These oData services are only implemented by BW currently”
oData is an open data standard, in what way would it only be implemented by BW? From having written an oData import connector into SAC, my current understanding is that SAC uses a somewhat custom fork of oData V2.
Are the SAP customizations to oData for export defined anywhere?
I did some digging and I don't think this needs a response unless you have roadmap details on a real outbound connector.
The answer is that even at the $metadata level, there are tons SAP namespaced attributes (including redefining standard attributes), so a standard oData endpoint won't be able to be leveraged.
For example, here is an SAP BW/4 Entity Type
<EntityType Name="XXXXXX" sap:creatable="true" sap:updatable="true" sap:deletable="true" sap:content-version="1" sap:change-tracking="true" sap:maxpagesize="2000000000">
Can you explain how did you get the $metadata level, please?
I’m trying to find an alternative way to export a SAC model, since SAC job for OData Services is only available for SAP BW/4HANA 2.0 or BW 750 targets. I hope to achieve this using a REST API to extract the model as JSON, however I need to access a model using URL.
Is there any plan to export to generic Odata targets?
I want to get my planning data back into an SAP HDI container but there seemed to be no way to do that.
I a perfect world I would be able to save it on publish, but the standard Export to either HANA HDI container or generic OData 4 service would be good enough.
I have implemented the bgRFC endpoints that SAC uses in Python and would be able to support the HANA development team deploy a similar solution in HANA (via an XSC/XSA python buildpack). Please send me a direct message if you would be able to make the initial connections to make this happen.
Hello, JS Irick, may you please tell me if there is any progress on this topic?