Q&A

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