Welcome to the home of Caché Monitor PDF Print E-mail
Caché Monitor is an lighweight integrated environment for accessing, configuring, managing, and administering many components of InterSystems database Caché. Caché Monitor combines tools with a smart sql editor to provide easy access for Caché developers and administrators to the database.

 

Caché Monitor is FREEWARE and can be used from any platform with an JAVA 6 (1.6) (Windows,Linux,Apple Mac)

 

Caché Monitor for InterSystems Caché

Features

  • Handles multiple connections.
  • Asynchronus database communication
  • Server Navigator
  • Object Explorer
  • Query Analyzer
    Fast SQL Query Editor (SQL Query Analyzer) for creating SQL queries with Color coding of Caché SQL keywords to minimize syntax and spelling errors (Syntax highlighting). Caché-SQL Code completion provide context sensitiv information about database objects (Tables,Views,Columns and Indexes), also known as Intellisense. SQL Code formatting. The graphical SQL execution plan uses icons to represent the execution of statements and sql queries in InterSystens Cachè. This graphical approach is very useful for understanding the performance characteristics of a sql query.
  • SQL History
    Caché Monitor automatically saves every SQL statement executed against InterSystems Caché. These statements can be searched and recalled.
  • Tools / Performance Management
      • Tool to analyze performance by identifying slowly executing queries

      •  

Caché Monitor for InterSystems Caché

 

 

The forum contains messages from people using Caché Monitor. Join the discussion! If you have a question about Caché Monitor or how to use them, please visit the Caché Monitor Support Forum for answers and help from other users.

 

 

If you do not know InterSystems CACHÉ, here are some information about the database from InterSystems: InterSystems CACHÉ is a post-relational database that uniquely offers three integrated data access options: a robust object database, high performance SQL, and rich multidimensional access. Caché enables rapid Web application development, extraordinary transaction processing speed, massive scalability, and real-time queries against transactional data - with minimal maintenance requirements. Caché is available for Windows, OpenVMS, Mac OS X, Linux and major UNIX platforms and it is deployed on systems ranging from two to over 50,000 simultaneous users. For more details, please visit InterSystems website, you find also information about InterSystems Caché at wikipedia

 

 

If you need a SQL Query Tool for any other Database than Caché? Please read ahead. These tools are very good:

  • The Universal Database Tool - DbVisualizer is a database tool useful for developers and database administrators to aid develop and maintain their databases. It is the perfect solution since the same tool can be used on all major operating systems accessing a wide range of databases.
     [YES! It can also connect to Caché, like Caché Monitor ;) ]

  • Aqua Data Studio - is a database developer's complete Integrated Development Environment (IDE). The IDE provides three major areas of functionality: A) Database query and administration tool B) Suite of compare tools for databases, source control and filesystems, and C) a complete and integrated source control client for Subversion (SVN) and CVS
    [Again another Java and JDBC based Query Tool. So it can also connect Caché]
  • SQuirrel SQL The SQuirreL SQL client provides a simple graphical interface to relational databases. Because it is built using Java, it can access any JDBC-compliant database running on any machine, allowing remote access to multiple databases. A SQuirreL user can:
    - easily view and edit data in any JDBC-compliant database,
    - view the database’s meta-data,
    - work with multiple databases on both local and remote machines,
    - use a single, consistent interface to work with different database engines, and
    - expand the tool’s capabilities and include DB-specific functionality using plugins.

You find more JAVA/JDBC based Client Tools here.

 

Next >
 

Database News

Database Journal News
Daily Database News and Information for the Database Professional
  • Oracle Database to SQL Server Comparisons
    One of the initial obstacles a database administrator encounters is learning where features of his/her system live or reside on a less familiar system. Steve Callan approaches this feature comparison by taking SQL Server and mapping its features back into Oracle.


  • SQL Server - Introduction to Business Intelligence Development Studio
    In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.


  • SQL Server Indexed Views
    Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.


  • Oracle Database Archive Logging -- Where are my archive logs?
    Archive log destinations can be tricky when defining or viewing in Oracle Database. Stick to a few common rules and never get lost.


  • SQL Server 2008 : Accessing Audit Details
    Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.