MongoDB Driver

Questions and answers regarding general SQL and backend databases

MongoDB Driver

Postby ProRM » Thu Aug 23, 2018 5:42 pm

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
User avatar
ProRM
 
Posts: 107
Joined: Thu Sep 18, 2008 10:24 pm
Location: Uruguay

Re: MongoDB Driver

Postby ROCLASI » Thu Aug 23, 2018 8:21 pm

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:

Hope this helps.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: MongoDB Driver

Postby mboegem » Thu Aug 23, 2018 8:45 pm

Never used it, but this is on ServoyForge: https://www.servoyforge.net/projects/mongodb
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1742
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 6 guests