https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaa-p/12482274#M4676502 <P>Hi,</P><P>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 <STRONG>and</STRONG> 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.</P><P>You will find further information in the documentation:</P><P><A href="https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/40528c71abe14ec5a8c2e72c2a584a29.html" target="test_blank">https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/40528c71abe14ec5a8c2e72c2a584a29.html</A></P><P>We are also preparing a number of blogs describing how the API can be used in various situations.</P><P>Best regards</P><P>Gerd</P><P>(Dev. SAC Planning)</P> Wed, 30 Mar 2022 06:51:22 GMT gerd_schoeffl 2022-03-30T06:51:22Z https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaq-p/12482270 <P>Dear Team,</P> <P>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. </P> <P>Please suggest.</P> <P><A href="https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/986358761788405e938e68204723676c.html" target="test_blank">https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/986358761788405e938e68204723676c.html</A></P> <P><A href="https://blogs.sap.com/2022/02/11/sap-analytics-cloud-export-api-for-planning-data-roadmap-highlight/" target="test_blank">https://blogs.sap.com/2022/02/11/sap-analytics-cloud-export-api-for-planning-data-roadmap-highlight/</A></P> Sat, 19 Mar 2022 13:50:11 GMT https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaq-p/12482270 Rushikesh_Yeole 2022-03-19T13:50:11Z https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaa-p/12482271#M4676499 <P>Hi,</P><P>My latest blog should point you in the right direction.</P><P>Find it <A href="https://blogs.sap.com/2022/02/11/sap-analytics-cloud-export-api-for-planning-data-roadmap-highlight/">here</A>.</P><P>Nick </P> Tue, 29 Mar 2022 12:43:54 GMT https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaa-p/12482271#M4676499 Nverhoeven 2022-03-29T12:43:54Z https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaa-p/12482272#M4676500 <P>More info regarding Data Export Service can be found <A href="https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/40528c71abe14ec5a8c2e72c2a584a29.html">here</A>.</P> Wed, 30 Mar 2022 00:15:32 GMT https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaa-p/12482272#M4676500 shady_shen 2022-03-30T00:15:32Z https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaa-p/12482273#M4676501 <P>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.</P> Wed, 30 Mar 2022 00:18:26 GMT https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaa-p/12482273#M4676501 shady_shen 2022-03-30T00:18:26Z https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaa-p/12482274#M4676502 <P>Hi,</P><P>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 <STRONG>and</STRONG> 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.</P><P>You will find further information in the documentation:</P><P><A href="https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/40528c71abe14ec5a8c2e72c2a584a29.html" target="test_blank">https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/40528c71abe14ec5a8c2e72c2a584a29.html</A></P><P>We are also preparing a number of blogs describing how the API can be used in various situations.</P><P>Best regards</P><P>Gerd</P><P>(Dev. SAC Planning)</P> Wed, 30 Mar 2022 06:51:22 GMT https://community.sap.com/t5/technology-q-a/export-planning-data-to-sql-server-from-sac-planning-models/qaa-p/12482274#M4676502 gerd_schoeffl 2022-03-30T06:51:22Z