Be with your data!
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 your databases. Caché developers, administrators and data analysts love it. 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. Combine your data right now! All is 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 SQL Server background are also easy to find their way around
Easy to Use
Intersystems Caché driver files are included in many versions. Just connect!
Caché Monitor is available for Windows, Mac and Linux
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 table columns, primary and foreign keys while typing. Write complex scripts with variables and perform the same statements again and again without changingRead More
The central Server Navigator in Caché Monitor 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 needsRead 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 […]