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
Introspect all objects in your namespace and displays them in folders grouped by schemas.
Globals are the internal data structure of Intersystems Caché and IRIS. See the internals with the Global Viewer
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.