Automate

 View Only

  • 1.  On-line excel

    Posted 06-18-2020 18:20
    I don't know if this already exists.
    Is there a way to get data refreshed in a excel file as a data source? I mean, having a SAP data report that can be saved as an excel file on a daily/weekly/monthly basis which can be connected to SAP ERP and refresh on load or updated data.

    It use to be called Office Extensions when connecting excel to ERP, I don't if with SAP the name remains the same.

    ------------------------------
    Edgar Jalane |
    Total S.A. |
    ------------------------------


  • 2.  RE: On-line excel

    Posted 06-19-2020 10:59
    Hi Edgar,

    When I go to Get Data from SAP HANA Database in Excel, I get this message:


    And the Learn more link takes me to this page:

    https://support.sap.com/en/my-support/software-downloads.html

    So it looks like it's possible, but I don't know any details beyond this. 

    From a Winshuttle perspective, you can have Excel refreshed with data from SAP by scheduling a Query job to run daily/weekly/monthly:

    http://winshuttle-help.s3.amazonaws.com/studio/en/central-sap/help/12/schedule-query-run.htm

    Here is more information on Winshuttle Query: https://www.winshuttle.com/products/query/

    Thanks,


    ------------------------------
    Maria Simpson | Solutions Engineer
    Winshuttle North America | 4255276647
    ------------------------------

    Original Message