QBoard » Advanced Visualizations » Viz - Tableau » Tableau + Denodo ODBC connectivity?
User Dashboard

Tableau + Denodo ODBC connectivity?

Back To Topics
Tags : tableau-api denodo
  • 317
    Has anyone successfully been able to use Tableau to connect to Denodo via ODBC?

    I'm doing a proof of concept with Tableau and I'm trying to connect to a Denodo data source. I've been told that there are no issues doing this, however, I'm receiving the standard Tableau warnings of

    Tableau identified the following warnings for the ODBC data source named 'my denodo datasource':

    Along with the standard warning message above, when I try to slice my data by Year, Quarter, Month I get the following when I add configure my date field to display Quarter in my column:

    ODBC escape convert error.

    I'm testing this out with Tableau 9.1.0 (9100.15.0828.1711) 64-bit. I've also tried it on Tableau 9.0.

    If you've gotten this to work, what versions of each are you using? (I can see that Denodo even has a mini tutorial on using Tableau to connect to Denodo, but the screenshot shows them using months instead of quarters and I can't tell which version of Tableau they are using).

    Thank you~!
      January 3, 2022 2:08 PM IST
    0
  • 346 3
    1. In Tableau, go to Data > New Data Source
    2. Select To a Server > More… > Denodo
    3. In the Denodo dialog fill in the following fields:
    1. Server: name of the server where the Virtual DataPort server is running
    2. Port: ODBC port number, by default it is 9996
    3. Database: name of the Denodo virtual database you want to connect to.
    4. Authentication: select between the authentication methods provided:
    1. Username and Password: Uses standard authentication.
    2. Integrated Authentication: With this option, the adapter will use “Integrated Authentication” (single sign-on) to connect to the Denodo server.
    • Server: When using “Integrated authentication”, enter the Fully Qualified Domain Name of the host where the Denodo server runs..
    • Database: The name of the database that has configured the Kerberos authentication for ODBC/ADO.NET connections.

    Before using this option, you need to enable Kerberos authentication for the ODBC interface of the Denodo database you are connecting to. To do this, follow the 1 to 4 of the article How to set up SSO with pass-through for ODBC connections to Denodo.

    1. Select Require SSL if SSL is needed.
    2. Finally, click Sign In.

     

      January 4, 2022 1:16 PM IST
    0
  • 259

    Hi,

    To connect to Denodo Platform which has SSL enabled from Tableau, I would follow the steps as mentioned in the below documentation:

    Additionally, if you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you.

      January 5, 2022 2:13 PM IST
    0