Q&A

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

Enabling SSL/TLS in Denodo 8.0
answered 08-04-2021 08:38:22 -0400

Hi Team, I am in middle of Denodo 7.0 to Denodo 8.0 migration. We have to enable SSL/TLS in all modules of Denodo. I am refering to the below link in the pre upgradation tasks. https://community.denodo.com/docs/html/browse/8.0/en//platform/upgrade/pre...

Answers: 1

#Denodo8Migration

Error editing resource manager rule: field not found 'roles' in view with schema
answered 08-04-2021 07:44:02 -0400

Hi All, When trying to create a rule in resource manager using roles.value condition getting error like below: Error editing resource manager rule: field not found 'roles' in view with schema Same seems to work in dev environment but not in UAT.

Answers: 3

resource Manager

Split Comma separated string to columns
answered 08-04-2021 06:50:06 -0400

Hello I am trying to split a comma separated string to multiple columns . I am not able to find an easy method to do it using the available functions. Essentially I have a field called carmodel in the datawarehouse.It has multiple model separated by a...

Answers: 3

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