I am having a problem setting up the ODBC Driver for my MongoDB. I enter in the AWS Server name and the port number, along with my Dremio username and password in ODBC, but it keeps failings.
Does anyone have experience with setting up Dremio for MongoDB?
I am going through the below steps and am getting stuck on step 4
Dremio: 10.3 installed on local machine
MongoDB: 3.2.9 installed on AWS
Java: most recent Java as i was forced to install it when downloading Dremio (Which was just downloaded this week)
Can you clarify exactly what you are trying to do and where you are hitting issues? Tableau > Dremio > MongoDB?
Are there any particular errors (any logs?) that you hitting?
i believe the issue is at the ODBC part. When i connect tableau to MongoDB using Dremio it allows me to get access to the collections/tables, but when i drag them into the canvas and try to actually use the data in tableau it says there is no connection to the data. So that leads me to believe i have configured the setup of my ODBC wrong. If you can we can get on a webex or some sort of call so you can walk me through this issue? would this be possible?
Just to clarify - you have installed Dremio locally and you have already made a successful connection to MongoDB from Dremio? You can read/access all data from MongoDB just fine from Dremio?
If yes, then it seems like you are having issues with Talbeau > Dremio? Were you able to follow the documentation? Windows / Mac
so i am able to connect dremio to tableau and see all the collections/tables in tableau, but it is saying it is a bad connection, so my thought is that i did not configure the ODBC properly, which is what i would like double checked, as i am not 100% i did this step properly.
Can we first take Tableau out of the picture please and make sure Dremio is working properly? Have you already made a successful connection to MongoDB from Dremio? You can read/access all data from MongoDB just fine from Dremio?
Ok so sounds like the issue may have nothing to do with ODBC/Tableau, but with the Dremio service itself. What happens when you connect to MongoDB with Dremio? You can’t read any tables? Is there an error in the UI?
but when i try to connect tableau to MongoDB via dremio in tableau it does not allow me to view the data. It allows for me to view the collections, but it doesnt allow me to create a worksheet
Within http://localhost:9047, can you connect to MongoDB, open some data, and save it as a VDS (virtual dataset)? Then you can click our Tableau shortcut icon on top right to open that dataset within Tableau desktop
You can go ahead and do the join within Dremio UI itself before connecting to Tableau. We support standard ANSI SQL. Have you tried that?
Ultimately, you should open Dremio > connect to MongoDB tables/collections > Do queries/joins/etc in Dremio > Save as a VDS (think of this as a virtualized view of the data) > Connect Tableau to the VDS.