Page Inspect

SQL Data Lens - a powerful tool for InterSystems IRIS and Caché

Skip to content

Menu

- Features
- Navigator
- Management
- Table Viewer
- SQL query editor
- Local query cloud
- Database diagrams
- Class Viewer
- Global Viewer
- Script Manager
- Data Inspector
- Optimised for InterSystems IRIS
- Build-in support for DuckDB
- Download
- Pricing
- Buy
- What’s new
- Support
- Users Guide
- SQL DATA LENS license activation details and how to
- Purchasing FAQ
- SQL DATA LENS – Installer \\ Setup exit codes
- Installation

## easy to use|powerful|fast|optimized|secure

SQL Data Lens – for InterSystems developers, administrators and data analysts

Buy Free Download

##### A powerful and easy to use database tool
## Native Interoperability

SQL Data Lens is optimised for the unique features of InterSystems IRIS & InterSystems Caché databases. It combines useful features with an intelligent 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.

#### Manage Connections

The Server Navigator allows you to browse connections to the InterSystems Caché & InterSystems IRIS databases, as well as many other databases. Organise all these connections into groups and sub-groups in any way that suits your business needs.

#### SQL Editor

The built-in SQL Query tool is a sophisticated editor with many powerful editing features for editing and writing complex SQL queries: see table columns, primary and foreign keys as you type. Write complex scripts using variables for dynamic execution in different database contexts

#### Cross database queries

With the Local Query Cloud feature, you can write SQL statements across multiple servers, namespaces and combine (SQL JOIN!) this data with other data sources such as Microsoft SQL Server; Microsoft Access or simple CSV files. All this with zero installation on the server side!

#### Share database diagrams

Visualise your database with database diagrams. Database diagrams graphically represent the structure of the database. To visualise a database, you can create one or more diagrams that illustrate some or all of the tables, columns, keys, and relationships in the database.

##### Native Interoperability
## Unparalleled Performance

Unlock the Full Potential of Your InterSystems Caché and InterSystems IRIS Data with SQL Data Lens!

Are you searching for the ultimate data exploration tool specifically designed for InterSystems Caché and InterSystems IRIS? Look no further – SQL Data Lens is here to revolutionize the way you interact with your data!

Built from the ground up with a laser focus on optimizing performance for InterSystems Caché and InterSystems IRIS databases, SQL Data Lens takes your data analysis to unprecedented heights. Say goodbye to generic tools that struggle to handle your complex data structures – and say hello to seamless, lightning-fast data exploration!

#### Easy to Use

Intersystems IRIS and Caché database drivers are already included in many different versions. Just connect to YOUR database… for YOUR version!

#### Blazing fast

Use as many connections simultaneously as you need to get the job done as quickly as possible. Open multiple editors on different databases and/or namespaces

#### Namespace navigation

The Server Navigator displays all namespaces for easy navigation. No need to know the namespace name, no need to configure a multitude of JDBC connections.

#### Are you ready?

Are you ready to unleash the true power of your InterSystems databases? Experience the game-changing capabilities of SQL Data Lens with a risk-free trial. Don’t miss out on this golden opportunity to supercharge your data insights and gain a competitive edge. Join the exclusive league of InterSystems Caché and InterSystems IRIS experts today!

## Download and test for free! No credit card required!

Start Now for free

- Privacy Policy
- Impressum \\ legal disclosure

- Privacy Policy
- Impressum \\ legal disclosure

## SQL DATA LENS

- Features
- Purchasing FAQ
- Purchase
- Download
- Installer \\ Setup exit codes

Copyright © 2025 a powerful tool for InterSystems IRIS and Caché