I have a client that uses Sage 50 (2018.1 + Connection Manager v7.0). They host Sage on a MS Azure server. They have 6 Companies (DBs) that I'd like to be able to connect to so that I can pull some high-level data into a custom reporting tool we are creating.
I've come close to the right setup: I've setup a user with 3rd Party Products access (with shortened password).
With MySQL Workbench I can make a successful connection to: the.server.ip.addy:13541 etc by looking up the port assigned to each company via the Sage 50 application.
I thought I was in the clear, but as some of you know the port numbers are dynamically assigned, not hard coded as discussed here in the past:
I haven't been able to find any recent discussions on this topic. Is my assumption correct that the situation hasn't changed? I figure I can't be the 1st person to want to be able to do this type of connection to multiple companies on the same server via Connection Manager.
I see the folks over at Logic IM are charging $100 for the KeepAlive service that is mentioned in a few older threads:
I'm hoping to be able to touch base with someone who is running this type of setup. Even if KeepAlive is the only way, that is fine, I'd just like to be able to bounce some questions off anyone doing it that way.
thanks in advance!