Query Your Data

You can connect to InterSystems IRIS Managed Service using JDBC or ODBC and query the data with standard SQL queries. But before you can do so, you need to create a firewall rule in InterSystems IRIS Managed Service to enable a connection from the JDBC or ODBC client to the deployment on port 1972. See Firewall page.

To connect your favorite JDBC or ODBC client:

1. On the main menu for your deployment, click Overview.

2. In the Overview page, in the xDBC Details section, click the tab that corresponds to the type of client you are using (JDBC or ODBC).

3. Follow the instructions provided to connect your client.

4. Once you have connected your client, try running a simple SQL query, such as SELECT * FROM MyPackage.Patient.