The table shows the main features of Caché Monitor and the availability in the different editions:
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.
Professional | Home | |
---|---|---|
Server Navigator | ||
Caché Server connection limit | unlimited | 1 (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 data | CSV, HTML, XLS, XLSX, XML, SQL, TEXT, JSON | CSV |
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 |