Q&A

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

Insert colunm in SQLServer
answered 17-09-2020 01:11:49 -0400

Hi, How i format this colunm in DENODO for write back in SqlServer table? COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH DECIMAL_DIGITS NULLABLE SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTE...

Answers: 1

Write-back scenarios

Not able to login to Denodo Admin Portal with VPN enable, although I am able to login to Denodo Admin Portal without VPN enabled.
answered 16-09-2020 09:02:30 -0400

After starting VDP server when I am trying to login into Admin Portal with company VPN enabled in the laptop then I am getting error: "Failed to login. Permission denied". Although I am able to login without VPN enabled in my laptop.

Answers: 1

What is the meaning of the below example and how can we bring it up in denodo ?
answered 16-09-2020 09:01:38 -0400

pivot ( min([Planned Date]) for [test] in ([sample1], [sample2]) )

Answers: 2

Data Catalog - Synchronize comments
answered 14-09-2020 12:17:56 -0400

When I change the description of a database in the data catalog, I cannot see this change in the VDP. Also, when I change the description from the original value in the VDP, this value is never refreshed in the catalog. Do they maintain a different m...

Answers: 3

Data Catalog

Converting the text data type into an integer data type
answered 14-09-2020 08:50:46 -0400

Hi there, I'm trying to convert a field of data type 'text' to 'integer' in denodo. The below is my sample operation. select column1, column2, column3 from bv_sample order by cast(field1 as integer) ; I get the below error: "Error converting data t...

Answers: 3

#Denodo #denodotestingtool #testingtool #denodo #SQL #VQL

Query impala not working when run over VQL vdp client.
answered 14-09-2020 07:54:58 -0400

i have query VQL like this: select nmtkp, FORMATDATE('yyyyMM',cast(tglapprove as timestamp)) as blnlApprove, COUNT(distinct(sku)) as JlhBarang,SUM(price) as HargaTotal from dbmart.facttrans a where GETYEAR(cast(tgltrans as date))=2020 and jnsklaimreg=...

Answers: 2

vdp impala

dynamic parameter in derived view
answered 14-09-2020 05:40:12 -0400

How we can create a dynamic parameter to read the value for each run and then move to next condition till the condition statify please give some example

Answers: 1

dynamic parameter

Denodo Monitor - Stopping
answered 14-09-2020 03:59:28 -0400

Hi there, Quick question about the "denodo monitor". We have a need to log all queries from all users within VDP. I have followed the online steps and have enabled them on the server in question, but I see some strange behavior. We currently have d...

Answers: 3

denodo monitor

How to do the data sync from VDP to data Catalog?
answered 13-09-2020 12:54:59 -0400

Hi team, If I run some vql on vqp client, how can I do the daa sync from VDP to data catalog? I just found, when I run some vql which changed some metadata of my view, somthing like columns adding or deletion, but these changes are not synced to dataca...

Answers: 2

Data catalog data sync

Associations with Qlik Sense
answered 11-09-2020 08:37:30 -0400

Does associations in Denodo affects to Qlik Sense performance in some way?

Answers: 1

Qliksense