Servoy Forum

Hi,

I am trying to add a Mongodb driver in Servoy to connect to Mongodb. I have installed different jars from http://mongodb.github.io/mongo-java-driver/ but when I create a new connection in Database Server, that driver is not shown as an option.

Does anyone have worked with Mongodb in Servoy?

Regards

Hi Juan,

I am pretty sure that driver is not a JDBC driver (which is what Servoy requires).

If you want to use SQL to query MongoDB you can use PostgreSQL and a Foreign Data Wrapper (FDW). For instance this one.
This way you connect to PostgreSQL using the regular PostgreSQL driver and query (foreign) tables that are in MongoDB.

I believe even MongoDB's own "BI Connector" uses this approach.

More information on Foreign Data Wrappers:

• https://www.postgresql.org/docs/current/static/postgres-fdw.html
• https://wiki.postgresql.org/wiki/Foreign_data_wrappers

Hope this helps.

Never used it, but this is on ServoyForge: https://www.servoyforge.net/projects/mongodb