Q&A

Composite keys select query in denodo
answered 17-09-2021 09:10:59 -0400

How to write select query for composite keys in denodo like oracle Below is the example for oracle: SELECT * FROM table_name WHERE (key_part_1, key_part_2) IN ( ('B',1), ('C',2) ); Could you please let me know ASAP Thanks Satish K

Answers: 1

composite keys

Changing JDBC Connection Password with VQL
answered 17-09-2021 01:49:43 -0400

Hi, I need help constructing the correct VQL to change the password for a JDBC connection within VDP? I believe it is something like: ALTER DATASOURCE JDBC connectionname ENCRYPT_PASSWORD 'thisisthenewpassword';

Answers: 1

vql JDBC Password

Setting up a Gateway/ODBC Data Source on a virtual machine for Power BI
answered 16-09-2021 04:10:30 -0400

Hi, I recently created a Power BI report based on a Denodo datasource and published it to powerbi.com. I want to set up a scheduled refresh on powerbi.com. In order to do that, it looks like I need to use a gateway. To ensure that the refresh is cons...

Answers: 1

Denodo integration with Trino
answered 16-09-2021 00:55:51 -0400

Hello, I know Denodo can be integrated with Presto. Is it planned to be also planned with Trino, the new fork of Presto? If yes, at which horizon? If not, why? Best regards, Tristan Labetoulle

Answers: 1

Presto Trino

Nested Case Function
answered 15-09-2021 17:39:15 -0400

Denodo 7.0 Please how can I use AND for conditions in CASE command. I am getting error for the statement below: SELECT ST."EQUIPMENTID", CASE ST."INSERVICE"=1 WHEN SR."DATESERVICED" IS NOT NULL AND SC."INSTALLDATE" IS NULL AND SC."INSERVICEDATE" IS ...

Answers: 1

INVALID ROUTE : PARSE ERROR
answered 15-09-2021 17:36:46 -0400

Hi, Steps followed for neo4j base view. 1) created data source for neo4j by using jdbc (adapter : generic , driver neo4j 4.0 , driver class : org.neo4j.jdbc.Driver) 2) Created a base view from Query using below query MATCH (n:Samplenode {name: 'xyz'})...

Answers: 1

Base view struct data type
answered 15-09-2021 14:14:03 -0400

Hello, I'm trying from Denodo to create a base view using introspection tool from Amazon Athena schema. The tool identifies correctly the data types for all the fields, but when I create the base view, the columns of type STRUCT are converted to text. ...

Answers: 1

Azure blog storage - excel file
answered 15-09-2021 13:59:07 -0400

Hi Team, Can denodo 8.0 read excel file thats stored on Azure blob storage? Or is has to be delimited file? and other standard files mentioned over KB? Thanks!

Answers: 7

Denodo to SAS/SHARE through JDBC : remove quotation marks in queries
answered 14-09-2021 14:09:46 -0400

Hello, We are trying to connect to a SAS/SHARE server from Denodo, using the SAS JDBC driver. Our table in our SAS server has a field called value and when we query that table through Denodo, the SQL generated by Denodo wraps the field name in double q...

Answers: 1

Cache maintenance task vs Cache
answered 14-09-2021 12:49:03 -0400

Hi Team, I am working on denodo 8.0. I was going to the training on Cache module and its recommended there not to use the cache maintanence task under server configuration as it is more expensive. Rather use the Clean_cache_database procedure. What i...

Answers: 1