JDBC | InterSystems Developer Community

DataGrip is a multi-engine database environment targeting the specific needs of professional SQL developers, DataGrip makes working with databases an enjoyable and productive experience.

To work with InterSystems IRIS from DataGrip you'll need to add InterSystems JDBC driver first (once per DataGrip) and after that add all your InterSystems IRIS connections.

Part 1: Add InterSystems IRIS JDBC Driver

1. Go To File → DataSources

#JDBC #SQL #InterSystems IRIS

1 0

0 808

Article

Zhong Li · Jan 27, 2020 7m read

Python JDBC connection into IRIS database - a quick note

Keywords: Python, JDBC, SQL, IRIS, Jupyter Notebook, Pandas, Numpy, and Machine Learning

1. Purpose

This is another 5-minute simple note on invoking the IRIS JDBC driver via Python 3 within i.e. a Jupyter Notebook, to read from and write data into an IRIS database instance via SQL syntax, for demo purpose.

#Best Practices #JDBC #Machine Learning (ML) #ODBC #Python #InterSystems IRIS

6 1

2 3K

Article

Yuri Marx · Jun 10, 2020 1m read

Copy files between your Intersystems Docker Instance and your host (jdbc driver sample)

Many times it is necessary copy or send files to your docker container instance.

In my case was with IRIS JDBC driver.

Docker has this recipe for this (credits to https://docs.docker.com/engine/reference/commandline/cp/):

docker cp [OPTIONS] CONTAINER:SRC_PATH DEST_PATH|-
docker cp [OPTIONS] SRC_PATH|- CONTAINER:DEST_PATH

But to copy you need your container name. Write this command for this:

docker ps

In my, my-iris is the container name.

#Docker #Java #JDBC #InterSystems IRIS

4 1

3 575

Article

Marc Mundt · Jun 30, 2016 3m read

Connecting to Caché with SQuirreL SQL, an external SQL client

The Caché System Management Portal includes a robust web-based SQL query tool, but for some applications it’s more convenient to use a dedicated SQL client installed on a user’s PC.

SQuirreL SQL is a well known open source SQL client built in Java, which uses JDBC to connect to a DBMS. As such, we can configure SQuirreL to connect to Caché using the Caché JDBC driver.

#JDBC #Open Source #SQL #Caché

9 11

1 10.9K

Article

Steven LeBlanc · Jan 28, 2016 1m read

Sample Interface: HL7 to external SQL database

This is a sample Ensemble/Health Connect production which demonstrates how to receive an HL7 order (ORM) inbound from a file, extract fields (in this case, basic demographic information), and insert those into a table in an external SQL database via ODBC.

Included in the zip file:

Exported code
Sample ORM message
'How to configure' doc

#Ensemble #HL7 #JDBC #ODBC #SQL #System Administration

1 3

0 1.7K

Article

David E Nelson · Mar 9, 2017 9m read

Machine Learning with Spark and Caché

Apache Spark has rapidly become one of the most exciting technologies for big data analytics and machine learning. Spark is a general data processing engine created for use in clustered computing environments. Its heart is the Resilient Distributed Dataset (RDD) which represents a distributed, fault tolerant, collection of data that can be operated on in parallel across the nodes of a cluster. Spark is implemented using a combination of Java and Scala and so comes as a library that can run on any JVM.

#Artificial Intelligence (AI) #Analytics #Big Data #JDBC #Machine Learning (ML) #Python #Vector Search #Caché

11 5

1 2.8K

Article

Scott Beeson · Nov 4, 2016 2m read

Sample of IHE Performance monitoring dashboard

I've asked a lot of questions leading up to this, so I wanted to share some of my progress.

The blue line represents the number of messages processed. The background color represents the average response time. You can see ticks for each hour (and bigger ticks for each day). Hovering over any point in the graph will show you the numbers for that period in time.

This is super useful for "at a glance" performance monitoring as well as establishing patterns in our utilization.

#Analytics #Dashboards #JDBC #ODBC #SQL #HealthShare

5 2

0 541