Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Denodo JDBC Jar
answered 15-02-2018 04:13:52 -0500

Where can I get the latest denodo JDBC jar?

Answers: 1

cast netezza to denodo
answered 14-02-2018 18:47:49 -0500

Hello in netezza I have this transformation CASE WHEN campo1 = 'K' THEN ((campo2 ::INTEGER) / 1024) ::VARCHAR (15) WHEN campo1 = 'M' THEN (campo2 ::INTEGER) ::VARCHAR (15) WHEN campo1 = 'G' THEN ((campo2 ::INTEGER) * 1024) ::VARCHAR (15) END Is the...

Answers: 1
Related to: Oracle SQL to Denodo VQL Quick Reference

Denodo connection through java
answered 14-02-2018 08:25:55 -0500

How to connect to denodo through java code?

Answers: 1

View failing with error - Method not supported
answered 14-02-2018 08:23:38 -0500

Hi Team, We have a derived view, it is working fine when we dont use distinct option. but when we use distinct option, it is failing with Error executing query - Method not supported error can you please advise ? the type of join we are using is Any

Answers: 1

Export the Gathered Statistics of a Base View (or any View)
answered 14-02-2018 07:57:01 -0500

I would like to Export the Gathered Statistics of a Base View (or any View), and apply those to the same view but in another Denodo server. Please let me know how I can do so.

Answers: 1

Gather Statistics

Denodo connect to SQL server -- cannot log in -- troubleshoot
answered 14-02-2018 03:48:18 -0500

I am using JTDS SQL server 2012 driver, jdbc:jtds:sqlserver://server:port/database; useNTLMv2=true; domain=domainname after I input login and password, I got error message " Unable to estable connection: Login Failed for user xxxx". then I went to VP...

Answers: 3

SQL Server

Localhost
answered 13-02-2018 11:50:25 -0500

Note - the above solution requires you to run this on a Locally running VDP server. In order to achieve this if you are using a remotely hosted or headless server, you can install the Denodo Express version, and run a VDP server on your local machine,...

Answers: 1
Related to: OAuth authentication using the Salesforce REST Custom Wrapper

Launch issue - DataPort Server
answered 12-02-2018 03:30:53 -0500

Data Port Server is running then stopped. Server Located at port 9999. Why the server got stopped? How to get the server up running?

Answers: 1
Related to: Starting the Denodo Server

Launch issue - Virtual DataPort Administration Tool
answered 12-02-2018 02:46:47 -0500

I downloaded the Denodo Express version. It was installed successfully. It did not allowed me to login. It shows "connection error, connection refused; connect" Please let me know what I did wrong or miss something. Thanks

Answers: 1

Parameterized view join with other views
answered 09-02-2018 07:29:49 -0500

Hi Experts, I have requirement to join parameterized view with other views (not parameterized) . for that I have created parameterized view(buss_day_clndr) when I query this view alone with below sql it works fine. select count(clndr_dt) from buss_da...

Answers: 4

Parameterize