SQL DATA LENS
Subscribe
1
Bookmark
2
Subscribe
Bookmark
Details
Releases
Reviews
Screenshots
Provider
Articles
What's new in this version
– ENH : the licensing system has been completely changed, simpler trial mode
– ENH : New Driver 3.7.1 from InterSystems IRIS 2023.1 added
– ENH : Flat Look and Feel updated to 3.1.1 (https://github.com/JFormDesigner/FlatLaf) – Windows 11: rounded popup borders
– FIXED: Constraints are back again for db diagrams
– ENH : objectnames are only quoted if required
– ENH : the licensing system has been completely changed
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.
Tag version: 3.15.0
Released: 2023-09-18 16:05:06
– ENH : the licensing system has been completely changed, simpler trial mode
– ENH : New Driver 3.7.1 from InterSystems IRIS 2023.1 added
– ENH : Flat Look and Feel updated to 3.1.1 (https://github.com/JFormDesigner/FlatLaf) – Windows 11: rounded popup borders
– FIXED: Constraints are back again for db diagrams
– ENH : objectnames are only quoted if required
– ENH : the licensing system has been completely changed
Tag version: 3.13.0
Released: 2023-05-09 17:36:02
3.13 released on 2023-03-03
- ENH : SQL Editor : More new IRIS keywords are hightlighted, e.g. for new Windows Functions https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_windowfunctions
- ENH : SQL Editor : New code completion for “SET OPTION”
- ENH : SQL Editor : New Generic CodeCompletion provider for all other databases than IRIS\CACHE e.g. MS SQL SERVER
- ENH : TableViewer : Rebuild Index works now for IRIS. This is executed with %NOLOCK %NOJOURN
- ENH : TableViewer : Tune Table works now for IRIS.
- ENH : TableViewer : New Tune Table with %RECOMPILE_CQ: will recompile the cached query classes using the new Tune Table statistics.The new action
- ENH : New Driver 3.6.1 from InterSystems IRIS 2022.2 added
- FIXED: SQL Editor : Connection handling for the SQL Editor has been improved. Each SQL Editor uses only one “private” connection.
- Querying the namespace objects created a second public connection. This caused the editor to open more slowly. This is now fixed. The editor now only needs one database connection.
- A public connection is now only created when navigating in the server navigator. The server navigator uses its own connection, independent of any open editor.
- ENH : Windows setup works now with lowest privileges.
- FIXED: Scriptmanager : Scrollbars in Scriptmanager window fixed.
- FIXED: ServerNavigator : Connectionhandling is now faster
- ENH : Setup : Setup comes now with asigned uninstaller, so the “unknown publisher” message is gone by unstalling SQL DATA LENS
- Setup can now be executed in non administrative mode
- ENH : Flat Look and Feel updated to 3.0 (https://github.com/JFormDesigner/FlatLaf)
- ENH : Many internal libs upgraded
3.12 released on 2022-09-18
- ENH : SQL Editor : Min\Max\Avg\Sum values are calculated on selection in tablegrid
- ENH : SQL Editor : Sorting performance in grid improved
- ENH : From table results the new option “Copy pretty formatted” is available
- ENH : More visible connection details for IRIS, eg. using shared memory, server local, and more…
- FIXED: Open TOP 1000 rows of a table produce in some situations invalid sql statement
- ENH : TableViewer : Performance improvments for SQL Server connections
Tag version: 3.8.0
Released: 2022-05-30 10:34:04
- FIXED: Showing Stored Procedures if the option “Show Systemobjects” isn’t selected (=ignoring system objects)
- FIXED: Test Connection for none InterSystems databases fixed (JDBC)
- FIXED: QueryCloud: Downgrade to H2 databae version 1.x to fix some incompatibilities with the QueryCloud handling
- ENH : Some internal libs upgraded
- SQL DATA LENS contains now an updater for full automatic-updating with tiny update patches
- Upgrade to runtime 11.0.14.2
- Many internal libs upgraded
- Open MS Excel works now nativ again
- EXE Files are now signed!
- new ms sql driver dll: mssql-jdbc_auth-9.4.1.x64.dll
Tag version: 3.4
Released: 2021-12-31 01:11:57
- New jave runtime 11.0.14 with many bugfixes and performance improvemets integrated
- Default font changed to “JetBrains Mono” for better reading experience (https://www.jetbrains.com/lp/mono/#key-features)
- Many internal libs upgraded and database driver updated
- New buildin sql formatter
Tag version: 3.2
Released: 2021-12-28 21:54:59
Initial Release of SQL DATA LENS
Category
Works with
InterSystems IRISInterSystems IRIS for HealthHealthShareCachéEnsembleInterSystems IRIS BIInterSystems IRIS NLPTags
Info
Version
3.15.0Last updated
2023-09-18Documentation
OpenLicense
LinkProduct Editor
Difference preview
Difference preview
Download (Link to the page where a user can download an app)
Developer Environment
Difference preview
Difference preview
Tag1, Tag2, Tag3
sql
editor
query tool
Difference preview
Difference preview
Difference preview
Difference preview
Difference preview