View Image

SQL Data Lens is a development tool designed for InterSystems database. It supports developers with a advanced SQL Query Editor.In SQL Data Lens Server Navigator you see all available Namespaces on your IRIS 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 IRIS 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 IRIS 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 IRIS Servers. In SQL Data Lens 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 IRIS Server is requested, SQL Data Lens downloads the InterSystems IRIS database driver automatically from the Web. No manual intervention is required. (homepage Auto register IRIS Server: With this feature you can very straightforward create a Server registration from a local IRIS installation. All data that SQL Data Lens requires for working with IRIS 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