Mongodb integration

Question

#Databases #System Administration #Health Connect #InterSystems IRIS #InterSystems IRIS for Health

Hi. In a project I'm involved in I need to connect to a MongoDB database, read some data and store it in some internal table.

I'm wondering what's the best way to connect to MongoDB, as it seams to me there's no native Intersystems adapter.

Did anyone have handled such a scenario?

Thank you. Best regards

Davide Cecchetto

Product version: IRIS 2022.1

$ZV: IRIS for UNIX (Red Hat Enterprise Linux 7 for x86-64) 2022.1.2 (Build 574U) Fri Jan 13 2023 14:57:52 EST

Discussion (2)2

Stephen Canzano · May 14

Using [ Language = python ] in a classmethod and then leveraging pymongo could be one way to do this

0 0

David Hockenbroch · May 14

If you download the MongoDB JDBC driver, you can use it to set up an SQL Gateway connection in your system management portal. Once you've done that, you can use that to do your query, or you can link the tables in MongoDB so you can query them more directly.

0 0