View Image

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. (homepage 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 right driver version… all you have to do is entering the password. (homepage Query Analyzer (SQL Editor) The editor supports code completion (Intelli Sense), SQL Code folding and much more. (homepage