Dremio ODBC Connection Lessons Learned

Follow
Avatar
Joseph Peters

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

Comments

4 comments

Sort by Date Votes
  • Avatar
    Katie Garrison

    Thanks for sharing, Joseph. Very helpful info!

    0
    Comment actions Permalink
  • Avatar
    Katie Garrison

    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
  • Avatar
    Eric De Andrade

    Hi Katie, 

    Does Dremio - SiSense connection work out of the box or we need to do some tweaks/hacks?

     

    Thanks,
    Eric

    (Lead Data Engineer | Adarga)

    0
    Comment actions Permalink
  • Avatar
    Katie Garrison

    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

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post