Home / Q&A / All Questions

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 September 2019.

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.

Partial cached data subset still going to source
answered 14-05-2019 18:48:27 -0400

We are currently trying to use partial cache in denodo in both the versions of 6 & 7 and facing one issue. When we put the partial cache on for the view and run the query to cache it. For eg. Select * from test1 where id in (1,2,3,4); it caches ...

Answers: 1

Partial cache Cache

Coalesce on dateparam
answered 13-05-2019 19:42:29 -0400

Hi. We have two views, each has dateparam (date('@dateparam') in base views). We created a union view with these two views (where condition has the dateparam1=dateparam2). Then, we proceeded to remove a few objects from the output and coalesce the rest...

Answers: 1

Update a JDBC wrapper view
answered 13-05-2019 19:40:50 -0400

I have a JDBC wrapper view created for inserting data into a table. Due to recent business requirement we now need to add one more column to the table .Can you please help us to understand how to update existing view so that we can now insert value for...

Answers: 1

JDBC

SPENO Authentication REST Webservice
answered 13-05-2019 19:14:27 -0400

I have been successful in enabling kerbros setup over my denodo server. There are datasource acceptiing keberos authentication are working well. In one of the REST webservice, after enabling the HTTP SPNEGO (kerberos). Even on the chome browser it's p...

Answers: 1

SPENGO

Case statement on a column truncates the decimal values
answered 13-05-2019 13:33:07 -0400

Hi, We are using Denodo Platform version 6.0. When we select the column directly from the view I am getting the result with 2 decimal point, when I add case statement to check for null values on the same column, the decimals are truncated. Is there any...

Answers: 3

#casestatement #truncatedecimalswithcase

Connect SAS client from Denodo 6.0
answered 10-05-2019 08:05:15 -0400

Hi, I need connect SAS client from Denodo 6.0 views for read. I find denodo-vdp-jdbc drivers for version 7.0 in https://community.denodo.com/drivers/jdbc/32 but i can´t find this drivres for version 6.0. How i find denodo-vdp-jdbc driver-6.0 for dow...

Answers: 1

installation step
answered 10-05-2019 04:19:44 -0400

Dear, what are the main steps for install Denodo platform: Install VDP Install Solution manager move license denodo.lic to which directory start license service from SM licensemanager_startup.sh Start solutionmanager_startup.sh...

Answers: 1

Bypass Denodo Scheduler Webadmin User
answered 09-05-2019 15:12:13 -0400

Hi Team, While using Scheduler API, is there any way to bypass the Denodo Scheduler Webadmin user. By Default we see that when we try to login into schedler webadmin by default uses admin/admin. Once we are logged into webadmin, then we are redirected...

Answers: 1

Denodo Scheduler 7.0

Start up logs
answered 09-05-2019 08:38:17 -0400

Dear, Is there any logs somewhere when i want to start "vqlserver_startup.sh" I got the below message... [denodo_adm@DX3396 bin]$ Starting Denodo VQLServer ... Unexpected error. But i don t have verbose mode or logs....

Answers: 1

Cannot Connect to training Oracle database
answered 08-05-2019 07:50:43 -0400

I am following along the developer basic traing. But got stuck while connecting to oracle data-server. The error i'm getting is: Unable to establish connection: IOError: The network adapter could not establish connection. The database URI: ...

Answers: 9

JDBC Data Sources training Oracle 11g