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.

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

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

Connecting from your application - JDBC Clients
answered 08-05-2019 05:54:02 -0400

Hi, I recently installed Denodo Express on my machine (Windows 10 64-bit machine). While working on the tutorial, I downloaded the DBVisualiser Free 10.0.10. I defined a Denodo driver and when I tried to create a new database connection (the database u...

Answers: 9

Extract the origin of a data source in metadata for report view
answered 07-05-2019 19:21:05 -0400

Hi, In Denodo 6, i need to know the origin of data sources, is there a way to know the origin of a data sources in the metadata? I need extract for Excel many information about metadata:Data Source Name, Type, Schema, Table or view, Column, Data Type,...

Answers: 3