SQL Data Lens 3.22 freeware

New Version

SQL Data Lens is the all-in-one tool designed for InterSystems IRIS. It combines many tools with a smart sql editor to provide easy access to the database for IRIS developers, administrators and data analysts. Try it and use it for free! ...

Author SQL Data Lens
Released 2025-04-23
Filesize 20.63 MB
Downloads 2124
OS Windows
Installation Install and Uninstall
Keywords sql, editor, database, intersystems, iris, query, tool, tuning, execution plan, ms sql server, PostgreSQL, MySQL, Access, Firebird
Users' rating
(53 rating)
SQL Data LensOtherWindows
SQL Data Lens - statements Freeware Download Notice

SQL Data Lens Free Download - we do not host any SQL Data Lens torrent files or links of SQL Data Lens on rapidshare.com, depositfiles.com, megaupload.com etc. All SQL Data Lens download links are direct SQL Data Lens download from publisher site or their selected mirrors.

SQL Data Lens freeware - The Latest User Reviews
SQL Data Lens freeware - The Latest Versions History
3.22 Apr 23, 2025 Major release V 3.22 (23.04.2025)
- ENH : SQL Editor : More SQL scripting features added like "SELECT with numeric check" and "SELECT with length check"

V 3.21 (21.04.2025)
- ENH : Some small improvements, like Execute Toolbar button now with text
- ENH : Testing connections are now limited to show only 5 namespaces to prevent the UI from getting to big
- ENH : Many internal libs upgraded (like POI 5.3.1)
- ENH : TableViewer : Table sources (DDL) is improved and handle IRIS default entries for AUTO_INCREMENT columns corretly
- ENH : Data Pumper : New feature to copy data from one table to another table, also between different databases and namespaces
- ENH : SQL Editor : Improved error handling for values that do not match metadata
- ENH : General : A new toggle button on the main toolbar to configure handling for readerrors globaly

V 3.20 (23.02.2025)
- ENH : New Driver 3.10.2 from InterSystems IRIS 2024.x added
- ENH : New Driver 3.9.0 from InterSystems IRIS 2024.2 added

- ENH : Many internal libs upgraded
- ENH : SQL Formatter upgraded
- ENH : MariaDB driver upgraded to mariadb-java-client-3.4.1.jar
- ENH : H2 driver upgraded to h2-2.3.232.jar
- ENH : PostgreSQL driver upgraded to postgresql-42.7.4.jar
- ENH : Access driver upgraded to ucanaccess-5.0.1
- ENH : Firebird driver upgraded to jaybird-5.0.5.java11
- ENH : SqlLite driver upgraded to sqlite-jdbc-3.46.1.0_win64
- ENH : Trino driver upgraded to trino-jdbc-468
- ENH : MS SQL Server driver upgraded to mssql-jdbc-12.8.1
- ENH : DuckDb upgraded to 1.1.3
- ENH : New info dialog with copy action about runtime environment
- ENH : Drag and drop the csvparquetjson fil
3.20 Feb 23, 2025 Major release V 3.20 (23.02.2025)
- ENH : New Driver 3.10.2 from InterSystems IRIS 2024.x added
- ENH : New Driver 3.9.0 from InterSystems IRIS 2024.2 added

- ENH : Many internal libs upgraded
- ENH : SQL Formatter upgraded
- ENH : MariaDB driver upgraded to mariadb-java-client-3.4.1.jar
- ENH : H2 driver upgraded to h2-2.3.232.jar
- ENH : PostgreSQL driver upgraded to postgresql-42.7.4.jar
- ENH : Access driver upgraded to ucanaccess-5.0.1
- ENH : Firebird driver upgraded to jaybird-5.0.5.java11
- ENH : SqlLite driver upgraded to sqlite-jdbc-3.46.1.0_win64
- ENH : Trino driver upgraded to trino-jdbc-468
- ENH : MS SQL Server driver upgraded to mssql-jdbc-12.8.1
- ENH : DuckDb upgraded to 1.1.3
- ENH : New info dialog with copy action about runtime environment
- ENH : Drag and drop the csvparquetjson files to DuckDB generate now DESCRIBE and SUMMARIZE statements for faster file analyzing
- ENH : Runtime environment upgraded from 11.0.14 to = 21.0.3
Summary of Key Performance-Related Improvements in Java Runtime 21
Near-zero pause times, improved scalability, Lightweight concurrency with low memory footprint, SIMD parallelism for data-heavy tasks,
Efficient native function calls and memory handling, Faster execution, reduced warm-up times, Lower memory usage for string-heavy applications
Faster startup and reduced memory usage
In sum, Java 21’s performance improvements primarily focus on lowering GC pause times, enhancing thread scalability, and optimizing CPU and memory efficiency,
all of which lead to faster, more resource-efficient applications across a broad range of workloads.
- ENH : StoredProcedures: Generation of CALL scripts improved
- ENH : SQL Editor
3.00 Aug 29, 2021 Major release V 3.01 (07.11.2021):
- ENH : ServerNavigator : Copy connections details for JDBC included; Send connections details for JDBC included
- ENH : ServerNavigator : JDBC Connections dialog shows example URLs

- ENH : Driver updated to MS SQL Server 9.4.0 (mssql-jdbc-9.4.0.jre11)
- ENH : MS SQL Server: Windows authentication fixed

V 3.00 (17.10.2021):
- Rename: Caché Monitor is now -> SQL Data Lens :-)

- ENH : TableViewer : Shows more details for IRIS DB Server
- ENH : ServerNavigator : Improved connection testing
- ENH : ServerNavigator : Stored Procedures are loaded async
- FIXED: ServerNavigator : Expanding node while already connecting doesn't start more tries to connect

- ENH : SPViewer : For Stored Procedures SQL Data Lens create CALL scripts based on the Metadata.
But SQL Data Lens can also
- create a SELECT script for calling a Stored Procedure by using %ODBCIN for each result column
- create a SELECT script for calling a Stored Procedure by using %INTERNAL for each result column
- create a SELECT script for calling a Stored Procedure by using CAST( col as VARCHAR(255)) for each result column
This functions can helb to find and identifiy data type problems within your Stored Procedure

- ENH : SQL Editor : Restoring scrollbar position after reload
- ENH : SQL Editor : Column completion fixed
- ENH : SQL Editor : Hyperlink navigation from connectionname in Statusbar to Server Navigator
- ENH : SQL Editor : Refresh grid result is now executed while fetching data
- ENH : SQL Editor : Auto Save session state fixed, ordering is restored
- ENH : SQL Editor : Improved Syntax highlighting
- ENH : SQL Editor : Improved SQL formatter

- ENH : Better positioning of dialogs main window
- ENH : New Look and Feel Flat Light and Flat Dark integrated from https://github.com/JFormDesigner/FlatLaf
- ENH : Improvements for supported dark mode
- ENH : Intercell spacing for all table components removed
- ENH : SQL DataLens ist shipped with a minimized private JRE (based on JetBrains JDK 11)
- ENH : HiDPI support improved. The menu item is removed. The system scale factor is configured on the OS level.
Now the per-monitor DPI is supported. Configured as scale factor in Display Settings system dialog
(https://blogs.windows.com/windowsdeveloper/2016/10/24/high-dpi-scaling-improvements-for-desktop-applications-and-mixed-mode-dpi-scaling-in-the-windows-10-anniversary-update/#Q70zmTwpp7rCw8gC.97)

- ENH : Driver updated to MS SQL Server 9.2.1 (mssql-jdbc-9.2.1.jre11)
- ENH : Driver updated to PostgreSQL 42.2.19 (postgresql-42.2.19.jar) (https://jdbc.postgresql.org/download.html)
- ENH : Driver updated to H2 Database Engine 1.4.200 (h2-1.4.200.jar)
- ENH : Driver updated CsvJdbc - added support to DBF Files
- ENH : Driver added for InterSystems IRIS 2021.1 (JDBC Version: 2021.1.0.215)

- ENH : "Open in Excel" feature improved
- ENH : Export improved: "Save query result to File" ignore read error. So the process doesn't stop and continue on next value

Most popular Other freeware downloads

SQL Data Lens

3.22 freeware download

... specific terms. SQL Data Lens can execute SQL Statements across mutiple IRIS Servers; Namespace and other Datasources like SQL Server; MS Access and more without ...

New Version

DTM ODBC SQL runner

2011 freeware download

... is a free command line tool for SQL statements execution. The runner allows the user to specify ODBC data source name and file with SQL ...

EulerSharp

10.16.15 freeware download

... users. These features include support for recursion, conditional statements, and loops, which can be useful for more complex programming tasks. Overall, EulerSharp is a ...

PMD

7.2.0 freeware download

... FEATURES: · Possible bugs - empty try/catch/finally/switch statements · Dead code - unused local variables, parameters ... String/StringBuffer usage · Overcomplicated expressions - unnecessary if statements, for loops that could be while loops · ...

SQLi

8 freeware download

... to attack data-driven applications, in which nefarious SQL statements are inserted into an entry field for execution ... for string literal escape characters embedded in SQL statements or user input is not strongly typed and ...

Uncrustify

0.71.0 freeware download

... inter-character spacing Add or remove parens on return statements Add or remove braces on single-statement if/do/while/for statements Supports embedded SQL 'EXEC SQL' stuff Highly configurable

ModCom

15.30.0 freeware download

Free Windows software for Data Acquisition & Control, HMI / SCADA, Industrial Automation, Home Automation, Process Control, Test & Measurement, Data Logging, etc. ModCom is a ...

LiveCode

9.6.10 freeware download

... of unnecessary jargon: up to 90% fewer symbols, statements and expressions needed to get the job done, when compared with popular alternatives such as JavaScript ...