Q&A

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

Delegating HASH Joins
answered 08-02-2018 11:20:28 -0500

I've got a derived view that is re-used in mutiple views. I've identified the code on the sql server side would be most effective at a specified HASH Join. How do I get Denodo to deligate a HASH join to the database (SQLServer)? I've specified a HASH j...

Answers: 1
Related to: Denodo Query Optimizations for the Logical Data Warehouse

hash join