Articles

Every field of the IRIS and Caché connection dialogue explained, including the options that decide which namespaces and system objects appear in the tree.

The Server Navigator lists every namespace on an IRIS or Caché server, including remote ones and whether they respond — no hand-configured JDBC URLs.

Add your first InterSystems IRIS or Caché server, group your connections, and open a query editor — the three things to do in the first five minutes.

Pull the IRIS and Caché instances already registered on your machine straight into the Server Navigator, with host, port and namespace filled in for you.

Three ways stored IRIS values can contradict their own metadata — access failures, silent corruption and undetected mutation — and how to find each one.

Select the source and target namespace in the Server Navigator, open Tools then Copy Data, and copy a table into an existing target or a newly created one.

DuckDB ships inside SQL DATA LENS, so querying a local CSV, Parquet or JSON file takes an in-memory connection and a drag-and-drop — no install, no driver download.

InterSystems IRIS ships hundreds of system classes and schemas. One checkbox on the connection leaves the Server Navigator showing only your own objects.

Export any result grid to CSV, XML, HTML, JSON, SQL or Excel — and use direct to file instead when the result set is too large to hold in the grid.

Flat Light and Flat Dark ship with SQL DATA LENS, and scaling follows the per-monitor DPI you set in Windows rather than a setting inside the application.

A CSV text connection turns a file, a folder of files or a ZIP archive into something you can SELECT from — with the driver's SQL limitations spelled out.

Licence activation reads the machine fingerprint through WMI. If Windows reports a broken repository, these steps rebuild the network adapter classes.

SQL DATA LENS is now developed and supported by Data Prudentia GmbH. Existing licences, support arrangements and points of contact all stay as they are.