Caché Monitor became SQL DATA LENS
Dear Caché Monitor users: InterSystems Caché became InterSystems IRIS, so the tool needed a change too. Caché Monitor became SQL DATA LENS. Current and upcoming versions of the tool are published on sqldatalens.com.
Caché Monitor was the all-in-one SQL and administration tool for InterSystems Caché: a Server Navigator that lists every namespace of a server, a SQL editor with code completion and execution plans, Global Browser, Class Navigator, database diagrams and the Query Cloud for SQL across servers and databases. Native InterSystems IRIS support arrived with version 2.93 in 2019, and the last release under the old name was 2.96 in April 2020. In 2021 the tool was renamed, and the same product line has continued as SQL DATA LENS ever since, with every feature Caché Monitor users know.
Existing licences carry over. Enterprise Subscription customers and holders of a Single User Professional licence bought on or after 1 January 2019 use SQL DATA LENS at no additional charge; the existing key keeps working. Older licences do not carry over, but the permanently free Free Edition needs no key at all. See the licensing and upgrade page and the official notes for Caché Monitor users.
Download
The current version for Windows as installer or portable ZIP, Java runtime included, no registration. Caché Monitor packages are no longer hosted.
Features
Server Navigator, SQL editor, namespaces, Global Browser, Class Navigator, database diagrams, Query Cloud. Each mapped to its current documentation.
Documentation archive
Installation, first steps, requirements, ODBC-to-JDBC mapping, FAQ, how-to videos and the complete release notes up to version 2.96 (2020).
Support
Support for Caché Monitor and SQL DATA LENS users is provided by the SQL DATA LENS team.
What Caché Monitor users get in SQL DATA LENS
Caché and IRIS servers
Manage InterSystems Caché and IRIS servers in the Navigator. Browse namespaces without knowing their names or configuring a JDBC URL per namespace. Navigator, working with namespaces.
SQL editor
Syntax colouring, code completion with table, column and key information while typing, scripts with variables, execution plans, SQL history and formatter. SQL editor, SQL performance.
Globals and classes
Navigate globals and nodes with the Global Browser, inspect and copy classes with the Class Viewer. Global Browser, Class Viewer.
Diagrams and cross-database SQL
Visualise and share database diagrams, and join data across Caché servers, namespaces, SQL Server or CSV files in one statement with Query Cloud. Database diagrams, Query Cloud.
Why the tool was easy to adopt
Users who know InterSystems technologies felt at home right away because the tool uses InterSystems terms: servers, namespaces, globals, classes, routines. The interface concept was inspired by Microsoft SQL Server Management Studio, so users with a SQL Server background found their way around just as quickly. The Caché and IRIS JDBC drivers are included, so connecting is a matter of host, port and credentials. Caché Monitor ran on Windows, macOS and Linux, and let you open as many connections and editors to different servers and namespaces as you need at the same time. SQL DATA LENS keeps this multi-connection design; it is currently available for Windows, with a macOS build on the roadmap.
Preserved Caché Monitor documentation
These pages are kept online as they were published, so that bookmarks, forum links and search results keep working.
- Installation instructions
Unpack the ZIP, start the JAR or EXE, register a server, where settings are stored.
- First steps
Register servers, build server groups and run SQL with the Query Analyzer.
- System requirements
Java, disk space, memory and minimum Caché server version.
- ODBC settings to JDBC connection
Map host, port, user, password and namespace from the Caché ODBC dialog to Caché Monitor.
- FAQ: Caché Monitor with InterSystems Caché
Namespace errors, startup problems, communication link failure, %SYS rights, licence transfer.
- How-to videos
Eight short screencasts: register servers, editor, script manager, cross-database SQL, CSV.
- Feature list by edition
The complete Professional versus Home edition feature table.
- SQL development for InterSystems Caché
The original product overview: Server Navigator, namespaces, driver download, SQL editor.
- Release notes
Every Caché Monitor release from 0.11 to 2.96 (2020).
- Beta releases
The 2.93 prerelease that introduced native InterSystems IRIS support.
- Licensing and upgrade
Historic licence types and how Caché Monitor licences carry over to SQL DATA LENS.
Frequently asked questions
What happened to Caché Monitor?
Caché Monitor was renamed to SQL DATA LENS. InterSystems Caché became InterSystems IRIS, and the tool followed with a new name, native IRIS support and a broader database focus. It is the same product line under a new name; the rename took effect in 2021.
Is Caché Monitor discontinued?
The name is retired, the product is not. The last release under the old name was Caché Monitor 2.96 in April 2020. All later releases are published as SQL DATA LENS.
Can I keep using my Caché Monitor licence?
Enterprise Subscription customers and holders of a Single User Professional licence bought on or after 1 January 2019 can use SQL DATA LENS at no extra charge; the existing key keeps working. Older licences do not carry over. For them there is the permanently free Free Edition, which needs no key, and the current editions on the SQL DATA LENS pricing page. Details are on the licensing page.
Where do I download the current version?
From the SQL DATA LENS download page. Caché Monitor binaries are no longer hosted on this site.
Does SQL DATA LENS support InterSystems IRIS and Caché?
Yes. Native InterSystems IRIS support arrived with Caché Monitor 2.93 in 2019 and is a core feature of SQL DATA LENS. Caché connections keep working, and the tool also connects to Microsoft SQL Server, PostgreSQL, MySQL, SQLite, CSV files and more.
Is the old documentation still available?
Yes. Installation instructions, first steps, requirements, the ODBC-to-JDBC mapping, the FAQ, the how-to videos and the complete release notes are preserved on this site and linked from the documentation page.
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.