Q&A

How to link Solution Manager to the Denodo updates repository?
answered 18-08-2020 06:35:51 -0400

How to link the Denodo solution manager to the Denodo update repository. I cannot see any option to link it up in solution manager web admin tool. I recently installed the denodo 7.0 and it doesn't have lastest update installed.

Answers: 1

Denodo 7.0 SolutionManager update

Why Dropped objects are also exported?
answered 18-08-2020 03:34:05 -0400

I used right click one Denodo folder (there are some views under this folder), click "export", and in the prompt window, I define a Output File, choose "Replace existing elements", and I can export this folder and the views within it to my local path, ...

Answers: 1

droped views export

Simulating an Update statement in Denodo
answered 18-08-2020 03:14:45 -0400

How do we simulate below statement in a derived view in Denodo update fw_denodo_table a set a.column1 = b.column2 from denodo_table2 b where a.column2 = b.column3 and a.column5 = b.column6 and a.year=2019; Please advise

Answers: 1

joins update derived view

DENODO CAN NOT READ EBCDIC DATA
answered 17-08-2020 08:20:16 -0400

Hi, I have a database (DB2Warehouse) which has a table with columns that have EBCDIC data. Ho can I access that using Denodo.

Answers: 1

How to login
answered 17-08-2020 05:49:51 -0400

Why I am not able to connect with my login and password? Is the given localhost URL a default?

Answers: 1

Login Failure

Does Denodo has the command to change the view's cache mode ? eg, from cache "Off" to "Partial", or cache "Off" to "Full"
answered 17-08-2020 01:04:21 -0400

Does Denodo has the command to change the view's cache mode ? eg, from cache "Off" to "Partial", or cache "Off" to "Full" . Thanks, we need this kind of command for some aotumation tasks. Not want to do it from VDP client.

Answers: 1

vql shell cache mode store procedure

vql shell command or existing store procedure to gathering statistics
answered 14-08-2020 17:54:08 -0400

Do we have some exsiting vql shell command or store procedure which is for stastics gathering, we want to use some command to do the statistics gathering. Thanks.

Answers: 1

vql shell Gather Statistics

Configuring soutbound sources 'credentials/connection string' dynamically via api
answered 14-08-2020 08:12:27 -0400

we have denodo at my company and it will have many southbound connections to RDS databases. OUr Security team is very tight on handing out secrets and manaully setting the host/id/pwd creds to the rds databases to a denodo virtual database admin human....

Answers: 1

credentials southbound api

Export with dependency changing underlying values of ping_data_source function
answered 14-08-2020 03:34:34 -0400

I have a union on the connection status of several data sources. If I export just that union with the dependencies it changes values in the underlying vql in the export. If I export the entire database that bug does not occur. Here's the value it shou...

Answers: 3

Question regarding how user can enter value to see the specific result
answered 14-08-2020 03:27:03 -0400

Steps to have variable or parameter for Denodo view which could be used to enter the input value by the user when the view gets executed

Answers: 1