Prerequisite Considerations for xDBC Queries
If you wish to query a Builder table using JDBC or ODBC in the cloud version of InterSystems FHIR, you must perform these prerequisite tasks:
-
Open port 51773 in the firewall. This is the port the xDBC client must connect to.
-
Ensure the client is connecting via TLS.
-
Connect to the FHIR namespace.
-
Connect to the sql.* domain rather than the iris.* domain.
For example, a JDBC query might look like this:
jdbc:IRIS://sql.<domain_name>:51773/FHIR/:::true
Note:
Additional details about xDBC configuration:
-
For more general details about JDBC configuration, see Using the JDBC Driver.
-
For more general details about ODBC configuration, see Using the InterSystems ODBC Driver.
