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.

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

Denodo workday connection - Pagination
answered 06-06-2018 14:43:30 -0400

Hi team, i have imported workday SOAP Web Service using an XML data source in denodo. The web service has multiple pages. But base view is giving data from only 1st page by default. I need to get all the web pages in single request. I could find pagina...

Answers: 1

pagination Workday

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

When importing multiple files from JSON Data Source, a default name is given for the files. Can we change those default names?
answered 01-06-2018 12:04:58 -0400

After creating JSON data source and selecting a folder containing multiple files, after executing in the execution panel the results are given a default name. I am getting the output as: [Array]... [Array]... [Array]... [Array]... [Array]... There ar...

Answers: 1

import Mulitple Files JSON

Unable to connect to Microsoft SQL Server 2012
answered 01-06-2018 11:34:41 -0400

Unable to connect to Microsoft SQL Server 2012 Trying to create a JDBC data source using the given connection infomation: Host: dbsqldatapanthers.cvnxtj912for.us-east-2.rds.amazonaws.com Port: 1521 User: dbsqldatapanthers Pass: dbdatapanthers1! DB: d...

Answers: 2