Q&A

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

Connecting Denodo to AWS Athena or AWS DynamoDB
answered 08-04-2021 06:34:55 -0400

Hi, Has anyone be able to connect to AWS Athena or AWS DynamoDB? There is already a question about connecting to Athena, but it is from May 2017. I am open to using third party drivers (CData, Simba etc.) if generic drivers will not work. Thanks!

Answers: 3

DynamoDB Athena

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