Aperçu des sections

• Setting Up Python and InterSystems IRIS on Windows

  Setting Up Python and InterSystems IRIS on Windows

  Content Type
  Video

  Duration
  6m

  Level
  Introductory

  Learn how to prepare a local Python development environment for InterSystems IRIS® data platform. See how you can start an InterSystems IRIS container, create a Python virtual environment, install the required packages, and connect to your InterSystems IRIS container from Python.

  Try it yourself:

  • Get official InterSystems Community Edition containers or local installation kits.
    
  • Try a similar process on your own instance using the steps to set up a DB-API connection to InterSystems IRIS (documentation).
• Code Used in This Video

  Code Used in This Video

  Reference	Timestamp	Code
  Create and run a Python virtual environment	1:48	python -m venv .venv .\.venv\Scripts\Activate.ps1
  Import the InterSystems IRIS Python package, then define the connection string and credentials for a local containerized instance.	2:20	Begin code: import iris connection_string = "localhost:1972/USER" username = "SuperUser" password = "ysys" End code
  Create a connection, create a cursor, and execute a simple SQL query. This query returns version information from InterSystems IRIS and verifies the connection is working.	2:30	Begin code: connection = iris.connect(connection_string, username, password) cursor = connection.cursor() cursor.execute(""" SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES LIMIT 5""") row = cursor.fetchone() End code
  Display the result and close the cursor and connection.	2:35	Begin code: print("Connected to InterSystems IRIS.") print("Sample Tables:") for schema, table in cursor.fetchall(): print(f" {schema}.{table}") cursor.close() connection.close() End code
  SQLAlchemy example	5:12	Begin code: from sqlalchemy import create_engine, text engine = create_engine( "iris://SuperUser:sys@localhost:1972/USER" ) with engine.connect() as connection: result = connection.execute(text(""" SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES LIMIT 5 """)) print("Connected to InterSystems IRIS.") print("Sample Tables:") for schema, table in result: print(f" {schema}.{table}") End code.
• What's Next?

  What's Next?
  • Query data in InterSystems IRIS via the Python DB-API (exercise, 10m).
  • Explore Python documentation for InterSystems IRIS (documentation).

  • Content last verified: August 14, 2026