Home Products SQL DATA LENS
1 reviews
DB Tool with special features for IRIS & Caché

What's new in this version

3.17 released on 2024-05-30

  • ENH : New Driver 3.8.4 from InterSystems IRIS 2024.1 added
  • ENH : TableViewer : Some driver ignore the setMaxRows Paramter like DuckDB. So for some databases the row limitation is done by TOP x or LIMIT x
  • ENH : TableViewer : Column size in grid optimized
  • ENH : TableViewer : Count rows function recognizes keywords in object names that need to be quoted. So now less errors when counting on system tables.
  • ENH : Flat Look and Feel updated to 3.4.1 (https://github.com/JFormDesigner/FlatLaf) – more Windows 11 features
  • ENH : Many internal libs upgraded
  • FIXED: Notepad content was multiplied after close and reopen the notepad tab
  • ENH : DuckDB driver upgraded to 0.10.3
  • FIXED: SQL History : Threading issue fixed

3.16 released on 2023-10-08

  • ENH : TableViewer : “open in new tab” improved
  • ENH : Cached Queries : Delete selected cached query and delete all cached queries for selected tabel is now working for IRIS
  • ENH : SQL Editor : Copy table on server side works now for IRIS and use the CREATE TABLE AS SELECT… syntax
  • ENH : SQL Editor : IRIS improvment: Within SQL Editor the plain execution plan can be shown
  • ENH : SQL Editor : New connect button on toolbar to switch fast to another server \ database
  • ENH : Management\Databases : More details for IRIS and Caché are now displayed for database files
  • ENH : Management\Log files : Log File viewer now with mono font
  • ENH : Management\Log files : journal.log entries are now displayed for IRIS
  • ENH : Management\SQL Gateway : SQL Gateway entries can now be deleted
  • ENH : Management\SQL Gateway : Create a server-side IRIS SQL Gateway connection based on local connections configured in SQL DATA LENS
  • ENH : Removed Caché database drivers older than 2018.1. This is now the only database driver for Caché that is included.
  • ENH : Removed IRIS database drivers for IRIS 2019.1, IRIS 2020.1, 2021.1, 2022.1
  • The new default driver for InterSystems is IRIS 2023.1
  • ENH : Support and Driver for DuckDB added
  • FIXED: Cached Queries node shows the correct item count
  • FIXED: Globals node shows the correct item count
  • FIXED: SQL Editor : better query plan support for IRIS
  • FIXED: Profiling : added PStats support for IRIS

SQL Data Lens works particularly well with Intersystems Caché and Intersystems IRIS databases. The tool was created through continuous development over the years under the name Caché Monitor and has now only been renamed: Caché Monitor is now: SQL Data Lens!

The name Caché Monitor was chosen to reflect the close integration of the tool with the Caché database. In order to be less closely tied to a product name in the future, the new name has been chosen to be more neutral: SQL Data Lens
Regardless of the name, it is still the goal to implement the closest possible integration into the Intersystems products. The ongoing development is also reflected in the continuation of the release numbers: The last version is Caché Monitor 2.96, the latest version of SQL Data Lens is 3.x

SQL Data Lens specifically optimized for unique InterSystems IRIS & Caché features. It combines many tools with a smart sql editor to provide easy access to your databases. InterSystems developers, administrators and data analysts love it. It is fast and very easy to use.

The Server Navigator is a tree structure to browse and manage database objects. You can easily organize and group your Intersystems IRIS and Caché Servers. But you can also integrate connections to other databases, e.g. MS SQL Server, SQLite, H2, HSQLDB, MS Access or just simple CSV Files.

Easily navigate through your intersystems servers and other databases. All Namespaces are listed for easy navigation. No need to know the name of the Namespaces, no need to configure a multitude of JDBC connections:

Write and run queries in the advanced SQL editor that speeds up your coding and reduce errors with features such as auto-completion, syntax highlighting, Bracket Matching, Goto Line commands and many more.
SQL DATA LENS automatically detects the next sql statement, just press "Execute next query" or just place the cursor on any statement and press "Execute current query (F5)":

Browse and administer database objects such as tables, procedures, functions, triggers, etc.
On the Colums detail tab are information about primary-, foreign keys available for all columns in a table. The tooltip on a foreign key icon shows the referenced table.

Easy editing, easy filtering simplify the work with your data

With the feature called Local Query Cloud you can write SQL Statements across multiple Servers, Namespace and combine (SQL JOIN!) this data with other datasources like Microsoft SQL Server; Microsoft Access or simple CSV files. All this with zero installation on server side!
Use the Local-Query-Cloud to access data across server, namespaces and databases in ONE sql statement.

With the feature Session snapshot SQL DATA LENS allows a quick restart. Stopping SQL DATA LENS saves all SQL Editor tabs with content and connection infos. All this will be automatically restored on next start.

3.17.001 Jun, 2024
Developer Environment
Works with
InterSystems IRISInterSystems IRIS for HealthHealthShareCachéEnsembleInterSystems IRIS BI
First published
28 Dec, 2021