Dremio ODBC Connection Lessons Learned

Follow

Joseph Peters

September 04, 2019 13:15

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.

1. In case you don't know already you can download the Dremio ODBC drivers here:  https://www.dremio.com/drivers/
2. Information for configuring the driver can be found here:  https://docs.dremio.com/drivers/dremio-connector.html
3. 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/
4. 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. 
5. 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!

1

• 

  Katie Garrison September 04, 2019 13:40

  Thanks for sharing, Joseph. Very helpful info!

  0

  Comment actions Permalink
• 

  Katie Garrison September 04, 2019 22:16

  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

  0

  Comment actions Permalink

Please sign in to leave a comment.