SQL Data Lens

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

available Namespaces on your Caché Servers. No need to know the name of the Namespace, no need to

configure many many JDBC connections.

But SQL Data Lens can also connect to databases like MS SQL Server, MS Access, MySQL and much more to

fit your needs in a heterogeneous database environment.

Developers who are familiar with InterSystems technologies should easily find their way through

the use of InterSystems specific terms.

SQL Data Lens can execute SQL Statements across mutiple Caché Servers; Namespace and other Datasources like SQL Server; MS Access and more without any installation on the Server side!

Server Navigator

The Server Navigator is the main tool and allows to browse and organize InterSystems Caché servers into

groups, It shows database objects and structures such as tables, views, classes, indexes, constraints,

procedures, functions, etc. The Server Navigator simplifies the process of managing multiple

InterSystems Caché Servers.

In SQL Data Lenss Server Navigator 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. If the first connection to

a Caché Server is requested, SQL Data Lens downloads the InterSystems Caché database driver

automatically from the Web. No manual intervention is required.

(http://www.youtube.com/watch?v=TKg1jaCo65A)

Auto register Caché Server: With this feature you can very straightforward create a Server registration

from a local Caché installation. All data that SQL Data Lens requires for working with Caché are

automatically imported; including Port, the