Insert a panda dataframe into an InterSystems IRIS table?

Question

Question

Blaise ZARKA · Apr 21, 2020

Hi,

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.

thanks,
Blaise

Discussion (4)0

Log in or sign up to continue

Eduard Lebedyuk · Apr 22, 2020

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.

1 0

score 0 · Answer 1 · 2020-04-21T12:20:00-04:00

You can use PythonGateway or IRIS Native for Python to do that.

PythonGateway can retrieve dataframe (any object really) as a JSON.

Here's a corresponding discussion on the SQL side of things.

score 0 · Answer 2 · 2020-04-22T05:36:16-04:00

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.

score 0 · Answer 3 · 2020-04-22T10:00:53-04:00

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