Running code on another machine

Question

Question

Anna Golitsyna · Nov 11, 2020

Hi everybody,

Is there a way to run code on another machine? Of course, all authentication info is known. I know only about RemoteResultSet but that seems to be query specific.

Thanks in advance,
Anna
P.S. The ultimate goal, in case that matters, is to create identical globals on 2 different machines with one run.

Discussion (22)2

Log in or sign up to continue

Robert Cemper · Nov 16, 2020

Hello @Anna Golitsyna!
the 3rd example is 1 class that contains 2 basic functionalities: A Server and a Client.
The system you want to control runs the ClassMethod Server.
- opens an IP port and listens for orders, execute it, and continue looping.
- it is typically started in the background during system start (from %ZSTART.mac)
This is the "hidden Login"

The (Classmethod) Client connects to the listening port and sends a request and gets answers.
The structure of Requests and Answer is up to you and makes sure you have always control
over what should happen on the remote system. As your "Listener" is active already there
is no need for any further login. But you are of course free to implement it on top of this basic mechanic.

3 0

Robert Cemper · Nov 21, 2020

@Anna Golitsyna
If you have access over ODBC this article may help you.
https://community.intersystems.com/post/objectscript-over-odbc

2 0

score 3 · Answer 1 · 2020-11-11T13:11:17-05:00

see these 3 possibilities with examples in OEX

score 0 · Answer 2 · 2020-11-11T13:18:12-05:00

I'll look up applications under the first and the third link, thanks. The middle one is specific to IRIS, just checked, and I have Cache. I was more hoping for a short set of commands but if that is not available, oh well.

score 2 · Answer 3 · 2020-11-11T13:23:01-05:00

Robert Cemper · Nov 11, 2020

I didn't mention SOAP WebServices that you can generate directly in Studio.

2 0

score 0 · Answer 4 · 2020-11-16T11:31:20-05:00

I looked up your single class under your third link and it's probably a total newbie question but I don't see where would you specify login info for the remote server.

score 2 · Answer 5 · 2020-11-11T15:37:04-05:00

You could try creating a web application on the other machine and then using a REST HTTP method to call the code to execute and return a data packet back as a %response object. This would be similar to calling a method from an Angular UI to you server, but can be accomplished using %HTTP Requests from server A to server B as well.

score 2 · Answer 6 · 2020-11-12T08:39:00-05:00

Mirroring is about creating identical globals on multiple machines with one update. I assume you don't want these systems exactly the same, but depending on what you do want, maybe you could find a configuration which would do it. For example, maybe you could put the global you want replicated in its own database on an async member and not mirror any other databases.

score 0 · Answer 7 · 2020-11-17T02:20:43-05:00

Evgeny Shvarov · Nov 17, 2020

@Anna Golitsyna, why mirroring (async?) is not an option?

0 0

score 0 · Answer 8 · 2020-11-18T10:08:22-05:00

@Evgeny Shvarov If by mirroring you mean this, https://www.intersystems.com/resources/detail/intersystems-cach-database..., it seems like a huge overkill just to keep two globals in sync across network. This is not a backup situation. If mirroring could be scaled down to such a task, I am all ears.

score 0 · Answer 9 · 2020-11-18T12:05:26-05:00

Async mirrors are commonly used for reporting and other purposes. What do you want to scale down to use it here?

score 0 · Answer 10 · 2020-11-18T12:24:09-05:00

@Katherine Reid My goal is to update two globals on two different machines at the same time. That needs to be done from time to time only. Would or could "other async mirrors purposes" include that? If so is there any technical reading or specific classes, or the namespace setup, related to async mirroring that you would recommend to use for such a job? For example, this 101 guide, https://community.intersystems.com/post/cach%C3%A9-mirroring-101-brief-g... , specifically states "Deploying a Caché mirror does, however, require significant planning, and involves a number of different procedures. And like any other critical infrastructure component, the operating mirror needs ongoing monitoring and maintenance." Given that I simply need to keep two globals in sync the Export/Import process seems much faster that what is described by this mirroring quote.

score 0 · Answer 11 · 2020-11-18T12:40:18-05:00

Anna Golitsyna · Nov 18, 2020

More importantly, as I just found out, "mirroring is unavailable for the current license"

0 0

score 0 · Answer 12 · 2020-11-19T10:11:26-05:00

Hi. If all you need is to set global nodes on a remote instance, then you could just set it up as a remote database and namespace and use Extended Global References to access it. No need to run code on the remote system. Or have I missed something?

score 1 · Answer 13 · 2020-11-19T12:08:12-05:00

It might be a hard exercise to manage write access from a local and a remote instance to a common DB at the same time.

score 0 · Answer 14 · 2020-11-20T03:47:45-05:00

"mirroring is unavailable for the current license"

It seems that they have a single server license, so ECP is probably not an option as well.
Otherwise, it's difficult to imagine the scenario when ECP remote (single!) database would not be better than duplicating the data in two databases. Just two cases come to mind:

slow internet connection
need to dedicate a whole server for some heavy data processing.

Anna, if you tell us more about your task, we'd likely advise you better.

score 2 · Answer 15 · 2020-11-20T05:45:32-05:00

It all sounds like a software provider in maintenance for its customers.
But then, I would connect with Studio (or similar), place my code and run it from the embedded terminal.

score 0 · Answer 16 · 2020-11-20T08:55:44-05:00

It all sounds like a software provider in maintenance for its customers.

In such a case it is usually easier to map that global from the separated database and distribute its updated copy among the customers.

score 0 · Answer 17 · 2020-11-20T09:09:51-05:00

A few people have suggested using web services, which seems like the most straightforward approach to me. Anna, is there a reason not to use a web service?

score 0 · Answer 18 · 2020-11-20T16:54:26-05:00

Marc, I'll consider going the Web Service way, but I am not a total but still a beginner in Cache. I never used Web Services before so I would need to learn that. I wish there would something as straightforward as the RemoteResultSet queries which take just a few short and obvious lines of code, no learning curve.

score 0 · Answer 19 · 2020-11-20T17:06:14-05:00

@Alexey Maslov The ultimate goal is to create identical globals on 2 different machines with a single run, on demand. I can run code on the first machine, then export global creating code which changes regularly, reconnect the Studio to a different machine, import code, then run it again. This is decidedly not a single run. I can also export and import global too, of course. I am willing to learn functionality that would be faster to deploy than these two approaches. Ideally as fast as ZN which unfortunately works on the same machine only but I might be wrong about that.

score 0 · Answer 20 · 2020-11-20T16:48:46-05:00

Anna Golitsyna · Nov 20, 2020

Mike, @Alexey Maslov is exactly right: no licensing for ECP either, just checked.

0 0