Cache Monitor

Caché Monitor is a free, multiplatform and featureful graphical software that has been designed for SQL development, allowing developers to administer components of InterSystems database Caché.

Features at a glance

Key features include an advanced SQL query editor, SQL code completion, cache-SQL syntax highlighting, SQL history buffer for executed SQL commands, graphical SQL execution plan, SQL code formatting, unlimited connections, the ability to import database connections, support for organizing servers into groups using drag and drop, tree structure for managing and browsing the server, and support for multiple simultaneous connections.

Additionally, Caché Monitor is capable of displaying namespaces, supports parameterized SQL scripts, supports multiple SQL editors, allows users to view CPF (Caché Parameter File) files, as well as image files in the JPEG, PNG, GIF, TIFF and BMP file formats, exports and imports classes, supports viewing of binary, plain text, HTML and XML files, and exports grid data to the SQL, Plain Text, HTML, JSON, CSV, XLS, XLSX and XML files.

Among other interesting features, we can mention that the application includes a table and global browser, a class navigator, a data inspector, fast live previewer, a SQL editor and formatter, a scripts manager, database diagrams, as well as a syntax colored SQL editor. It lets users to view the result sets as plain text or as grid, supports CLOB, BLOB and binary data, stores diagrams in the associated database, and exports directly to files.

Under the hood and supported OSes

Caché Monitor is written in the Java programming language, which means that it is a platform-independent application, compatible with any operating system where the Java Runtime Environment (JRE) is available, including GNU/Linux, Microsoft Windows and Mac OS X operating systems.

Distributedin multiple editions

The software is distributed as a free version with limited features, called Home Edition, as well as commercial versions that include all of the aforementioned functionality. While the Caché Monitor Professional edition costs 99 USD (77 EUR), the Caché Monitor Developer edition costs 49 USD (38 EUR).

What is new in this release:

• ENH : New Bulk Export Dialog allows to save current- and load previos selections of Tables
• ENH : Install license process improved; license is also now visible in about dialog
• ENH : Server Navigator: The server version number can be viewed in Server Navigator tree. This is toggled via Menu "Show version".
• ENH : TableViewer: New context popup menu entry: "SELECT first 1000 rows"
• ENH : TableViewer: New context popup menu entries: "Script Table as "SELECT", "INSERT", "CREATE"
• FIXED: "Sources" node works with Cache databases prior version 2013

What is new in version 2.51:

• ENH : Database Diagrams: More key constraints are be determined and visualized in diagram
• ENH : Database Diagrams: Exported keys are marked with special icon
• ENH : Table Browser - List imported\exported keys on new tab called "References"

What is new in version 2.50:

• ENH : New polished Interface design. For a clear and consistence user interface design many icons are changed and checked for a consistency use.
• Some menus renamed so e.g. the "New Query Analyzer" menu is renamed to "New Query" also with a new icon for this action.
• Also the application icon is changed from a server magnifying glass with to a blue cube.- ENH : New! Database Diagrams
• Database diagrams graphically show the structure of the database. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it.
• For any database, you can create as many database diagrams as you like; each database table can appear on any number of diagrams.
• Each database diagram you create is stored in the associated database.
• The first time you click on the Database Diagrams folder of a database, you ask to "Create required objects to manage diagrams in this namespace?".
• It is not an error, but just a permission seeking dialog to create a database table that is necessary to work with database diagrams.
• If you choose No then no table will be created and you will not be able to work with database diagrams.
• If you choose Yes then a table would be created in your database and you will be able to work with database diagrams.
• If you modify any table outside the diagram editor, the changes will automatically be updated in any saved diagrams.
• You can open database diagrams to view or edit the diagram's structure. To open a database diagram in Server Navigator, expand the Database Diagrams folder.
• Click the name of the database diagram you want to open.
• You can create an image of a Database Diagram and copy it to another application. To copy a diagram image to the Clipboard open a Database Diagram.
• Right-click a blank area and choose Copy Diagram to Clipboard.
• ENH : Query Analyzer : CTRL+ENTER for execute query in
• FIXED: Optimized table column width for data
• ENH : Class Navigator : Classes source code is now in xml
• ENH : Table Navigator : double click on a table in tree opens a new Table Editor for the selected table
• ENH : The "Routines" node is renamed to "Sources" because in the future all sourcecode with hin cache will be available from here.
• ENH : Faster scrolling in tables

What is new in version 2.0.7:

• ENH : Server Navigator: Driver download is cancelable via progress dialog
• ENH : Class Navigator : Selection of target folder for classes export is available
• ENH : Class Navigator : Class delete need to be confirmed by user
• ENH : Class Navigator : New function: Import classes (incl. auto compile)
• ENH : Class Navigator : New function: Copy classes (incl. auto compile) between server \ namespaces
• ENH : Class Navigator : New function: Compile class
• ENH : Table Navigator : Export Table works now also on a selected table node within Server Navigator. Before this the user have to select a export table on the detail panel.
• ENH : Tested with Java 1.7.0_45
• ENH : License Evaluation\Activation: Proxy Server can be configured
• ENH : New Feature: Log File Manager
• ENH : Script Navigator : Threading issue while file preview fixed

What is new in version 2.0.6:

• ENH : Drag&Drop for Server and Server-Groups moving within the server navigator
• ENH : Server Navigator with a toolbar to shows important actions
• ENH : A trial license for evaluation of Cache Monitor Professinal can now requested online via Manage-License Dialog.
• ENH : New Script Navigator for easy working and navigation with many (sql)scripts.
• ENH : Query Analyzer - shows file path from current file in status bar

What is new in version 2.0.4:

• The cache.cpf file can now be shown from a selected Cache Server.
• An Open File dialog with preview feature was added.
• The Query Analyzer and Table Browser now save and restore splitter position.
• In Query Analyzer, search/replace and goto line functions were added.
• CTRL-F, CTRL+H, and CTRL+L now open the expected dialogs.
• Cache Monitor now checks for available updates on start-up.

What is new in version 2.0.3:

• Cache Monitor now downloads the required InterSystems Cache database driver automatically from the Web if required at first run.
• No manual intervention is required. The password from a registered Server is now automatically encrypted.
• Code folding was added in the SQL editor.

What is new in version 2.0.2:

• You can now write SQL queries across namespaces.
• This release added "mapped tables" and "federated namespace", an "Auto register Cache Server" function that makes it straightforward to create a Server registration from local Cache installations, improvedhex view, a "Navigate to last selected object" feature, the ability to rename server groups, a way to change the table name for the "Copy table".
• The Class Browser no longer shows system classes.

What is new in version 2.00:

• This version includes drivers for Cache 2012.2, 2011.2, 2010.1, 2009.1, 2008.2, and 5.2.
• Grid results formatting is now based on the decimal digits definition from each database column.
• All results (ResultSets) from a StoredProcedure are now listed, e.g. calling Sample.PersonSets('A','NY') in SAMPLE Namespace now shows both ResultSets.

Requirements:

• Java 2 Standard Edition Runtime Environment