Archive for Month: August 2013

slide

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 […]

slide

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 […]

slide

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; […]

slide

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

slide

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. […]

slide

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 […]

slide

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 […]

slide

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. […]

slide

Global Browser

The global browser shows globals within Caché Monitor. The user can easily navigate through nodes.          

slide

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 […]