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.

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

Get created view VQL query using JAVA code
answered 14-11-2019 16:48:45 -0500

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

Answers: 1

DEN60EDU0118VID01 - Combination. Foundation
answered 14-11-2019 15:53:51 -0500

In this training video, the guy shows view parameters and I believe the lab requires a view parameter as well. And in my Administration Tool, the pencil next to 'View parameters' is not highlighted and when I hover over the pencil a message pops up......

Answers: 1

training

Dynamic query execution
answered 14-11-2019 12:10:40 -0500

Hi Team, I want to execute my query dynamicaly at runtime without creating stored procedure..How can we achieve this in denodo 6.0. Is denodo has any feature or inbuilt function just like 'EXECUTE IMMEDIATE' in oracle so that it implement the result ...

Answers: 1

Denodo 6.0

Getting following error while executing the view
answered 14-11-2019 07:19:40 -0500

Finished with error: Error executing query. Total time 0.545 seconds. P_P_P_RV_SAP_CASHFORECAST3_VENDOROPENITEMS [PROJECTION] [ERROR] P_P_RV_SAP_CASHFORECAST2_VENDOROPENITEMS [VIRTUAL] [ERROR] QUERY: SELECT * FROM p_p_p_rv_sap_cashforecast3_vendorop...

Answers: 1

Create BV with variable
answered 14-11-2019 06:04:52 -0500

Hello: I want to create a BV from a JDBC resource, and I have a csv, with some fields and I want to get the value of the variable from this CSV. the query is select name, address from people where country=@country and I have this CSV: L...

Answers: 1

Base view Interpolation Variables variable

how to use a interpolation variable in where condition of a derived view
answered 14-11-2019 04:46:49 -0500

Hi, I want to to pass a dynamic value as filter in where condition. I am try column1 =@input_value_for_column1 can you suggeset as why its not working, do we need to do anythign else to use interpolation variable or to pass the value dynamic in the w...

Answers: 3

Interpolation Variables

Query two data sources(May be sql server and DB2 ) using Denodo Testing tool.
answered 13-11-2019 13:04:34 -0500

Is it possible to query two different data sources Can i join them in one query and get output? without help of linked server how can i query two different data sources and get single output. Eg Sql and DB2 or salesforces Thank you for help!

Answers: 1

Denodo Testing Tool Database Data sources

what is the node status 'TOO_MANY_WORKS_TIME_OUT found in denodo execution trace server? any idea?
answered 13-11-2019 11:59:55 -0500

what is the node status 'TOO_MANY_WORKS_TIME_OUT found in denodo execution trace server? any idea?

Answers: 1

regexp on a string of data between special characters
answered 13-11-2019 01:36:27 -0500

Hello, I have a data coming to a coloum as following, $kjsfdlesjfdflkdfche$ something. some more text $ornikvempo$ few more text I need to select the column to look as -- something. some more text few more text, basically I want to remove everything...

Answers: 3

Regex