Q&A

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

pivot dynamically based on values?
answered 08-04-2021 02:21:52 -0400

Is there a way to dynamically create the headers for the pivot based on the values in the data? for example if I have a field that has a mapping type that can either be "sector" or "region" and then have a value by person. and end up with a cross tab t...

Answers: 7
Related to: How to Pivot and Unpivot views

pivot crosstab

getElementDatabase() not working for Denodo 8.0/ Java 11
answered 07-04-2021 09:26:45 -0400

I'm creating a custom policy but getting an error when trying to use the Denodo method getElementDatabase(); The other methods DO work from my library imports (getQuery(), getElementName(), getCurrentUserName()) - but NOT getElementDatabase(). I was g...

Answers: 1

Denodo 8.0

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