is it possible for me to do something like an ODBC connection to the database to dump specific data into excel or something similar?
Yes, there is an odbc driver for Mongo.
Thank you, found it.
what port do I use for my odbc connection? When using 27017 to create my connection in Windows 10, I hit test and get an endless “not responding”…
Sounds like a firewall issue, or your MongoDB instance is only listening on the loop back interface and not the any interface.
Firewall ports I can deal with, how do I see what interface/port it is listening on? And if it is only on loopback, how do I make it listen on any interface.
I appreciate your patience as I learn this.