You can translate the question and the replies:

Denodo view in finding out Top 10(customers) by some measure in tableau

We are trying to use Denodo view in finding out Top 10(customers) by some measure in tableau.for this created a set in Tableau with top 10 and pulled in report and gave error "error connecting to denodo odbc" Can you tell any workaround for this or how this fuctionality to work
user
28-03-2017 18:15:50 -0400

3 Answers

Hi, If you are working on a Windows machine I would like you to first perform a test connection on your DSN to ensure you could access the Denodo view using ODBC connection. Have a look at [DSN configuration for ODBC connections to VDP](https://community.denodo.com/kb/view/document/DSN%20configuration%20for%20ODBC%20connections%20to%20VDP?category=Northbound+Connections) Also check if you have the VDP server in the running status and the underlying Denodo views are still available in VDP Admin Tool. I hope this helps you!
Denodo Team
29-03-2017 07:00:45 -0400
Hi Team The connection test is fine as Iam able to generate other reports .Only when I filter the column to apply top condition the error comes "ERROR: Syntax error: Exception parsing query near 'LIMIT' java.sql.SQLException: Syntax error: Exception parsing query near 'LIMIT'; Error while executing the query" Can you please help?? or whether its Denodo bug
user
29-03-2017 12:16:54 -0400
Hi, When I need to get a specific number of results, I usually add the **LIMIT** clause to the end of my query. For example: ``` SELECT * FROM customers LIMIT 10; ``` When I have a problem executing a view and I am not sure where is the error, I follow these steps to pinpoint the reason: 1. I get the query executed in the Denodo VDP Server by reading the vdp-requests.log. 2. Once I have the query throwing the error, I execute it in the VQL Shell of the VDP Admin tool. 3. I annalyze the execution trace to see which is the first node with error. If with that you are still not able to solve your problem and you have a user with access to the Denodo Support site (http://support.denodo.com), I would recommend you to raise a support case and the Denodo Support team will help you to find the solution. Hope this helps!
Denodo Team
03-04-2017 05:12:14 -0400
You must sign in to add an answer. If you do not have an account, you can register here