This section will give you a brief overview of the features available in SQL DATA LENS

SQL Data Lens works with different databases but is specifically optimized for unique InterSystems Caché and IRIS features. It combines many tools with a smart sql editor to provide easy access to your databases.

SQL Data Lens is a development tool designed for InterSystems Caché and IRIS. SQL Data Lens is intended for software developers and analysts. The tool supports primarily the management of Caché and IRIS Server connections and the execution of SQL queries. The different connections can be organized in groups.

Software developers who are familiar with InterSystems technologies should easily find their way through the use of InterSystems specific terms. The interface concept is inspired by the Microsoft SQL Server Management Studio, so users with a Microsoft background should be also feel at home.

SQL Data Lens can also connect to databases like MS SQL Server, MS Access, CSV Files, H2 Databases, SQLLite and much more to fit your needs in a heterogeneous database environment.

Organize your servers and connections

The 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.

From the Navigator you reach all database objects and structures such as tables, views, globals, classes, indexes, constraints, procedures, functions and many more.

  • You can easily manage your databases by adding and removing connections to Intersystems IRIS and Caché Server
  • SQL Data Lens include Intersystems Caché and IRIS driver in many different versions
  • SQL Data Lens include database driver for e.g. MS SQL Server, MS Access, SQLLite, H2 … and many more.
    (no CLASSPATH editing required!)
  • All Namespaces are listed for easy navigation. No need to know the name of the Namespace, no need to configure a multitude of JDBC connections

Exploring Intersystems Caché and IRIS objects

  • List namespaces
  • View CPF files
  • List databases and details
    The database viewer provide information about the databases on the selected Caché \ IRIS Server
  • List and view log files
  • View the process list

Database objects

Introspect all objects in your namespace and displays them in folders grouped by schemas.

Read more

Global viewer

Globals are the internal data structure of Intersystems Caché and IRIS. See the internals with the Global Viewer

Read more

Local query cloud

Use the Local-Query-Cloud to access data across server, namespaces and databases in ONE sql statement

Read more

Writing SQL

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.

Use it!