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.

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

Not able to view all views when scheduling a cache job using vdp cache type
answered 09-02-2018 07:24:54 -0500

Hi Team, I am trying to create a cache maintanence job using schedular and not able to view all views in load process in extraction section. so i have moved the view to admin data source in vdp and able to view it then in the schedular. FYI..i am usin...

Answers: 1

Cached Views
answered 09-02-2018 06:38:01 -0500

Hi , I have a scenario where a view is Cached and has some millions of records in the cache. Now due to change the source will start providing 4 new columns which will only have data going forward and not retrospective. The issue is that when we had...

Answers: 3

Delimited File: vertical tab and form feed as column and line delimiter, how do I put those characters into denodo?
answered 09-02-2018 00:56:39 -0500

Hi, I have a file with vertical tabs as column delimiters and form feeds as line delimiters. In Denodo, I'm trying to input the vertical tab into the column delmiter box, and it seems to work okay for the column delimiter. (I go to my source file, hi...

Answers: 3

Delimited Files delimited_files tuple