First steps with SQL Data Lens

To access a database server with SQL DATA LENS you have to setup a Database Connection to InterSystems IRIS or InterSystems Caché. To do this, right-click the Connections Node in the Server Navigator and select Add Server.

On the next dialog you have to enter specific details for InterSystems IRIS or InterSystems Caché

Enter the required information and press OK.

It is recommended that your selected driver version be of the same release (or higher) as your database server.

If you have many servers, you can group servers into server groups. If you right-click the Connections node (this is the main server group), you can add more groups to structure your servers.

SQL statements are executed using SQL DATA LENS sql editor. You can find this tool in many places, for example, by right-clicking on a Server node and then selecting the menu item “New query”.

Pressing CTRL+O open also a new Query editor