Export planning data to SQL server from SAC planning models

[gerd_schoeffl]

Dear Team,

Requirement is to export the planning data ( Transactional) from SAC to 3rd party SQL server. Is there any way apart SFTP/Flat file. As per my understanding, ODATA supports for SAP systems only. I have explored below links.

Please suggest.

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/986358761788405e938e68204...

https://blogs.sap.com/2022/02/11/sap-analytics-cloud-export-api-for-planning-data-roadmap-highlight/

[gerd_schoeffl]

Hi,

The new oData (CDI) based Data Export API (as also described in the second link you have added above) can be used by SAP tools and third party tools to retrieve data from SAC. It is available with QRC1.22 as a restricted shipment (customers can claim the feature to be activated in their system) and will be generally available with QRC2.22.

You will find further information in the documentation:

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/40528c71abe14ec5a8c2e72c2...

We are also preparing a number of blogs describing how the API can be used in various situations.

Best regards

Gerd

(Dev. SAC Planning)

[shady_shen]

More info regarding Data Export Service can be found here.

[shady_shen]

ETL tools can use the Data Export Service API to E(xtract) the data from SAC models, perform T(ransformation) and L(oad) into any supported target.

[Nverhoeven]

Hi,

My latest blog should point you in the right direction.

Find it here.

Nick