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.

Listing Committed Elements
answered 15-05-2019 18:10:21 -0400

Is it possible to get a list of what has been VCS committed? I see there is a number listed of items that has been committed and pending a push, but how to find out what they are?

Answers: 3

github vcs commit

Power BI Report Builder
answered 15-05-2019 17:45:14 -0400

Hi, Has anyone tried using Power BI Report Builder (or SSRS) to access a derived view? If not, is there a way to do it, or if there is a plan to develop this feature? Thanks

Answers: 1

Power BI SSRS

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