Q&A

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

Unable to connect to Denodo Open Sandbox
answered 06-04-2021 04:08:59 -0400

I am unabel to connect to Denodo Open Sandbox. I am using Denodo 8 Express. Your Sandbox URI is: //sandbox.open.denodo.com:9999/vdb_p8yhdf Getting below error. Connection Error : Check the host name and port number are correct, and thet client an...

Answers: 1

Denodo Open Sandbox

Getting "I/O error occurred" when trying to connect to Denodo through ADO.Net
answered 05-04-2021 09:18:46 -0400

I am using the same code provided in the samples/vdp folder. I am able to connect to the Denodo DB through Sqlworkbench from my machine but not from the C# code. Please help. Below is the error stack: at Npgsql.NpgsqlState.<ProcessBackendResponse...

Answers: 1

how to rename a derived view column name
answered 05-04-2021 07:21:02 -0400

ALTER VIEW xyz( ALTER COLUMN abc RENAME column mnn); how can we rename a derived view column name

Answers: 1

derived view column rename

Unable to connect to the database: current license is non-compliant for [jdbc]
answered 05-04-2021 01:38:22 -0400

Hi Team, Configured JDBC datasource using elasticsearch my connecton was scuusessfull but when i want to create baseview from that datasource getting below exception Unable to connect to the database: current license is non-compliant for [jdbc] What...

Answers: 3

#connect

Query to Json and send result
answered 02-04-2021 08:49:30 -0400

Good Morning, Could someone be able to help me carry out the task we are trying to achieve. Since we did not finish finding the key. The tasks would be the following: 1- Connect to BBDD (We can connect without problems) 2- SQL query to the DB (It...

Answers: 3

DENODO

Graphql service was working fine but now the URL isn't working
answered 02-04-2021 08:49:21 -0400

Hi, Graphql service was working fine earlier but now the URL isn't working. What needs to be checked.

Answers: 1

GraphQL

Aggregation of derived views delegating search methods to base view
answered 02-04-2021 07:46:17 -0400

Hello, i have following problem. I want to expose a REST Web Service that shows aggregated data coming from one single Base View. The Base View can be seen as the following having some input parameters (BV has search methods): ID Desc...

Answers: 3

VQL Denodo 7.0 Base view REST ARRAY derived view data aggregation

Got the Error IM014
answered 01-04-2021 16:56:42 -0400

I'm using Denodo 32 bit drive for Denodo and yet I get the Error.

Answers: 2
Related to: How to access Denodo Virtual DataPort from Microsoft SQL Server Reporting Services

Error IM014

VQL Functionality Enhancements for UNPIVOTING multiple columns (UNPIVOT in Oracle, CROSS APPLY in SQL Server)
answered 01-04-2021 08:46:28 -0400

Hello Denodo Support Team, I understand that Denodo VQL supports TVFs (Table Value Functions) regarding the unpivoting of multiple columns in a view and joining to other sources. However, the most recent proposed solution for addressing the powerful UN...

Answers: 3

unpivot VQL cross apply

Denodo not working after java package update
answered 01-04-2021 08:46:08 -0400

Our Denodo is working properly with "openjdk version "1.8.0_252"" but when updated to "openjdk version "1.8.0282"" we are not encountering below error during the start up of its service. We are using Denodo6 on linux Error: 238780 [RMI TCP Connection...

Answers: 1

Java 1.8