Q&A

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

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

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

unknown odata version 3.0
answered 07-05-2019 17:13:53 -0400

Hi, We have been able to successfully connect to the SharePoint lists as data sources using the Denodo-odata2-custom-wrapper. Recently when we tried to connect to one of the SharePoint lists from the same tenant we are getting an error There was an er...

Answers: 1

custom wrapper sharepoint connection error