There were multiple ways to build applications back then

  • Using globals to store data, no this way can be called NoSQL, this case will require additional work on the server side
  • and using persistent classes, which can be accessed via SQL

So, depends on how old this application is, and it has not updated for a long time

If you already know for certain, that the data you need can be accessed through SQL, then it's possible to make Flink working

There are no such tools at the moment, or anything similar to Oracle GoldenGate.

I suppose you meant Apache Flink, https://github.com/ververica/flink-cdc-connectors

Yeah, there is no support for Caché/IRIS. But it can be implemented, I already have experience with it

But, such an old system may not have adoption to SQL, and would require some additional work on the Caché side.

You may try using JDBC connection, to check if the data available through SQL. Then it could worth to implement flink CDC connector for Caché/IRIS.

Just in case you can use other options, I've already adapted Trino and Presto

Also possible to use Enterprise license

import os
from testcontainers.iris import IRISContainer

license_key = os.path.abspath(os.path.expanduser("~/iris.key"))
image = 'containers.intersystems.com/intersystems/iris:2023.3'
container = IRISContainer(image, username="demo", password="demo", namespace="demo", license_key=license_key)
container.with_exposed_ports(1972, 52773)
container.start()
print('SQLAlchemy URL', container.get_connection_url())
print('Username', container.username)
print('Password', container.password)

You already found port 52773

IRIS does not have http://localhost:52773/RPCNAME

Where did you get it RPCNAME? How did you configure it in IRIS? What else would you expect it to answer?

I tried to find anything about VistA RPC Broker, and found only an installation guide from 1997, It's a year when Caché was released. 

So, you are asking about VistA RPC Broker on IRIS, I don't know how it's possible 

And why it's an issue with IRIS, not with VistA RPC Broker