Written by

Cofounder at snext

Question Blaise ZARKA · Apr 21, 2020

Insert a panda dataframe into an InterSystems IRIS table?

#InterSystems IRIS #Python #SQL

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

Add reply

Comments

Eduard Lebedyuk · Apr 21, 2020

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.

0 0

Blaise ZARKA Apr 22, 2020 to Eduard Lebedyuk

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.

0 0

Eduard Lebedyuk Apr 22, 2020 to Blaise ZARKA

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.

0 0

Eduard Lebedyuk Apr 22, 2020 to Blaise ZARKA

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

0 0