Q&A

No t able to get into my Denodo Platform 6.0 application
answered 07-06-2018 08:00:01 -0400

I have Denodo 6.0 on my Windows 10 laptop. No updates just installed a little over a month ago. I am now working on the Basic training course and it has worked for all my labs in the Introduction courses. I need to know how to get in to do the labs for...

Answers: 1
Related to: Address already in use: JVM_Bind

Express License File Issue
answered 07-06-2018 07:24:37 -0400

Hi. I have successfully downloaded express on a 64 bit Windows machine. When I attempt to download the license file, it jumps to a web page merely showing script information (appears to be for the license file - see below). How do I download the actual...

Answers: 1

Denodo Express License File

data source details
answered 07-06-2018 00:06:52 -0400

how to find list of base views and their metadata information using vql shell / stored procedure for a datasource. output should be like: datasource_name, baseview_name, datasource_type, baseview_database_name, baseview_table_name, baseview_schema_nam...

Answers: 4

Enforcing primary key
answered 06-06-2018 16:20:29 -0400

In the scenario where we do not have concept of primary/ foreign key in source system such as Snowflake in that case I got to know enforcing primary key in denodo 6 does not assure that i will have unique values for a column or set of columns.What I am...

Answers: 1

primary keys

Date data type as Timestmp
answered 06-06-2018 12:52:27 -0400

Hi I am using Oracle Data in Denodo,it has Date as a data type . While editing a Base view Date columns have Timestamp as a data type . But my requirememt is like I want to see data having date column without timestamp. Every time I am going to Base ...

Answers: 1

cannoct login through default admin credentials
answered 06-06-2018 12:30:09 -0400

HI, when we tried to login through default credentials,lunux os it gave us an error as CONNECTION ERROR : CONNECTION REFUSED : CONNECT " checked log sand we found the error as INTERNAL ERROR : SUPPORT 4 PROCESSORS BUT 6 HAS BEEN FOUND then again re...

Answers: 1

VDP administration connection error

Unable to connect to the database when creating base view on DB2 datasource or reading data after upgarde to v7
answered 05-06-2018 19:36:05 -0400

Hi I have migated from Denodo Expressv6 to Denodo Express v7 and for one of the DB2 database, I get the error below when adding a base view: Unable to connect to the database: Internal error: sun.nio.cs.MS1252.getDecoderSingleByteMappings()Ljava/lang/...

Answers: 3

DB2 10 JDBC Create Base View

Removing Input Values from the View Output
answered 05-06-2018 14:35:57 -0400

I am trying to figure out a way in VQL to remove the input values from the records that are returned in the veiw. I am able to remove them in the REST Data Service, but I need them to be removed in the Interface View. Thanks!

Answers: 1

output input

statistics on derived views vs base views
answered 05-06-2018 08:56:40 -0400

when calculating the statistics of a view is it better to do that on a derived view or do I also need to do it on the base views that make the derived view

Answers: 1

statistics

Adding field in flatten view with file name as value
answered 05-06-2018 05:41:41 -0400

I am creating a flatten view on top of the base view of JSON Data Source. I want a new field to be added in the output within which the field contains file name( ex:- name.json) as value.

Answers: 1

flatten field json JSON FLATTEN