Dremio ODBC Connection Lessons Learned
I experienced some issues when attempting to set up the Dremio ODBC connector for Sisense and wanted to share my experience to make things easier for other users.
- In case you don't know already you can download the Dremio ODBC drivers here: https://www.dremio.com/drivers/
- Information for configuring the driver can be found here: https://docs.dremio.com/drivers/dremio-connector.html
- When connecting in Sisense I got an error when trying to use the DSN option. I was only able to connect by 'Connection String' based on the format found here: https://www.connectionstrings.com/dsn/
- I was now able to add the tables but running the query returned an error " ERROR [HY000] [Dremio][Connector] (1040) Dremio failed to execute the query". This error was due to Sisense putting [] around the table names in the query.
- The error was fixed by going into Elasticube/Change Connectivity Settings and selecting 'Manual Query Input' which replaced the square brackets with double quotes "".
The connection seems to work fine now. Good luck!
-
Hi Joseph,
Just to follow up, curious if you at any point tried the Generic JDBC connection to Dremio. I ask because it looks like there is a driver available on the Dremio website: https://docs.dremio.com/drivers/dremio-jdbc-driver.html
If your organization is on Sisense 7.2.1 or later, you can take advantage of using the Generic JDBC connection through the Web ECM. If you choose to get this set up, let us know how it goes (and create a support ticket if you run into issues with this)!
Thanks,
Katie Garrison | Technical Solutions Consultant -
Hi Eric!
No hacks that I am aware of but I have not gone through the steps of setting this up for myself with Dremio.
To start, you will need to download the JDBC driver for Dremio then follow the instructions for using the Generic JDBC connection.
If you try to set this up and are not able to pull data or run into any issues with this, please feel free to create a support ticket and our team can assist in troubleshooting.
Hope that helps,
Katie Garrison | L4 Solutions Engineer
Please sign in to leave a comment.
Comments
4 comments