About Cach Monitor
Cach Monitor is the all-in-one tool designed for InterSystems Cach. But can also connect to databases like MS SQL Server, MS Access, MySQL and much more.
Cache Monitor is a development tool designed for InterSystems database Cache.
It supports developers with a advanced SQL Query Editor.In Cach Monitors Server Navigator you see all
available Namespaces on your Cach Servers. No need to know the name of the Namespace, no need to
configure many many JDBC connections.
But Cach Monitor can also connect to databases like MS SQL Server, MS Access, MySQL and much more to
fit your needs in a heterogeneous database environment.
Developers who are familiar with InterSystems technologies should easily find their way through
the use of InterSystems specific terms.
Cach Monitor can execute SQL Statements across mutiple Cach Servers; Namespace and other Datasources like SQL Server; MS Access and more without any installation on the Server side!
Server Navigator
The Server Navigator is the main tool and allows to browse and organize InterSystems Cach servers into
groups, It shows database objects and structures such as tables, views, classes, indexes, constraints,
procedures, functions, etc. The Server Navigator simplifies the process of managing multiple
InterSystems Cach Servers.
In Cach Monitors Server Navigator all Namespaces are listed for easy navigation. No need to know the
name of the Namespace, no need to configure a multitude of JDBC connections. If the first connection to
a Cach Server is requested, Cach Monitor downloads the InterSystems Cach database driver
automatically from the Web. No manual intervention is required.
(http://www.youtube.com/watch?v=TKg1jaCo65A)
Auto register Cach Server: With this feature you can very straightforward create a Server registration
from a local Cach installation. All data that Cach Monitor requires for working with Cach are
automatically imported; including Port, the right driver version all you have to do is entering the
password. (http://www.youtube.com/watch?v=ZCkIuNg3gxc)
Query Analyzer (SQL Editor)
The editor supports code completion (Intelli Sense), SQL Code folding and much more.
(http://www.youtube.com/watch?v=547p9YxYjcA)
Previous Versions
Here you can find the changelog of Cach Monitor since it was posted on our website on 2015-04-25 03:00:00.
The latest version is 2.96 and it was updated on 2024-04-22 10:02:50. See below the changes in each version.
Cach Monitor version 2.96
Updated At: 2020-07-04
Changes: Changes in V 2.96:
- ENH : Driver added for InterSystems IRIS 2020.1 (JDBC Version: 2020.1.0.215)
- ENH : QueryCloud supports InterSystems IRIS
- ENH : QueryCloud show source code of views
- ENH : TableViewer : JDBC connections show source code of views (e.g. SQL Server)
- ENH : Server Navigator: JDBC connections show source code of views (e.g. SQL Server)
- ENH : Native Intersystems IRIS support!
- ENH : No installed Java runtime required! Cach Monitor is now shipped with a private JRE (Java Runtime Environmet).
Cach Monitor version 2.95
Updated At: 2020-04-12
Changes: Changes in V 2.95:
- FIXED: GlobalViewer: minor fixes and improved in displaying unicode and $lb (listblock) elements
- FIXED: GlobalViewer: Refreshing globals view don't duplicate values
- ENH : Driver updated to CsvJdbc - CSV file JDBC driver (csvjdbc-1.0-36.jar) (http://csvjdbc.sourceforge.net/index.html)
- ENH : Driver updated to SQLlite 3.30.1 (sqlite-jdbc-3.30.1.jar) (https://bitbucket.org/xerial/sqlite-jdbc/downloads/9
- ENH : Driver updated to PostgreSQL 42.2.11 (postgresql-42.2.11.jar) (https://jdbc.postgresql.org/download.html)
- ENH : Driver updated to InterSystems IRIS JDBC (Version: 2019.1.1.612)
- ENH : Native Intersystems IRIS support!
- ENH : No installed Java runtime required! Cach Monitor is now shipped with a private JRE (Java Runtime Environmet).
Cach Monitor version 2.94
Updated At: 2020-01-04
Changes: Changes in V 2.94:
- ENH : Native Intersystems IRIS support!
- ENH : No installed Java runtime required! Cach Monitor is now shipped with a private JRE (Java Runtime Environmet).
Cach Monitor version 2.93
Updated At: 2019-08-13
Changes: Changes in V 2.93:
- ENH : Native Intersystems IRIS support added (specific features like GlobalViewer and many more, known from Cache)
------------------------------------------------------------------
- ENH : Show Stored Procedures for JDBC Connecions
- ENH : Some refactoring, like removing old startingstopping action for local Cach services
- ENH : Server Navigator: Cach CPF Files are available at the management node
- ENH : SQL Editor : For Cach IRIS the PID is in Statusbar
- FIXED: SQL Editor : holding the F5 key down (or press SHIFt+ENTER) starts the same statements multiple times, thats fixed now
- FIXED: ClassBrowser : many fixes
- ENH : Server Navigator: Cach IRIS Connectino property "Show system objects and namespace" is now splitted in two
options: "Show system objects" and "Show system namespaces"
- ENH : Driver updated to H2 Database Engine 1.4.199
- ENH : Driver updated to Microsoft JDBC Driver 7.2 for SQL Server (Version: 7.2.2.0)
- ENH : Driver updated to InterSystems IRIS JDBC (Version: 2018.2.0.999)
- ENH : Driver updated to MySQL 8.0.16
- ENH : Driver updated to SQLlite 3.27.2.1
- ENH : Removed driver for Cach version 2009.1, 2010.1, 2017.1 (2017.2 is still there! ;)
- ENH : Server Navigator: columns in tree show now detail information about datatypes, pks and nullable
- ENH : TableViewer : More details about global storage per table on the storage tab
- ENH : TableViewer : Some smaller ui improvments
- ENH : HiDPI font scaling factor reduced
- FIXED: Bugfix function "Import Cach IRIS Connections"
- FIXED: Bugfix function "Bulk export wizard"
- FIXED: general UI fixes: , e.g. Title handling in main frame
- FIXED: disconnect works also on subnodes from ServerConnections
- ENH : DateTime UI improvments, e.g. display format is configurable
- FIXED: Refresh on Stored Procedure View
Cach Monitor version 2.92
Updated At: 2019-01-27
Changes: Changes in V 2.92:
- ENH : Cach Server Properties: Option "Don't use %SYS namespace" renamed to "Don't query for Cach namespace list"
- FIXED: if the Cache Server Connection Property "Don't query for Cach namespace list" was selected, the namespace was not expandable
- FIXED: Query Editor some smaller bugfixes
- ENH : New DB Driver : Cach 2017.2
- ENH : New DB Driver : Cach 2018.1
Cach Monitor version 2.90
Updated At: 2018-12-09
Changes: Changes in V 2.90:
V 2.90:
- FIXED: MAX CHARS doesnt work in Query editor
- FIXED: TableViewer : Source tab (DDL) Editor fixed
- ENH : TableViewer : Source tab (DDL) performance improved
- ENH : DB Driver : IRIS Intersystems JDBc Driver added
Cach Monitor version 2.85
Updated At: 2017-07-31
Changes: Changes in V 2.85:
- ENH : Improved ServerConnection dialog
- FIXED: Open Query Editor for a Csv Connection (Menu: "File" -> "Create CSV Text connection")
- ENH : New config dialog for the "QueryCloud"
- ENH : Improved QueryCloud data view and management
- ENH : In QueryCloud loaded driver can viewed on the Connection dialog (Server Manager)
- ENH : "View Metadata" only works with connected objects, a message about that behavior is displayed if not connected
- FIXED: Server Navigator: Some databases doesn't list catalogsschemas.
For that type of connections Cach Monitor show "default" nodes in tree to allow to navigate.
- ENH : DB Driver : Update CsvJdbc driver to version 1.0.31
- ENH : Connection testing improved
- FIXED: TableViewer : Set filter by context menu works now with columns that have to be quoted (IdentifierQuoteString)
- FIXED: TableViewer : MaxRows is set to 1000 on first startup
- ENH : Max memory set up to 2Gb for the windows exe
- ENH : DB Driver : Cach 2017.1 driver updated to 2017.1.1.111
- ENH : Grid : Improved cell selection
Cach Monitor version 2.82
Updated At: 2017-01-15
Changes: V 2.82:
- FIXED: In the final release the wrong konfiguration folder was used.
".cm_beta" instead of ".cm". Please update to this version to get your configuration.
Many smaller fixes and new features in V 2.81:
- ENH : New search possibility in all grids with new searchbar
- ENH : Searching in sql history
- ENH : More details on the error dialog about db vendor code and state
- ENH : Improved connection handling, while connecting a progress bar shows the background process.
- FIXED: Grid : GridHeader (row number) are not always in sync with the rows from content.
It shows while scrolling in bigger result like > 100000 rows
- ENH : Grid : Create SQL for Grid results improved (copy as Insert, copy as update, e.g.)
- ENH : SQL Editor : New Combobox for selecting text scaling like 100%, 200% and so on
- ENH : SQL Editor : View the column's data type in the header tooltip of the result table
- ENH : SQL Editor : SQL statement is visible on result tab via tooltip
- ENH : SQL Editor : "Open in Excel" copy Grid data direct into MS Excel without export to fileimport to file
(Windows only)
- ENH : SQL Editor : A SQL statement can be saved direct to file via "Execute to file".
This feature works with limited memory because it is designed to directly write
the rows from the database to the export file without buffering in memory.
- FIXED: SQL Editor : connecting a disconnected sql editor update the titles now correctly
- FIXED: some minor fixes like memory leaks
- FIXED: SQL Editor : "Session snapshots" opens in some situations a connection to get namespace
metadata while the editor is still disconnected
- FIXED: SQL Scanner : In some situations SQL Scanner doesn't work
- ENH : TableViewer : The table size can be calculate via Task -> "Calculate size for all tables"
- ENH : TableViewer : UI improvments to see more columns details with one click,
like infos about Primarykey-Columns, ForeignKey-Columns and
special Cach specific details about Cach internal Datatypenames, selectivity and more
- ENH : Server Navigator: Selection concept changed to improve user experince and get more control at what time
information are fetched from server and detail data are shown.
Important: please consider that you have now select detail data via double clicking or
selection "open" via context menu.
Cach Monitor version 2.82
Updated At: 2017-01-15
Changes: Changes in V 2.83:
- ENH : DB Driver : InterSystems Cach 2016.1 driver removed
- ENH : DB Driver : InterSystems Cach 2016.2 driver added
- ENH : DB Driver : InterSystems Cach 2017.1 driver added
- ENH : New function for testing server connectin on ServerConnection dialog
Cach Monitor version 0.41
Updated At: 2008-12-03
Changes: V 0.41:
* Workaround for Nullpointer on apple maschine
* The default user and password is set for the default connection from Caché Monitor to Caché at localhost
* If execution plan parsing fails, the html version is displayed --> see forum message for more details
* For backward compatibility is this version compiled with Java 5
What that means? You can run Caché Monitor with Java 5 but also using Java 6. Please use the right (jdk5) driver!
* Better support for big sql script files
* Changed separator from "GO" to ";"
* New SQL Formatter and SQL Parser
* Runtime/Execution information is displayed on the message panel
* Some minor bug fixes
Disclaimer
External Download
We do not host Cach Monitor on our servers. We did not scan it for viruses, adware, spyware or other type of malware. This app is hosted by the software publisher and passed their terms and conditions to be listed there. We recommend caution when installing it.
The external download link for Cach Monitor is provided to you by apps112.com without any warranties, representations or guarantees of any kind, so access it at your own risk.
If you have questions regarding this particular app contact the publisher directly. For questions about the functionalities of apps112.com contact us.
