Q&A

Error loading database while deploying the query
answered 21-09-2021 00:56:21 -0400

Hi Denodo Team, Can you help me with this error that i get when i want to deploy the query to the database. The error is "Error loading database " databasename"". any suggestion what to fix in order to work? thank you.

Answers: 1

query Data Catalog deploy

Denodo GraphQL - Concat field or output manupulation
answered 20-09-2021 08:31:34 -0400

Hi, I have a question on Denodo GraphQL. Is there a way to concat two values in a graphql query or have calculated fields like its supported in Restful Web services. Like example below query transactionsview(uid: 'abcd') { uid transname transid qty pr...

Answers: 1

concatenate GraphQL

I am running Denodo virtual machine then I am getting error
answered 20-09-2021 08:31:24 -0400

When i start denodo quickstart virtual machine then I am getting the error failed to open the session

Answers: 1

Duplicate server adresses and authentication data for same the Rest data sources
answered 20-09-2021 01:53:58 -0400

I have a server with a Rest API that has multiple endpoints that return JSON data (e.g. a jasperserver that has a rest call to get all report units and a rest call to get all report schedules). I now want to create one table for the report units and on...

Answers: 1

DB2 TABLE column with data type packed decimal conversion issue
answered 20-09-2021 01:51:15 -0400

I am connecting to a DB2 database. one particular table contains a column with data type - PACKED DECIMAL. the base view displays junk characters for this column. is there a way to convert the data type of the column on the fly or in the VQL? OR i...

Answers: 1

DB2 Packed decimal

Issue while scaling with metadata in volume
answered 17-09-2021 15:24:03 -0400

Hi Team, As mentioned in the artical it is possible to mount volume in kubernetes for Denodo metadata and depending on the storage class we could persist across deployments. However there is a teething problem with volume mount. With the volume metada...

Answers: 1
Related to: Data Persistence in Containers

kubernetes volumes derby Error Vertical scaling

Adding CONTEXT to JDBC Database URI
answered 17-09-2021 09:33:52 -0400

I am trying to add a timeout context to a JDBC connection. JDBC Parameters are referenced in the documentation (https://community.denodo.com/docs/html/browse/6.0/vdp/developer/access_through_jdbc/parameters_of_the_jdbc_connection_url/parameters_of_the_...

Answers: 4

context JDBC

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