Save result: available in every result grid
SQL DATA LENS provides the ability to export data to a variety of formats Text files (CSV) XML HTML SQL (INSERT, UPDATE or DELETE, INSERT) JSON Excel (XLS and XLSX) …
Setting up a connection to InterSystems IRIS\Caché
Details about connection to InterSystems IRIS and Caché Create a new connection from Server Navigator by selecting “Add Server”: On the next dialog you have to enter some details: Detailed …
Working with Namespaces
With SQL DATA LENS Server Navigator you see all available Namespaces from Caché or IRIS Servers. No need to know the name of the Namespace, no need to configure many …
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 …
Import IRIS or Caché connections
Import localy known Caché\IRIS connections very easy via menu “tool” -> “Import Caché Connections”. If you use this to add a server connection all available details are filled up.
With a “CSV Text connection” you can list, view and analyse your text files like SQL tables.
Via Menu “File” -> “Create CSV Text connection” you can create this connection type in Server Manager and query the CSV Files like a simple tables. This is done with …
You can use Caché Monitor and SQL Data Lens side by side.
Caché Monitor stores all user data in a folder named “.cm“. You will find this folder in your user home folder, e.g. “C:\Users\Andreas\.cm” SQL Data Lens stores all user data …
Get intersystems caché odbc settings to use with SQL Data Lens (jdbc)
The next screenshot shows the settings from the InterSystems Caché ODBC Settings dialog. The numbers in the screenshots mark the same information from this dialog: Host \ IP AddressSpecifies the …