Blaise ZARKA · Apr 21, 2020

Insert a panda dataframe into an InterSystems IRIS table?


Do you have any experience in inserting a panda dataframe into SQL IRIS Table?
The dataframe.to_sql method uses sqlalchemy and it seems no dialect is available for IRIS.


1 0 4 143
Log in or sign up to continue


Thank you Eduard.
At this time, we use JDBC connection and INSERT sql command from panda but we look for a more integrated way to do that.

Both suggested approaches offer a tight in-process way of InterSystems IRIS - Python integration.

I will show some live examples of bidirectional InterSystems IRIS -  Python integration in Best Practices for in-platform AI/ML Webinar.

Offtopic but generic JDBC provider for SQLAlchemy has been discussed for years in Python community but nothing has been done.