Feature overview

The table shows the main features of Caché Monitor and the availability in the different editions:

 ProfessionalDeveloperHome
Server Navigator
Caché Server connection limitunlimited31 (localhost)
Browse and manage Caché Server and connections MS SQL Server, MySQL, Oracle and more
Import Caché Connections
Import Caché ODBC Connections
Organize server and folders with drag&drop
Organize Caché servers into groups
Supports multiple simultaneous open connections
Export directly to file
Browse Caché namespaces
View Caché cpf files
SQL Editor
Support for multiple SQL editors
Support for procedures producing multiple result sets
SQL formatter
View result sets as grid or text
Parameterized SQL queries
View BMP, TIFF, PNG, GIF and JPEG images
Code Completion (intellisense)
Support for BLOB, CLOB and binary data
Syntax colored SQL editor
Execute Script with multiple SQL statements
Execute single SQL statement at cursor position
Execute selected SQL statement(s)
Export grid dataCSV, HTML, XLS, XLSX, XML, SQL, TEXT, JSONCSV, HTML, XLS, XLSX, XML, SQL, TEXT, JSONCSV
Table Browser
limit data by max rows\max chars
Scripts Manager
organize script libs
fast live preview
Data Inspector
View BMP, TIFF, PNG, GIF and JPEG images
View text, html, XML and Binary
Global Browser
navigate through globals and nodes
Class Navigator
Export classes
Import classes (with compile)
Copy classes between server\namespace with dependencies
Database Diagrams
Visualize the database with Database diagrams
the diagrams are stored in the associated database

 

copy_classes_between_servers

Caché Monitor is a development tool designed for InterSystems Caché.It combines tools with a sql editor to provide easy access for Caché developers and administrators to the database. The Caché Monitor is intended for software developers and analysts. The tool supports primarily the management of Caché Server connections and the execution of SQL queries. Connections to Caché servers can be organized in groups.

Software developers who are familiar with InterSystems technologies should easily find their way through the use of InterSystems specific terms. The interface concept is inspired by the Microsoft SQL Server Management Studio, so users with a Microsoft background should be also feel at home.

And 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.