Query Your Data

You can connect to InterSystems IRIS Managed Cloud 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 Cloud Service to enable a connection from the JDBC or ODBC client.

To create a firewall rule:

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

2. On the Firewall page, in the External Rules section, slide the Enable External Connections slider to the right.

   You are redirected to the list of deployments while the InterSystems IRIS Managed Cloud Service deployment is updated. This may take a few minutes.

3. When the status for your deployment changes from UPDATING back to COMPLETE, click the card and navigate back to the Firewall page.

4. On the Firewall page, in the External Rules section, click Create Rule.

5. In the Add Firewall Rule dialog box:

   1. In the Port Range box, type 1972.

   2. In the CIDR Block box, type <your external IP address>/32.

   3. Click Add.

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.