Download globals from a particular server

Question

Question

Evgeny Shvarov · Aug 8, 2023

#Globals #Interoperability #InterSystems IRIS

Hi developers!

Could you please advice what is the easiest way to download globals from a particular server?

I have the access to it, I know which globals I need to download/copy (5-7 globals per name). This is to perform then analysis in IRIS BI.

Setting up a DR Async Mirror in this case is not an option (but is a usual way to do things).

I think of setting up a REST which I call and get the global in JSON back. Is it too crazy? :)

I remember that previously we had an option of REMOTE Mounting - that'd be great. I could run a few merges and that's it. But don't see how to perform it with IRIS.

Any thoughts?

Product version: IRIS 2023.2

Discussion (17)2

Log in or sign up to continue

Robert Cemper · Aug 8, 2023

My 5th Choice:

use Native API for ObjectScript for access.
especially %Net.DB.Iris

1 0

score 1 · Answer 1 · 2023-08-08T07:58:12-04:00

Robert Cemper · Aug 8, 2023

My First Choice:

use ECP to mount a Remote DB.
copy the Globals

1 0

score 0 · Answer 2 · 2023-08-08T08:11:41-04:00

Robert Cemper · Aug 8, 2023

My 4rd Choice:

as you have access export the Global to a file
copy the file using SSCP

0 0

score 0 · Answer 3 · 2023-08-09T05:40:40-04:00

Evgeny Shvarov · Aug 9, 2023

This needs a commercial license, but seems as a working approach.

0 0

score 1 · Answer 4 · 2023-08-08T08:03:17-04:00

Robert Cemper · Aug 8, 2023

My Second Choice:

connect to the server over SQLgateway (Odbc, Jdbc).
use Global Dump to SQL

1 0

score 0 · Answer 5 · 2023-08-08T08:07:00-04:00

My 3rd Choice:

get a network file connection to the source DB
mount the DB over the network as remote drive

mixing file systems Win / *UX might be tricky

score 0 · Answer 6 · 2023-08-09T05:42:51-04:00

I see Get method there, but I think it will be to expensive to "get" all the nodes via network.

Maybe I could use some system classes and run a method to read from a global? Any ideas of such a system class and method? Anything Stream related?

score 0 · Answer 7 · 2023-08-09T06:16:54-04:00

Robert Cemper · Aug 9, 2023

you may run an export ^%G like on the remote server and then copy somehow the result

0 0

score 0 · Answer 8 · 2023-08-09T06:11:07-04:00

Robert Cemper · Aug 9, 2023

It's an orgy of IsDefined ($DATA) and GetNext( $ORDER) as equivalent of $QUERY is not implemented

0 0

score 0 · Answer 9 · 2023-08-10T12:15:16-04:00

Robert Cemper · Aug 10, 2023

example moved here Remote Global Listing using NativeAPI for ObjectScript #1

0 0

score 0 · Answer 10 · 2023-08-08T10:22:43-04:00

My #1 choice would be:

go to Management Portal -> Globals
select globals as needed
choose Export, then select browser instead of server
then the .gof file will be downloaded to your local filesystem.

score 0 · Answer 11 · 2023-08-08T10:32:30-04:00

Ben Spead · Aug 8, 2023

I was thinking the same thing .. kudos for the screenshot :)

0 0

score 0 · Answer 12 · 2023-08-09T05:36:44-04:00

Thanks Alex! This works of course, but I need to do the same on a regular manner. So I'm looking for a way to perform the same procedure programmatically

score 0 · Answer 13 · 2023-08-15T08:31:01-04:00

I have a follow up question: in case I need to do it "by hand" - what is the way to create a CSP class(URL) that once I open it it will download me a global I want in XML format? If anyone has an example how to manage the thing?

score 1 · Answer 14 · 2023-08-15T11:11:15-04:00

Not a ready-to-use solution, but a way to take

export the global by SMP or embed %system.OBJ.Export to create *.XML file
download it using <a href="~file_location~" download> explanation

score 0 · Answer 15 · 2023-08-16T05:19:11-04:00

Evgeny Shvarov · Aug 16, 2023

Thanks! Will take a look!

0 0

score 0 · Answer 16 · 2023-08-17T06:35:23-04:00

Here is a working simple example to start with
https://community.intersystems.com/post/download-globals-xml-using-csp
with an OEX package