SQL DATA LENS may display a message such as the following during activation: If you’re getting that error this means that part of the operating system is broken. This is …
Intersystems IRIS and Intersystems Cache have many useful system objects. If you connect to the database using a generic tool, you may be overwhelmed by the sheer number. Maybe you …
SQL DATA LENS provides the ability to export data to a variety of formats In order to export the data there exists some options in SQL DATA LENS: Save result …
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 …
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 …
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 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.
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 …
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 …
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 …
