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.

Server component and client component.
answered 04-01-2019 05:36:30 -0500

Can a server component also be a client component and vice-versa? Is there any list of client component and server component in Denodo?

Answers: 1

Components

Denodo, caching, delegation
answered 03-01-2019 08:05:43 -0500

Happy New Year ! A query references 6 Denodo views, 2 of them, VA and VB, are on datasource DS1 and the other 4 on datasource DS2. VA si VB are cached on datasource DS3. It is a star schema. DS3 and DS2 reside on the same physical database server but i...

Answers: 1

Data type mapping
answered 03-01-2019 08:04:42 -0500

Hi, Happy New Year I have been asked to produce a data type mapping from Oracle to Denodo. I can't figure out what happens, for instance to integers: In Oracle an integer would be a Number(38), so -999..(38 9s) to 999... In Denodo the Int data type h...

Answers: 3

oracle datatype

denodo-vdp-odbcdriver-7.0 driver download file inconsistent with provided MD5 checksum
answered 03-01-2019 06:22:19 -0500

Hello, The 'denodo-vdp-odbcdriver-7.0' driver download file on https://community.denodo.com/drivers/odbc/32 appears to be inconsistent with the checksum provided on the site. Also can you advise where I can get the 'DenodoODBC_src.tar.gz' Linux ODBC ...

Answers: 1

Accesing Comment window of denodo output.
answered 02-01-2019 07:30:59 -0500

Hi Team, Can we access the output message in denodo through Store-Procedure. If possible then how to do. please provide me some appropriate solution. Eg. while i am executing below query in denodo. "select resultname,resultlastusermodifier,resultlast...

Answers: 1

The incoming request has too many parameters
answered 31-12-2018 05:43:08 -0500

Hello, I am trying to create a union view. I am getting this error while executing the query: Finished with error: Error executing query. Total time 2.36 seconds. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE] [ERROR] Receiv...

Answers: 1

Denodo Abbrivation Function
answered 28-12-2018 08:13:03 -0500

Hi I am getting column from my DB with TimeZone : Eastern Time Zone i want to make this as EST like i have 24 Different timezones on my table . if my time zone changes EST to EDT i want to atomatically populate EDT on my column. how i am suppose to a...

Answers: 1

Fetching VQL
answered 28-12-2018 07:26:34 -0500

Hi Team , I am trying to create a store procedure to fetch VQL of views. Below is query to get VQL. "DESC VQL VIEW <name> ('dropElements' = 'no', 'replaceExistingElements' = 'yes', 'includeDependencies' = 'no') " Is there any other way to get ...

Answers: 1

Custom messages or exceptions for Rest API
answered 28-12-2018 07:05:17 -0500

Hi Team, When I publish a View via REST API when we don't have data for respective input parameter given denodo throws for example 200 or 400 error codes so instead of it can I throw error as No Data for 200 and 500 as Server down etc.. Kindly suggest...

Answers: 1

Sharing The Data sources
answered 28-12-2018 04:19:43 -0500

Could you please explaing the Second approach in details with valid example,i would like to implement the same.

Answers: 1
Related to: Sharing data sources