Q&A BY TAG 'Denodo'

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

How to verify '%Trace' in the DENODOTEST file
answered 17-11-2022 07:39:22 -0500

I have been reading through the documentation of Trace directive in Denodo Testing Tool. I need to access the 'staticO' element in my trace file. When I am accessing the 'staticO' element in the .DENDOTEST file by using the following code 'PLAN ABC.PLA...

Answers: 3

Automation Denodo Testing Tool DENODO #automation_testing

How to test Access Protocols in DENODOTEST file.
answered 16-11-2022 08:51:21 -0500

In DENODOTEST, I need to test the JDBC access protocol that is present in the configuration.properties file. e.g. "jdbc:vdb://<localhost>:<portNumber>/<databaseName>". Is there any information about testing protocols in DENODO? The co...

Answers: 1

Automation DENODO #automation_testing

Kubernetes + migrate to external database requires temporary restart in admin mode
answered 16-09-2022 12:26:20 -0400

Not so much a question as a note that (if confirmed by others) could be incorporated into documentation? During restart of VDP services after migration to external metadatabase the container reported below error [20220815 version]. I think the issue i...

Answers: 1

Denodo 8 kubernetes DENODO Metadata

Firewall setting for connection with Azure Synapse.
answered 09-09-2022 11:07:28 -0400

This is regarding Denodo Connectivity with Azure Synapse : I wanted to know if we have User Login and Password available for Azure Synapse storage. Do we still need to whitelist Firewall IP connections ? And if we don't have User Login and Passw...

Answers: 1

Azure Synapse firewall DENODO

Removing column from base view
answered 25-08-2022 14:43:06 -0400

Hello, I need to remove a column from the base view created now. Is it possible to do from web design studio's graphical interface itself or have to query it in VQL query window

Answers: 1

Denodo 8.0 DENODO Base View configuration

How to connect local sql server 2019 db and oracle sql db 11g to denodo express?
answered 22-08-2022 06:12:20 -0400

Hello, How to connect local sql server 2019 db and oracle sql db 11g to denodo express? Not sure what exactly needs to be put for connecting the db with denodo. Please help. Thanks.

Answers: 1

Access Denodo Express DENODO connection How to connect the Denodo Server to the Microsoft SQL Server Oracle 11g

How to get a length of the array in Denodo?
answered 20-07-2022 01:13:56 -0400

I have a column in the Denodo view with the type ARRAY. How can I get the length of this array? Standard sql ARRAY_LENGTH function is not working.

Answers: 2

ARRAY DENODO

AWS Glue - Denodo SELECT Query with LIMIT issue
answered 15-07-2022 19:38:17 -0400

Hi, I am running a Glue 3.0 job against Denodo 7.0 server. When I run a SELECT query with LIMIT the job fails with the below error: An error occurred while calling o101.load. Syntax error: Exception parsing query near 'LIMIT' File \"/opt/amazon/spar...

Answers: 1

GLUE DENODO Direct Query

Scheduler job are failing with below error.
answered 08-07-2022 13:48:45 -0400

Scheduler job are failing with below error. Error executing query. Total time 58.293 seconds. Incomplete results Incomplete results Incomplete results Incomplete results Incomplete results __6A8344AF-188C-4395-BF17-5B65090A3EBF_J8677F255-F04D-497C-A94...

Answers: 1

DENODO Denodo Scheduler 8.0

"Output can be undefined" possible solutions
answered 22-06-2022 01:30:19 -0400

Hi, So I have been getting this "iterator output can be undefined" error It is output to many different sequences, but I can't seem to figure out why I am getting this error. All the iterator holds is a record contructor that holds the extracted data o...

Answers: 3

Wrapper DENODO ITPILOT ITPilot