Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Export from Intersystems Caché database

I have a product based on Intersystems Caché database, I can see no classes, no schemas, no tables, only globals. Is there any smart way to export data from these globals and get "human-readable structure"?

like image 593
Martin Avatar asked Oct 21 '25 03:10

Martin


1 Answers

First question is... what version of Caché? Second question is... what tools do you have access to? Terminal, Studio, Management Portal??

If the data is in tables/classes, you should be able to access it via ODBC, at least. If there aren't any tables/classes, the data is probably in Globals.

If the data is in Globals (persistent sparse array storage) they can look a bit wierd if you aren't used to the common patterns.

Even if it is in Globals, it may be possible to define classes with custom mapped storage to make them appear in a table-like way via SQL.

Cache is EXTREEMELY flexible, but can be a steep learning curve. :-(

like image 196
user613387 Avatar answered Oct 23 '25 16:10

user613387



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!