Home / Q&A / All Questions

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.

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

Java Heap space error while exporting
answered 07-01-2019 07:22:26 -0500

Hi Team, While I am exporting im getting java heap space error in DEV environment. Also we are taking backup using export.bat scripts, I could see the size of VQL file is increasing day by day. Could you please provide us solutions to resolve this i...

Answers: 1

java export

Want to switch metadata from derby to sqlserver. is it possible and what are the steps involved?
answered 07-01-2019 02:10:32 -0500

I need to switch metadata from derby to sqlserver. so we can pull some reports from metadata information. is it possible ?> can you please let me know the steps? Looks like we cannot switch metadata repository, just want to make sure. i...

Answers: 1

#metadata

Getting Donodo error when creating a new folder in VDP
answered 07-01-2019 01:56:02 -0500

I'm getting the Denodo error message below when I try to create a new folder in Virtual Data Port. Does anyone know what the error means? "There was an error while creating the folder: com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException:...

Answers: 1

Sorting by Measures
answered 04-01-2019 07:08:01 -0500

I've been able to connect to Denodo via Tableau and was surprised that I could not sort by a Measure (total_amount). Does anyone know why I cannot sort by a measure? I'm connected to the amount_due_by_client tutorial data source.

Answers: 1

denodo with tableau

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