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 September 2019.

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.

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

Enforce TLS 1.2 on Denodo servers
answered 14-09-2020 08:56:59 -0400

Hello, we would like to enforce TLS version 1.2 on our Denodo servers (including Denodo Solution Manager), SSL/TLS is enabled at the moment but we don't seem to find a way to disable versions 1.0 and 1.1. How could we proceed?

Answers: 1

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

Setup connection with QlikSense
answered 10-09-2020 15:21:37 -0400

How to setup connection of Denodo Base and Derived VIews with QlikSense ? What is the port number to be used to make connection from ODBC driver ? In Our production setup, we have two Denodo server i.e., Production and DR how it will failover in case...

Answers: 1

#QlikSense

XML to CSV
answered 10-09-2020 13:16:54 -0400

Hi, I create a datasource for XML and and a view is created - basically a Wrapper is created and I can execute this view in the Execution panel. Question: Need guidance on who I can query or transform data into a csv or into a tabular form by rows. M...

Answers: 1

XML Data Source