Mongodb integration
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
Comments
Using [ Language = python ] in a classmethod and then leveraging pymongo could be one way to do this
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.