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) …
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) …
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 …