For me it took a few days to solve a bit different issue, but only with InterSystems, that had to fix something on their site. I’d recommend contacting them through iservice, probably they can help 

with IKO, tls for wegateway does not work at all, only loginSecret works

I expected that just define webgateway even without tls, will work, but still no

So, you still store JSON as a text, and not some binary form, then all SQL queries will do JSON parse If I need to extract some property from it, and if I have millions of records, I have to forget about this feature?

The best and most correct solution would be to use parameters in SQL and pass a value as a parameter

INSERT INTO MyText
    (text)
VALUES
    (?)

While you have Oracle somewhere behind, Oracle should support parameters as well, but I don't know how it will work in this case

The increase may appear due to passing this query to the next database, and it escaped again. Passing as parameters may solve this issue.

But still even without this apostrophe the string is too long

He could find one of the demos, where port 51773 was for a while as a replacement of 1972 when IRIS was very fresh

Could you point to the demo, you trying to run?

About quoted properties, from my experience, the only scenario where those properties can be used is with JSON, but it's not necessary there anyway and can be declared differently.

What do you mean, what version?

Need to see the list of SQL Tables, use this query

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE';

You can try using DBeaver, connect to Caché, and see if there are any tables you interested

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

What do you mean by parsing logs, what do you expect to extract from it?

Deprecation of this feature, quite a big deal, actually.

One of the use cases, I would think is mostly used here, is to shorten package names in SQL. So instead of using a multi-level package long name, use shortened form, which is quite handy.

That's quite a strange task, what exactly do you need to achieve?

I have no idea what the format is there.

Yeah, I do answer sometimes, did not expect, that's so much, and I did not expect that I was tagged so much too

The issue is, that those settings are not presented in UDL formats. Without supporting it as files, and being able to use source control with this, it won't be easy to use.