Q&A

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

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

Import data from API
answered 12-08-2020 22:47:34 -0400

How can I import data from API ... For e.g., Workday ? Also what are the details required for the API to ingest data from any API related data source in general ?

Answers: 1

#APIDataImport

Manage change from Data Source
answered 12-08-2020 15:08:09 -0400

How does Denodo intimate Denodo Admin or users that there has been change in the underlying data source i.e., could be column name change or addition/drop of new column to the underslying table of Base View Is there any process to detect these changes...

Answers: 1

#changeManagement