Navigation: 

SQL Data Lens 3.00 freeware

SQL Data Lens freeware screenshot
View Image

SQL Data Lens is the all-in-one tool designed for InterSystems ... It combines many tools with a smart sql editor to provide easy access to the database for Caché developers, administrators and data analysts. SQL Data Lens is like a swiss knife for Caché, fast and very easy to use. But SQL Data Lens can also connect to databases like MS SQL Server, MS Access, MySQL and ... more to fit your needs in a heterogeneous database environment. SQL Data Lens can execute SQL Statements ...

Author SQL Data Lens
Released 2021-08-29
Filesize 20.63 MB
Downloads 2084
OS Windows
Installation Install and Uninstall
Keywords sql, editor, database, intersystems, cache, query, tool, tuning, execution plan, ms sql server, oracle, mysql
Users' rating
(43 rating)
SQL Data LensOtherWindows
Add to saved freeware Report spyware
SQL Data Lens - data editor 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.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
2.95 Apr 12, 2020 Minor bugfix Changes in V 2.95:

- FIXED: GlobalViewer: minor fixes and improved in displaying unicode and $lb (listblock) elements
- FIXED: GlobalViewer: Refreshing globals view don't duplicate values
- ENH : Driver updated to CsvJdbc - CSV file JDBC driver (csvjdbc-1.0-36.jar) (http://csvjdbc.sourceforge.net/index.html)
- ENH : Driver updated to SQLlite 3.30.1 (sqlite-jdbc-3.30.1.jar) (https://bitbucket.org/xerial/sqlite-jdbc/downloads/9
- ENH : Driver updated to PostgreSQL 42.2.11 (postgresql-42.2.11.jar) (https://jdbc.postgresql.org/download.html)
- ENH : Driver updated to InterSystems IRIS JDBC (Version: 2019.1.1.612)

- ENH : Native Intersystems IRIS support!
- ENH : No installed Java runtime required! Caché Monitor is now shipped with a private JRE (Java Runtime Environmet).
2.94 Jan 4, 2020 Minor bugfix Changes in V 2.94:

- ENH : Native Intersystems IRIS support!
- ENH : No installed Java runtime required! Caché Monitor is now shipped with a private JRE (Java Runtime Environmet).

Most popular Other freeware downloads

ExamDiff

1.9.4.2 freeware download

... This visual clarity is particularly beneficial for developers, editors, and anyone who frequently deals with large volumes ... comparison, allowing users to delve into more complex data analysis. One of the standout features of ...

Android SDK

8.12 freeware download

... Studio is packed with features like a code editor with intelligent code completion, a visual layout editor, and a flexible build system. These tools work ... well as software services such as location-based services, data storage, and multimedia playback. The extensive documentation and ...

New Version

Freeware XMLFox XML Editor

8.3.3 freeware download

... editing and validation tool XMLFox is a freeware editor for creating valid well-formed XML documents and/or XSD ... editing and validation tool XMLFox is a freeware editor for creating valid well-formed XML documents and/or XSD ...

dbfHeaderEdit

1.5 freeware download

... of DBF files dbfHeaderEdit can modify the following data in DBF-header: - table type; - last modification ... - CDX and Memo flags; - link to database file; and display names and types of table ...

iBored

1.1.20 freeware download

iBored is basically a hex editor for disk sectors, but can also be used ... unsafe manner: You can easily write over any data on a disk, rendering the entire disk unusable. ...

Freeware XML Editor

8.8.3 freeware download

Freeware XMLFox XML Editor now comes in four editions. XMLFox is free ... editing and validation tool XMLFox is a freeware editor for creating valid well-formed XML documents and/or XSD ...

FSNotes for Mac OS X

4.3.3 freeware download

... respects open formats: plain/text, markdown, rtf, and stores data in file system. You can view, edit, copy data in favourite external editor and see live results ...

bed

3.0.0 freeware download

Adjustable data format binary editor. Data formats are ASCII, unsigned (base 2-36: bin,oct,dec,hex,etc) and ... time_t. Different sizes and byte orderings are possible. Data types can be used in structures. Other data ...

Hexplorer

2.6 freeware download

Hexplorer is a hexadecimal file editor that will offer many features: * 6 ... etc. * Ability to find repeating patterns in data, includes Fourier transform algorithm * Pixel viewer to ...

SQL Data Lens

3.00 freeware download

SQL Data Lens is a development tool designed for InterSystems database Cache. It supports developers with a advanced SQL Query Editor.In SQL Data Lenss Server Navigator you see all ...