Caché Monitor 2.80
Caché Monitor SQL Tool For Intersystems Caché
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 database 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!
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?
What is new in official Caché Monitor 2.80 software version? - New feature "Session snapshot" allows to make a quick restart. After stop and start again Caché Monitor all SQL Editor tabs with content and connection infos are restored. When the user quits Caché Monitor, unsaved files and open SQL Editor's from last session will be automatically restored on next launch. The user won't be asked to save unsaved files as he quits Caché Monitor. V 2.80: - FIXED: various : MaxRows limiter can be removed - FIXED: Preferences : Not all preferences was saved in cm_prefs.dat - FIXED: Login : On long running login process two wating dialogs coming up - ENH : New dashboard start page - ENH : Source Browser : Icons for different source types Navigation improved, drill down via double click on folder (not finished yet!) - ENH : StoredProcedures: Stored-Procedures-System objects are no longer displayed if the option "show System objects" is deselected on Server defintion - ENH : TableViewer : View the table row count in top grid. Renamed and refactored context menu, some functions grouped within menu "Tasks": - New function to get the current row count for ALL tables with one click - Execute tunetable for selected tabel(s) - Execute tunetable for current namespace Syntax highlighting for View Source and Table ddl Messaging of current running processes improved e.g. current loaded rows Execute "Script as -> Create" on a view creates now the "CREATE VIEW" with the source of the view Error on getting a value, doesn't stop retrieving the entire result. Just the error value is set to NULL - ENH : More metadata details are localy cached and reused e.g. on Codecompletion for perf reasons - ENH : Localy cached metadata are now saved as zip file to improve performance - ENH : DataInspector : Syntax highlighting for JSON content. Some smaller improvments in viewing content in DataInspector - ENH : SQL Editor : new function - escape date dialog - ENH : SQL Editor : For running queries less cpu cyles are used to update the UI - ENH : SQL Editor : Multi result view improved. Between each table a splitter is available - ENH : SQL Editor : Format SQL respect a text selection and format only this string - ENH : SQL Editor : new parameter "ui.maxoptwidth" to set the max width in pixel for optimizing table column max width based on data - ENH : SQL Editor : Code completion has now the option to select all columns from a table - ENH : SQL Editor : Script table as CREATE, INSERT, SELECT direct from (selected) editor text - FIXED: SQL Editor : In some situations closing a tab haven't ask for saving - FIXED: SQL Editor : In some situations wrong row count is displayed in status bar - ENH : SQL Editor : New feature "Session snapshot" allows to make a quick restart. After stop and start again Caché Monitor all SQL Editor tabs with content and connection infos are restored. When the user quits Caché Monitor, unsaved files and open SQL Editor's from last session will be automatically restored on next launch. The user won't be asked to save unsaved files as he quits Caché Monitor. This can be disabled by setting "ui.remember_session=false" in config.properties - FIXED: Server Navigator: Emtpy schemas are removed if setting metadata.removeEmptySchemas=true. What is expected in the future? Newly-made Caché Monitor 2.81 be downloaded from current page, we also looking forward to unconfirmed 2.82 release build. You may download CacheMonitor_034.zip directly, estimated download time by ADSL2+ [~24.5 Mbit/s] is 0:00:07. Just write the reviews of the Caché Monitor. System requirements are Java Runtime Environment 8 (JRE 8.0) or higher. Program has been scanned and verified by the several antivirus and anti-spyware applications and Caché Monitor found to be clean. No guide or Caché Monitor tutorial available. The following languages are supported by Caché Monitor: English.