Connect to IRIS with Python?

Question

Question

Jasenko Donlagic · Jul 16, 2018

I have seen the Cache Python binding documentation and would like to know if it's also possible with IRIS so I can write data and also read/get it from the DB? The cachesys folder does not contain any python libraries.

Discussion (7)1

Log in or sign up to continue

Rich Taylor · Feb 1, 2022

Here is a quick example program I wrote a couple of months ago. This uses JDBC and the JayDeBeapi library others have mentioned. Note the Credentials import provides a set of login credentials in the following format.

LocalCreds = {"user":"SuperUser", "password":"SYS"}

Here is the code:

import jaydebeapi
import credentials

def get_database_connection(inpDBInstance):
IRIS_JARFILE = "/home/ritaylor/InterSystemsJDBC/intersystems-jdbc-3.2.0.jar"
IRIS_DRIVER = "com.intersystems.jdbc.IRISDriver"
AA_JARFILE = "/home/ritaylor/Downloads/AtScale/hive-jdbc-uber-2.6.5.0-292.jar"
AA_DRIVER = "org.apache.hive.jdbc.HiveDriver"
# note connecting to two data sources in the same program requires that you
# reference the paths to BOTH jar files in a list in every call. Otherwise the
# second connection attempt will fail. It appears that the paths only get
# added once within a process.
JDBC_JARFILES = [IRIS_JARFILE,AA_JARFILE]

# Database settings - this should be in a config file somewhere
if (inpDBInstance == "local"):
dbConn = jaydebeapi.connect(IRIS_DRIVER,
"jdbc:IRIS://18.119.2.28:1972/USER",
credentials.LocalCreds,
JDBC_JARFILES)
else:
dbConn = None

return dbConn

def run_database_query(inpQuery, inpDBInstance):
resultSet = None

dbConn = get_database_connection(inpDBInstance)
cursor = dbConn.cursor()
cursor.execute(inpQuery)
resultSet = cursor.fetchall()

return resultSet

def print_db_result_set(resultSet):
if (resultSet != None):
for row in resultSet:
print(row)
else:
print("Input result set is empty")

0 0

score 0 · Answer 1 · 2018-07-16T08:34:53-04:00

Components Installed by Setup Type: ^{IRIS, Caché}

Unfortunately, Perl/Python Binding supported only on the x86-32 bit platform, but IRIS is only supported for x86-64.

score 0 · Answer 2 · 2018-07-17T09:12:20-04:00

Thanks. I assume I could still connect with something like this if I get it to work? https://pypi.org/project/JayDeBeApi/#usage

score 2 · Answer 3 · 2018-07-17T09:18:38-04:00

Vitaliy Serdtsev · Jul 17, 2018

REST, JDBC - of course.

2 0

score 1 · Answer 4 · 2018-07-23T14:56:39-04:00

Benjamin De Boe · Jul 23, 2018

or leveraging pyspark, as explained in this article

1 0

score 0 · Answer 5 · 2018-07-24T06:53:31-04:00

Jasenko Donlagic · Jul 24, 2018

Thanks, I will look into this, for now I'm getting the desired results with REST and CURL.

0 0

score 0 · Answer 6 · 2018-07-24T08:36:03-04:00

You can definitely compile and install cache-python binding module on x86-64 machines. I have done this on Ubuntu and it produced (pythonbind3-1.0-py3.6-linux-x86_64.egg). I am not sure I understand why it cannot be installed on IRIS x86-64bit platform. If you install python binding on IRIS I will be also interested in testing my CacheORM object-relational mapper.