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
Which version of MongoDB are you sing and where are MongoDB and Dremio installed? Also, which java driver version are you using?
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)
Did you mean Dremio 1.0.3? That’s very old. 2.1.4 is the most recent one available for download and would be the one I would recommend.
yes, i have the most recent Dremio as i just downloaded it this week.
Knowing this information do you have a possible solution to my problem?
I greatly appreciate your help
I am getting a message now after i got my collections to show up that is saying tableau couldnt connect to the data source.
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?
i have not. i cannot read or access the data in 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?
i just got access to dremio via http://localhost:9047
i am able to select the collection and view the data in there.
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
sp i created a custom query in Dremio and it says “Unexpected Error Occurred”
Sorry I am a bit confused - were you able to follow my instructions above? It should not require you to enter a custom query.
yes, if i want to connect to a single table/collection. i need to create a a new query that has multiple joins.
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.