Sage 100

 View Only
Expand all | Collapse all

Sage Intelligence in a Cloud hosted environment

  • 1.  Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 12:52

    Hi Everyone,

    Hope the summer is going well (and not too hot)!

    I have a client that has 20+ users in a cloud environment on 3 different AVD servers.  They can get logged into any of the 3 machines.  We have 2 Sage Intelligence licenses which are installed on the most popular of the 3 machines - only two users use Sage Intelligence.  We are having nothing but issues every time they go to run the SI reports and the CFO is now totally frustrated - sometimes they work, sometimes they don't.  Does anyone have experience with this (the IT company keeps coming back and saying its a Sage issue) - today it's an Excel issue with the plug-in - not sure why that changed.

    I would love to hear the groups thoughts on Sage Intelligence as more folks are moving to the cloud and what would be a better replacement or solution.

    Thanks, as always appreciate your responses.

    Jacquie.



    ------------------------------
    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    ------------------------------


  • 2.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 13:02

    I believe SI licenses are by machine (not user)... someone please correct me if I'm wrong. 

    So, either those two users need to always connect with one of the machines with a license, or the client needs to buy one more, for the 3rd machine.

    Alternatively, in theory, the 2 users could be given access to License Manager, with instructions on how to move the licenses around, as needed.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 13:14

    Hi Kevin,

     

    Yes, you are correct, the licenses are by machine not user.

    Getting the 3rd license is definitely an option but something (not sure if it's the environment or how the program works) is so unstable.  For example the same user can work on machine 1 and it works for a week or so and then they switch to machine 2 (which has the license) and it doesn't work any more.  Is there possibly an issue with the workstation install with them switching machines.

     

    We have no Sage 100 issues only SI.

    ---

    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    Phone:
    516-867-6752
    Fax: 516-867-9465
    Email: jhoyte@i-datatech.com
    Website: https://www.i-datatech.com
    Address: 1225 Franklin Avenue, Ste. 325 Garden City, New York 11530
        Putting your vision to work with solutions that fit.

    ----------
    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.






  • 4.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 13:25

    It is entirely possible there are machine specific technical issues, like having the correct Windows user permissions set, having the correct DLL registered (and plug-ins active in Excel)... Basically you go through the Sage KB articles on each machine.  Don't just trust that IT has the machines set up identically.

    Licensing is a separate conversation.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 5.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 13:32

    Any idea on workstation setup installation when the machine changes?

    When you run workstation setup for a specific user and the dlls are registered, if the user changes machines does workstation setup need to be run again so that the dlls are now registered for that user on that machine.  Not sure how roaming or cloud profiles work.

     

    From your response, I am now thinking this is where the issue may be coming from.

     

     

    ---

    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    Phone:
    516-867-6752
    Fax: 516-867-9465
    Email: jhoyte@i-datatech.com
    Website: https://www.i-datatech.com
    Address: 1225 Franklin Avenue, Ste. 325 Garden City, New York 11530
        Putting your vision to work with solutions that fit.

    ----------
    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.






  • 6.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 13:39

    It depends on the technical setup.  Conventional remote desktop servers have the workstation setup done once, and not at each login.  User profiles don't change what programs are installed on each machine. 

    Get machine 1 working, and it should work the next time they use machine 1, unless something happens to break machine 1.

    Get machine 2 working, and it should work the next time they use machine 2, unless something happens to break machine 2.

    VDI, as Wayne describes, is a different scenario entirely.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 7.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 17:00

    Is anyone familiar with Insight Software's Financial Reporting solution?

    Thoughts?

     

    Have a good weekend!

    Thanks. Jacquie.

     

     

    ---

    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    Phone:
    516-867-6752
    Fax: 516-867-9465
    Email: jhoyte@i-datatech.com
    Website: https://www.i-datatech.com
    Address: 1225 Franklin Avenue, Ste. 325 Garden City, New York 11530
        Putting your vision to work with solutions that fit.

    ----------
    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.






  • 8.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 13:04

    SI issues definitely seem to come in waves, but I can think of at least 5 clients on SWK's cloud who are pretty regular users and do not have regular issues.  One of them we had to completely uninstall Excel and reinstall it once, but then they didn't have issues for over a year after that. BUT, I suppose the more it's used, the greater the chance of an issue any particular time, and maybe my users just aren't as beefy as yours.

    But I also have quite a few other clients accessing their local server via remote desktop/terminal server/citrix farms, which is basically what you've got there, and they're not having consistent issues, either.

    Are they on newer versions of Sage and Excel?



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 9.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 13:16

    Thanks Beth,

    They are on Sage 100 2022.  I am sure it has something to do with the environment and how it is setup.

    They were on RDP for years without any issues but because they are on these virtual machines we are having all types of issues.

     

     

    ---

    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    Phone:
    516-867-6752
    Fax: 516-867-9465
    Email: jhoyte@i-datatech.com
    Website: https://www.i-datatech.com
    Address: 1225 Franklin Avenue, Ste. 325 Garden City, New York 11530
        Putting your vision to work with solutions that fit.

    ----------
    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.






  • 10.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 13:29

    I have a very high security customer using VDI ( Virtual Desktops ) which is similar but not the same as a remote connection to a server. Their IT resolved the issue by assigning the SI users to a static computer vs a VDI which ( to my understanding ) resets itself each time the user logs in. I don't know how they did this but the IT was VERY technical and I think what happens is instead of having the SI user assigned a random refreshed computer upon each login they somehow configured VDI so that the SI user always came up with the same computer/computer name.

    I'm sure it's more complex than this though that's my understanding of how they resolved the SI issues they had been having.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 11.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-21-2024 13:34

    Thanks Wayne,

    That's exactly it – the IT company wants to charge the client an exorbitant amount to give these two users a dedicated machine.

    Any suggestions for a replacement system to Sage Intelligence for financial statements.

     

     

    ---

    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    Phone:
    516-867-6752
    Fax: 516-867-9465
    Email: jhoyte@i-datatech.com
    Website: https://www.i-datatech.com
    Address: 1225 Franklin Avenue, Ste. 325 Garden City, New York 11530
        Putting your vision to work with solutions that fit.

    ----------
    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.






  • 12.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-22-2024 16:49

    A couple thoughts here.

    1. Introduce them to Sage Partner Cloud as an alternative. I really don't know if they'll fit for you (although likely), but suggest an alternative to the IT firm which is holding YOUR support hostage.

    2. Seriously consider DataSelf. They're best known for robust data analysis BUT they also do Sage Intelligence-style reporting quite well. 



    ------------------------------
    Jerry Norman
    Smartbridge Partners
    (512) 653-7498
    ------------------------------



  • 13.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-24-2024 09:55
    Thanks Jerry
    Do you (or anyone in the group) have a contact at DataSelf?

    Thanks again.

    Jacqueline Hoyte
    Director of Client Services

    {/RT}T: 516-867-6752
    E: jhoyte@i-datatech.com

    1225 Franklin Avenue, Ste. 325
    Garden City, 11530

    www.i-datatech.com




  • 14.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-24-2024 10:17

    Hi Jacqueline!  You can reach our to Tom Fitzpatrick at sales@dataself.com.



    ------------------------------
    Michelle Taylor
    DSD Business Systems
    ------------------------------



  • 15.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-24-2024 10:24

    Thanks Michelle,

    Really appreciate it!

     

    Have a good day!

     

     

    ---

    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    Phone:
    516-867-6752
    Fax: 516-867-9465
    Email: jhoyte@i-datatech.com
    Website: https://www.i-datatech.com
    Address: 1225 Franklin Avenue, Ste. 325 Garden City, New York 11530
        Putting your vision to work with solutions that fit.

    ----------
    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.






  • 16.  RE: Sage Intelligence in a Cloud hosted environment

    Posted 06-22-2024 17:48
    Edited by Doug Higgs 06-22-2024 17:51

    It seems possible that what Wayne is describing is that the VDI virtual clients are getting their IP addresses via DHCP (dynamically) when they log in.  Because the IP address is assigned dynamically during the log in, it may not be the same IP today that is was yesterday.  I know the SI License Manager uses the computer name, however, TCP/IP uses a IP address mapped (translated) from the computer name.  You may ask IT, as a test, to change the logon process for the SI users so they use a static IP instead of a dynamic IP.  It would be a simple change (seemingly) and may be worth testing. 



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------