Automate

 View Only
  • 1.  How to feed live data from UNISOL ERP into Excel

    Posted 06-18-2020 18:17


    Using Excel it's possible to read on-line data from ERP; by having calculate control outputs; or refresh data directly into reports templates.
    Will it be possible?


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


  • 2.  RE: How to feed live data from UNISOL ERP into Excel

    Employee
    Posted 07-15-2020 11:06
    Hi Edgar

    Not 100% I understand your question.

    You can use Winshuttle Query to pull data from SAP, as well as apply excel formulas to the output.   You can refresh on demand by running the Query again or scheduling it. 

    For non-SAP data, Excel allows you to pull data in from a wide variety of sources.  Whether they can apply formulas or not will differ based on the source, but you can certainly apply them afterwards. 

    Hope that helps a little.  If not, please further explain your request.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------