Is it possible to create ODBC connection to mongoDB database ? Can anyone share their experience if any ?
I am doing some development using the MEAN stack .. I would really excited about integrating the datbase with FM ....
perhaps you can "connect" but only use Import and Execute SQL (both script steps that can use ODBC source).
Unless the DB is one of the "approved" ones, it will not be available as "live connect" (ESS).
And as always, any external connection depends on the driver and any permissions on the db.
Thanks beverly ... Also found this
Yes! that is using the two script steps. Great to know someone else has done so for this particular DB.
Yeah .. will try it out .. MongoDB is becoming quite popular with the NoSQL fans .. But I didn't realise one could make SQL queries on NoSQL databases !
I am also working on it now. I have successfully created ODBC source with Simba MongoDB ODBC Driver and can be managed from FileMaker.
2016-03-14T11:18:44.489+0800 I NETWORK [conn19] end connection 192.168.1.11:61860 (1 connection now open)
Retrieving data ...