Home / Documentation / ODBC settings to JDBC
Caché Monitor connects to InterSystems Caché via JDBC. If you already have a working Caché ODBC data source on your machine, for example for Excel or Access, its settings are exactly what a Caché Monitor connection needs. This page shows where each value comes from and where it goes.
The Caché ODBC settings dialog
The screenshot shows the settings from the InterSystems Caché ODBC data source dialog. The numbers mark the same information in both dialogs.
The Connection Properties dialog in Caché Monitor
Field by field
| # | ODBC setting | Meaning | Caché Monitor connection property |
|---|---|---|---|
| 1 | Host (IP Address) | The IP address in dotted decimal form such as 127.0.0.1, or just the server name. | Host |
| 2 | Port | The port for connecting to the data source. The default for Caché is 1972. Caché 2007.1 and later use the first free port at or above 56773 if 1972 was taken at installation time, so the value in this dialog is the one to trust. | Port |
| 3 | User Name | The user name for logging in. By default this is _SYSTEM and it is not case sensitive. | User name |
| 4 | Password | The password for the account given as user name. For the _SYSTEM user the installation default is SYS, and it is case sensitive. | Password (can be left empty; Caché Monitor then asks before connecting) |
| 5 | Caché Namespace | The namespace for the data source. For Caché Monitor this information is not required, because Caché Monitor shows all namespaces of the server for easy navigation. This needs a user with enough rights to query the namespace list from the %SYS database. If the selected user does not have these rights, a namespace can be entered on the Details tab. | Namespace (Details tab, optional) |
Importing instead of typing
The Server Navigator can import connections directly: Import Caché ODBC connections reads all Caché data sources configured on the machine, and Import Caché connections reads the connection list of the Caché Server Manager (the Caché cube). Both functions are available in both editions; see the feature list and the how-to video on registering local servers.
Related
- FAQ 003: Communication link failure when the port is wrong.
- FAQ 004: user is not allowed to query for namespaces.
- First steps with Caché Monitor.
In SQL DATA LENS the connection dialog uses the same five values, adds secure connection options, imports the Caché and IRIS connections already configured on your machine (Tools, Import connections) and picks up registered Caché Monitor connections on first start. See Navigator and secure connections.
Frequently asked questions
What is the default JDBC port for InterSystems Caché and IRIS?
1972 is the default superserver port. Installations that found 1972 taken use the first free port at or above 56773. The ODBC data source dialog shows the port actually configured.
Do I have to enter a namespace?
Not in Caché Monitor. It lists all namespaces of the server automatically if the user may read them from the %SYS database. Without that right, enter a namespace on the Details tab of the connection.
Can Caché Monitor import ODBC data sources?
Yes. The Server Navigator can import existing Caché ODBC connections and the connection list of the Caché Server Manager. SQL DATA LENS offers the same import for locally installed Caché and IRIS instances and picks up registered Caché Monitor connections on first start.
Continue with SQL DATA LENS
SQL DATA LENS is the current release of this tool: native InterSystems IRIS and Caché support, SQL editor, Global Browser, database diagrams, Query Cloud and much more. Free Edition and a full 30-day Pro trial with every download, no registration.