Archive for Month: August 2013
Table Browser
Easy editing, easy filtering simplify the work with your data With the table browser the data can be edited via grid. Data filtering is easily right from the context menu. Many information’s from the selected table are prepared to analyze. Max Rows and Max Chars can be configured. Max Rows limit the […]
FAQ about using Cache Monitor with InterSystems Cache
This is a list of users’ most frequently asked questions. By answering them i hope to clarify any doubts they may have regarding Cache Monitor for InterSystems Cache. 001 – Error by select the Namespaces node Question: I’am using Cache 2009.1, apparently the application connects to the server however, when I try […]
How to Videos of Caché Monitor
How to: register server How to: using the editor How to: register server from local known Caché servers How to: working with script manager How to: Write sql queries across databases Show how Caché Monitor helps to query and bring together tables from different sources. Writing sql query across namespaces; […]
Requirements running Caché Monitor
Java 7.0 or higher ~ 21.0 MB disk space for Caché Monitor A minimum of 64 MB RAM. min. Caché 5.2 on the Server
First steps with Caché Monitor
Caché Monitor is running! What next? This doc describes first steps with Caché Monitor. Execute addhoc queries Register your Server After Caché Monitor starts, you must register one ore more Caché Server. Do that by by right-clicking the Caché Server Group node in the Server Navigator and selecting Add Server. […]
Caché Monitor installation instructions
Caché Monitor requires Java to be executed. You can download the latest Java Runtime Environment from Oracle’s Java site. The latest Version of Caché Monitor can be downloaded from here Caché Monitor does not require an installer. To install Caché Monitor, you will need an unzip tool. You can download a free, cross-platform unzip […]
JDBC Driver versions for InterSystems Caché
The InterSystems Caché JDBC driver are an type 4 JDBC driver. Here are some information about the different JDBC driver versions that ships with the InterSystems Caché database. First some basic information about the Caché JDBC URL: Driver Class = com.intersys.jdbc.CacheDriver The URL syntax is jdbc:Cache://machine:port/namespace The URL specifies the machine address, port […]
Execute parameterized SQL scripts
Caché Monitor can execute parameterized SQL queries. This will help writing complex scripts with variables, the variables let Caché Monitor prompt you for the values when the SQL is executed. This is handy if you perform the same statements again and again and just wanting to pass new data in. […]
Global Browser
The global browser shows globals within Caché Monitor. The user can easily navigate through nodes.
SQL Editor for InterSystems Cache and IRIS
The SQL Editor (Query Analyzer) Caché Monitor supports multiple editors and results. The sql script is formatted and colored. Result sets can be viewed in text or table format. More features are: Color coding of syntax to improve the readability of complex statements. Code folding The text entered in the […]