An InterSystems IRIS dialect for SQLAlchemy.
This dialect requires SQLAlchemy, InterSystems DB-API driver. They are specified as requirements so
will install them if they are not already in place. To install, just:
pip install sqlalchemy-iris
In your Python app, you can connect to the database via:
from sqlalchemy import create_engine engine = create_engine("iris://_SYSTEM:SYS@localhost:1972/USER")
You can run your instance of InterSystems IRIS Community Edition with Docker
docker run -d --name iris \ -p 1972:1972 \ -p 52773:52773 \ intersystemsdc/iris-community:preview
Port 1972 is used for binary communication (this driver, xDBC and so on), and 52773 is for web (Management Portal, IRIS based web-applications and API's).
The System Management Portal is available by URL:
The default password -
SYS, has to be changed after the first login to the management portal. Or start the container with a command that resets the change password flag
docker run -d --name iris \ -p 1972:1972 \ -p 52773:52773 \ intersystemsdc/iris-community:preview \ -a "iris session iris -U%SYS '##class(Security.Users).UnExpireUserPasswords(\"*\")'"