One of The Best Caché Tool You Can Find
A powerful and easy to use database tool
Connect to all your databases with a few clicks
Why choose Caché Monitor?
Works with many of your databases but is specifically optimized for unique InterSystems Caché features. It combines many tools with a smart sql editor to provide easy access to the database for Caché developers, administrators and data analysts. Caché Monitor is like a swiss knife for InterSystems Caché, fast and very easy to use. But Caché Monitor can more! Connect to databases like MS SQL Server, MS Access, MySQL and much more to fit your needs in a heterogeneous database environment. All this integrated in a single application.
Users who are familiar with InterSystems technologies should right from the start feel at home through the use of InterSystems specific terms. The interface concept is inspired by the Microsoft SQL Server Management Studio, so users with a Microsoft background should also be easily find their way through
Easy to Use
Don't worry about the right driver. Driver files are included for many different Caché versions and many other databases like MS SQL Server, Oracle, MySQL and more
Caché Monitor can be used from any platform with an JAVA environment (Windows, Linux, Apple Mac). We recommend using the latest release of Java 8!
Use as many connections as you need at the same time to do your job as fast as you can. Open multiple editors to different databases and/or namespaces
Organize and manage your SQL knowledge with the script manager. Create large sql script libraries and reuse your written code as often as you possibly can.
The build-in SQL query tool is a sophisticated editor with many powerful editing features for editing and writing complex SQL queries: see information about table columns, primary and foreign keys while typing. Write complex scripts with variables and perform the same statements again and again without changing.Read More
The Server Navigator is the central tool in Caché Monitor and allows to browse connections to InterSystems Caché and to many other databases as well. Organize all this connections into groups and sub groups in any way you like to fit your business needs.Read More
Cross database queries
With the feature called Query Cloud you can write SQL Statements across multiple Caché Servers, Namespace and combine (SQL JOIN!) this data with other datasources like Microsoft SQL Server; Microsoft Access or simple CSV files. All this with zero installation on server side!Read More
Working with a CSV Connection
With a “CSV Text connection” you can list, view and analyse your text files like SQL tables. 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 the CsvDriver. The […]
Get Intersystems Caché ODBC settings to use with Caché Monitor (JDBC)
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: to the Connection Properties dialog in Caché Monitor: Host \ IP Address Specifies the IP address in dotted decimal such as “127.0.0.1” […]
Import Caché Connections
Import localy known Caché connections very easy via menu “tool” -> “Import Caché Connections”. If you use this to add a server connection all available details are filled up.
communication link failure: Malformed reply from SOCKS server
If you get a “communication link failure: Malformed reply from SOCKS server” please try this to fix it: There are two configuration options enabled by default to let Caché Monitor work better with network proxies. Please disable these options and try again. To do that open the config.properties file (you […]
How to use the jTDS database driver with Caché Monitors – Query Cloud
Here you find instructions to use the jTDS database driver with Caché Monitors Query Cloud Feature The Query Cloud is like a virtual database. Within this virtual database you can query and use data from different databases, combine them with SQL as if they are in the same database. The […]
How to use the jTDS databse driver for MS SQL Server & Sybase Adaptive Server with Caché Monitor
Here you find instructions to use the jTDS database driver with Caché Monitor. This database driver is an open source driver for MS SQL Server & Sybase Adaptive Server. jTDS is 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008 and 2012) […]
Query multi databases in one sql statement
With that new feature you can execute SQL Statements across mutiple Caché Servers; Namespace and other Datasources like SQL Server; MS Access and more without any installation on the Server side! The working title for this feature is Query Cloud: To work with the Query Cloud you have to add […]
Connect to MS SQL Server, MS Access, Oralce and more
Caché Monitor support connections to databases like MS SQL Server, MySQL and all databases with a JDBC database driver. Caché Monitor execute queries and navigate to database objects like tables, views and more without the need to open another query tool. The current release has support for these DBMS Systems: […]
HiDPI and retina display support
HiDPI and retina display support HiDPI and Apple’s Retina Displays allow more pixels to be displayed on your screen. The result is that images display sharper; however, user interface controls may appear small and hard-to-read on high-density displays. 200% scaling solves this issue by doubling the size of the user interface. […]
Visualize your database with Database diagrams
Database diagrams graphically show the structure of the database. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it.For any database, you can create as many database diagrams as you like; each database table can appear […]