You can translate the question and the replies:

Problem with Denodo - Tableau Connection

I have some problems in the connection between Denodo and Tableau. I guess I had correctly succeded in the connection... ![Tableau - Denodo](https://imgur.com/2Jo6ezH) ..., but Tableau seems that can not see the base view of my Denodo’s DB (Tableau) ![Tableau - Denodo2](https://imgur.com/dPbMFXJ) P.s. When I run the initial sql select * from tableau.salesrecord tableau does not give any error (error that it gives if I digit a bad table name select from tableau.salesrecor and it gives me a bad connection error) Can you help me with this problem? Thank you in advance Lorenzo https://imgur.com/2Jo6ezH https://imgur.com/dPbMFXJ
user
08-10-2019 11:59:59 -0400

4 Answers

Hi, In your case, if I have added Initial SQL in Tableau, then I would ensure to input the correct SQL command in the Initial SQL for successful sign in to the Denodo database. This command will be executed whenever Tableau establishes a connection with Denodo using the provided user login. In case if the connection succeeded and you are able to sign in to the Database, but you are not able to see the base views, then you could check if the user has required privileges to connect to the base views. To analyze more on your behavior, you could check the **vdp.log** file located in the path ***<DENODO_HOME>/logs/vdp/***. If required, you could also enable log level for **vdp-queries** and **vdp-requests** by following the articles [Configuring the Logging Engine](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/configuring_the_logging_engine/configuring_the_logging_engine#configuring-the-logging-engine) and [How to log the requests issued on a VDP server](https://community.denodo.com/kb/view/document/How%20to%20log%20the%20requests%20issued%20on%20a%20VDP%20server?category=Operation) to troubleshoot in detail. For more information, you could refer to the Knowledge Base article [How to connect to Denodo from Tableau Desktop](https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Denodo%20from%20Tableau%20Desktop?category=Northbound+Connections) on configuration steps. Hope this helps!
Denodo Team
10-10-2019 04:02:03 -0400
Thanks i have one more problem This is the error from the log: 5021393 [ODBC(2)-10.110.14.32] ERROR 2019-10-21T17:11:17.240 com.denodo.vdb.vdbinterface.server.odbc.ODBCBackend [] - Error: Error loading view I make a schema of my current connection problem: | **Denodo My PC (localhost**) | ** Denodo Other PC ** | **Denodo Virtual Machine** | | **Tableau My PC (localhost)** | OK | OK | Problem described below | | **Tableau Other PC ** | OK | OK | Problem described below | | **Tableau Virtual Machine ** | OK | OK | Problem described below |
user
21-10-2019 11:34:01 -0400
Thanks i have one more problem This is the error from the log: 5021393 [ODBC(2)-10.110.14.32] ERROR 2019-10-21T17:11:17.240 com.denodo.vdb.vdbinterface.server.odbc.ODBCBackend [] - Error: Error loading view I make a schema of my current connection problem that make that error: Tableau My PC (localhost) - Denodo My PC (localhost): OK Tableau My PC (localhost) - Denodo Other PC: OK **Tableau My PC (localhost) - Denodo Virtual Machine: Problem described in the previous question** Tableau Other PC - Denodo My PC (localhost): OK Tableau Other PC - Denodo Other PC: OK **Tableau Other PC - Denodo Virtual Machine: Problem described in the previous question** Tableau Virtual Machine - Denodo My PC (localhost): OK Tableau Virtual Machine - Denodo Other PC: OK **Tableau Virtual Machine - Denodo Virtual Machine: Problem described in the previous question **
user
21-10-2019 11:38:28 -0400
Hi, In order to resolve your error, I would check the below points for successfully connecting with Denodo, 1. RMI hostname or IP address has been configured for the Virtual Dataport Server. You could configure the same in the Configure > JVM options of the Denodo Platform Control Center. Once done, Restart the Virtual DataPort Server to apply the changes. From the client application, connect using the RMI host provided instead of localhost. For more information, please refer to the section [Denodo Platform Configuration](https://community.denodo.com/docs/html/browse/7.0/platform/installation/denodo_platform_control_center/virtual_machine_and_web_container_configuration/virtual_machine_and_web_container_configuration#denodo-platform-configuration) of Denodo Platform Installation Guide. 2. While configuring the ODBC driver, set up DSN using DenodoODBC Unicode driver (not DenodoODBC ANSI). You could refer to the section [Configuration of the ODBC Driver on Windows](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_odbc/configuration_of_the_odbc_driver_on_windows/configuration_of_the_odbc_driver_on_windows#configuration-of-the-odbc-driver-on-windows) of Virtual DataPort Developer Guide which explains the steps to connect to Denodo from an ODBC application. Hope this helps!
Denodo Team
31-10-2019 01:39:28 -0400
You must sign in to add an answer. If you do not have an account, you can register here