Home / Features / Feature list by edition
Caché Monitor is a development tool designed for InterSystems Caché. It combines tools with a SQL editor to provide easy access to the database for Caché developers and administrators. It is intended for software developers and analysts, supports primarily the management of Caché server connections and the execution of SQL queries, and organises connections to Caché servers in groups.
Software developers who are familiar with InterSystems technologies find their way easily through the use of InterSystems-specific terms. The interface concept is inspired by Microsoft SQL Server Management Studio, so users with a Microsoft background feel at home as well. Caché Monitor also connects to databases like Microsoft SQL Server, Microsoft Access, MySQL and much more for heterogeneous database environments.
The table shows the main features of Caché Monitor and their availability in the two editions.
| Feature | Professional | Home (free) |
|---|---|---|
| Server Navigator | ||
| Caché server connection limit | unlimited | 1 (localhost only) |
| Browse and manage Caché servers and connections to MS SQL Server, MySQL, Oracle and more | ✓ | ✓ |
| Import Caché connections (Caché Server Manager list) | ✓ | ✓ |
| Import Caché ODBC connections | ✓ | ✓ |
| Organise servers and folders with drag and drop | ✓ | ✓ |
| Organise Caché servers into groups | ✓ | ✓ |
| Multiple simultaneous open connections | ✓ | ✓ |
| Export directly to file | ✓ | ✓ |
| Browse Caché namespaces | ✓ | ✓ |
| View Caché CPF files | ✓ | ✓ |
| SQL Editor | ||
| Multiple SQL editors | ✓ | ✓ |
| Procedures producing multiple result sets | ✓ | ✓ |
| SQL formatter | ✓ | ✓ |
| View result sets as grid or text | ✓ | ✓ |
| Parameterised SQL queries | ✓ | ✓ |
| View BMP, TIFF, PNG, GIF and JPEG images | ✓ | ✓ |
| Code completion (IntelliSense) | ✓ | ✓ |
| BLOB, CLOB and binary data | ✓ | ✓ |
| Syntax-coloured 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 and max chars | ✓ | ✓ |
| Scripts Manager | ||
| Organise script libraries | ✓ | – |
| Fast live preview | ✓ | – |
| Data Inspector | ||
| View BMP, TIFF, PNG, GIF and JPEG images | ✓ | ✓ |
| View text, HTML, XML and binary content | ✓ | ✓ |
| Global Browser | ||
| Navigate through globals and nodes | ✓ | ✓ |
| Class Navigator | ||
| Export classes | ✓ | ✓ |
| Import classes (with compile) | ✓ | ✓ |
| Copy classes between servers and namespaces with dependencies | ✓ | ✓ |
| Database Diagrams | ||
| Visualise the database with database diagrams | ✓ | ✓ |
| Diagrams are stored in the associated database | ✓ | ✓ |
Current editions. SQL DATA LENS editions and their features are compared on the SQL DATA LENS comparison page; prices are on the pricing page.
Frequently asked questions
What were the limits of the free Home Edition?
One registered server, connections to localhost only, CSV as the only export format and no Scripts Manager. Everything else, including SQL editor, Global Browser, Class Navigator and database diagrams, was included.
Which export formats did the Professional Edition support?
CSV, HTML, XLS, XLSX, XML, SQL insert scripts, plain text and JSON, directly from the result grid or straight to file.
Continue with SQL DATA LENS
SQL DATA LENS is the current release of this tool: native InterSystems IRIS and Caché support, SQL editor, Global Browser, database diagrams, Query Cloud and much more. Free Edition and a full 30-day Pro trial with every download, no registration.