Metadata inconsistencies in InterSystems IRIS can lead to unexpected query results, performance issues, and data integrity problems. SQL DATA LENS provides tools to identify and address these inconsistencies effectively. This …
With SQL DATA LENS, you can quickly copy tables between different databases and even across servers. This feature is available directly from the Server Navigator. To get started, follow these …
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 …
