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 November 2018.

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.

Json format issue while accessing through REST webservice with SQL having Double Quotes(") character
answered 09-01-2019 23:11:17 -0500

Here are the steps we tried and we are hitting with JSON format issue in output while accessing REST webservice on Denodo derived view. Can anybody help suggesting on how to get rid of backslash \ character in the output? We are looking for output to...

Answers: 3

JSON REST Webservice

Cascading drop downs in SSRS - Does Denodo work as a source for an SSRS Report with > 1 parameter
answered 09-01-2019 04:57:38 -0500

Hello, A common use case in SSRS is to build reports with a complex set of parameters with interdependencies. These interdependencies are used to progressively narrow the dataset returned to the user. Obviously, this requires definition of > 1 par...

Answers: 1

user manual in PDF
answered 09-01-2019 04:09:53 -0500

Is it possible to have the user manual in pdf format?

Answers: 1

I am trying to virtualize SQL stored procedure in Denodo 7.0. But, I am getting the introspection error "com.denodo.util.exceptions.InternalErrorException: Unexpected error accessing the server"
answered 08-01-2019 08:11:45 -0500

I am trying to virtualize SQL stored procedure in Denodo 7.0. But, I am getting the introspection error "com.denodo.util.exceptions.InternalErrorException: Unexpected error accessing the server"

Answers: 1

SQL

Cache modes
answered 07-01-2019 17:56:38 -0500

Hi, I'm using the Denodo Express Edition platform and I'm trying to try the partial cache mode with the Match exact queries only option. I have entered Administration> Server configuration and I have activated Cache Status. Then before executing the...

Answers: 1

Partial cache Cache

MariaDB JDBC Character Set conversion
answered 07-01-2019 08:16:08 -0500

Source is a MariaDb Database, The Character set is latin1 all over the Database, Tables, Columns In this Data is stored with a Chacter Set of Macintosh e.g. MacRoman When using the JDBC Driver (JDBC Driver as documented in the Denodo Setup Guide) t...

Answers: 1

Filtering with a nested array as input
answered 07-01-2019 08:04:31 -0500

Hi Team, I have hosted a web service in denodo which is executed from Postman. In the denodo service there is a nested array(example: Employee is the array with name as one field). when i execute the business view with ("Employee").name='Hari' , getti...

Answers: 3

DENODO

Setting up multiple Base Views with similar Limit
answered 07-01-2019 07:58:26 -0500

We will need to use quite a couple of Tables for our Datawarehouse. Most Tables to be queried are having a Timestamp field up to when a record was valid. e.g.Table: lfl_app_contact -> fields ... cont_valid_to ..... So they can be identified hav...

Answers: 1

Join attributes of different (compatible) types across different data sources
answered 07-01-2019 07:40:30 -0500

Hallo Denodo Team, Suppose you need to join tables from different data sources (say Oracle and Teradata). Suppose the matching should happen between attributes that have different data types (say VARCHAR(N) on one side, NVARCHAR(m) on the other side, ...

Answers: 1

join datatypes

MSTR Connection Error
answered 07-01-2019 07:30:45 -0500

Status: Execution failed Error: SQL Generation Complete QueryEngine encountered error: FetchScroll. Error type: Odbc success with info. Odbc operation attempted: SQLFetchScroll. [01004:-2: on SQLHANDLE] Fetched item was truncated.. Error in Process me...

Answers: 1