Q&A

Need help creating a Base View from a SQL Server Stored Procedure
answered 18-08-2020 08:14:29 -0400

I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...

Answers: 3

Base view Create Base View Stored Procedure SQL Server

How to Executing VQL statements from Custom Policy
answered 18-08-2020 07:15:43 -0400

How to Executing VQL statements(SQL command) from Custom Policy. Because customer access policy data is store in database table.

Answers: 1

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