Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Maximum number of fields
answered 23-09-2020 13:06:58 -0400

Hello what is the maximum number of fields that allows a view in denodo?

Answers: 5

Error Handling with Custom Functions
answered 23-09-2020 08:46:44 -0400

Is there a mechanism by which a custom function can report an error? It appears that exceptions thrown are swallowed and it is treated as though the function returns null.

Answers: 6

Function ERROR_HANDLING Custom Functions Error Handling

Can I feed Rest API parameters from a database query?
answered 23-09-2020 08:01:21 -0400

I have a list of ID values in a database table that I want to feed in as parameters to a Rest API call. I need to make one API call per ID value in the database table. I need to make the union of these Rest API calls into a single table. Can this be ...

Answers: 1

REST API

Flattening json content blob to separate columns
answered 22-09-2020 23:42:18 -0400

Hi, I am working with certain base views containing json data blobs as a column with the field type as text and not something like arrays.I am looking to flatten the view and get all the keys/values in separate columns. The content json blob column is ...

Answers: 1

json

Disadvantage of using multiple CTEs in Denodo
answered 22-09-2020 17:48:01 -0400

We are using many level of CTEs in our architeture.Also joining them with other integrated views.Please let me know what are the disadvantages of using CTEs in Denodo considering performance side.

Answers: 1

CTE

Error modifying view: View names not available
answered 22-09-2020 08:29:57 -0400

Hi , I am creating simple derived view from 2 base views , while enabling cache on the derived view i'm getting "Error modifying view: View names not available" error . Thanks for your help in advance....!

Answers: 1

Cache Error

Connecting to SSL Enabled Denodo Using NodeJS and JDBC
answered 22-09-2020 08:25:15 -0400

I am trying to connect to Denodo to obtain access to a view using a web app created from Node JS and the jdbc library. I was able to figure out how to successfully connect to a non SSL version of Denodo but I would like to know how to do it for an SSL ...

Answers: 4

JDBC Connectivity nodejs SSL

Connecting to an InterSystems Cache database
answered 22-09-2020 08:01:33 -0400

I am using Denodo 7.0 (20200310) and have a Cache database. until recently, an ODBC driver worked. it no longer functions. The recommended solution is to use an ODBC driver. At this point, I use the Generic database adapter and point to the jdbc driver...

Answers: 1

Denodo Installation Help
answered 22-09-2020 07:55:37 -0400

Hi All, I am new to Denodo. Could you please help me by providing a document of Denodo 7.0 & solustion Manager installation on the Linux server. Thank You, Ashif

Answers: 1

Denodo Installation