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.

Materialized Tables
answered 18-11-2019 13:51:57 -0500

Hi Team, Please provide differences between Materialized vs Temporary tables Their use cases Documentation links Thanks.

Answers: 1

materialized table

Denodo virtual machine
answered 18-11-2019 06:36:00 -0500

Hello, I tried downloading Download Denodo Training 7.0 QuickStart Virtual Machine several times but without success. The zip file is 1.5 GB in size but can not completely finish the download of Denodo Training 7.0 QuickStart Virtual Machine.zip file. ...

Answers: 1

Denodo Training 7.0 QuickStart Virtual Machine

Connect to Denodo from Azure Data Studio?
answered 15-11-2019 17:23:16 -0500

Hello I tried connecting to Denodo 7 from Azure Data Studio using the PostgreSQL plugin and following these instruction: https://community.denodo.com/kb/view/document/DSN%20configuration%20for%20ODBC%20connections%20to%20VDP?category=Northbound+Connect...

Answers: 1

Add a timezone to a timestamp in JSON data source
answered 15-11-2019 12:48:06 -0500

Hi, I am retrieving web based data which has fields formatted as a timestamp with no timezone (eg. <opened>2019-11-14 17:00:00</opened> ). The data source is in GMT. My timezone is us_mst_mdt. I would like to get the wrapper and base view...

Answers: 1

Technical Analyst
answered 15-11-2019 12:39:00 -0500

Hi Team, I am trying to connect the Denodo Virtual Data Port administrator tool (installed on my local machine in windows) to the Denodo Virtual Dataport server server installed on a AWS EC2 Linux machine. Can you please suggest the steps that I need t...

Answers: 1

Installation Connection

Find the column name group by
answered 15-11-2019 10:10:53 -0500

Hi Team, I like to list all the group by columns which we are using in view through the pre defined stored procedures like GET_VIEW_COLUMNS Thanks Balu S

Answers: 1

pre defined procedures

License configuration issue
answered 15-11-2019 08:50:46 -0500

I have used my license file in the Solution Manager of the Denodo 7.0 version, and when I open the Denodo Platform Control Center it says the Virtual DataPort Server is not available due to license restrictions. I cannot configure the license with the ...

Answers: 1

License

Training DEN60EDU0118LAB01
answered 15-11-2019 06:39:32 -0500

In this lab, I don't know how to " Project the input parameter parameters.categoryname to convert it in a simple field, and rename it as input." It's the second sentence in the Excercise instructions below. Can someone provide detailed instrucitons? ...

Answers: 1

training

Get the VQL query using the java code
answered 14-11-2019 16:55:50 -0500

Hello Everyone, Please help me how can i get the vql query of join views through the java code.

Answers: 1

Getting obligatory field of views
answered 14-11-2019 16:50:41 -0500

Hi Team , Is there any metadata table or procedure of denodo by which we can see query capabilities ,in order to find which fields are mandatory and which are optional. Thanks.

Answers: 1

Metadata views