Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 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
    ------------------------------