Connecting to a Non-relational database?

[BigDaddyO]

Hello,

I'm being asked to write up some testing for an application that uses MongoDB which is a Non-relational database.  I've never used this type of database before and I can't seem to find anything on this site.

Do I connect the same way as I would for a normal SQL database?  I've used SQL, Sybase, and Oracle without problems in the past.

If I was able to actually connect ("I've requested the drivers, should have them in a couple days") how would I perform the NoSQL Queries?  The online stuff I've looked at uses an interface, would I just use those statements in place of where I would normally do sql queries?

 

Thanks,

Mike

 

[GMK]

I don't have any experience with that type of database, but have you tried the MongoDB ODBC Driver?

[BigDaddyO]

uhhh..  no i did not.  Thanks!  i'll check it out.  I've been trying to figure out Python as most samples are in that.

I - Don't - Like - Python...

[water]

Never used MongoDB but I think the manual would be a good place to start reading.

Edited October 12, 2020 by water

[Skysnake]

Hi

Have you considered trying @mLipok's awesome ADO.UDF to attempt this connection?

[BigDaddyO]

no, sadly I've found out that all the (normal) ways to connect to this database only works if a BI Connector is enabled, which it's not for the db i'm trying to connect to.

So, I need to generate a cert and connect in with a Kerberos ticket to be able to connect to the db I need and they expire after 1 day.  I'm waiting on a co-worker who knows a bit about python as there are examples to do all that with Python.

[Nine]

I would personally first try to use the query tool to interact with the DB (like SQL*Plus for Oracle).   It is quite simple to script it with AutoIt.  Will save you quite some time if that approach would work (even tho it is not the greatest way to automate a DB connection).