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.

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

Denodo data catalog description version
answered 12-11-2019 18:58:01 -0500

Hi Team, Is it possible to multiple version of description for a view in Data catalog Can we create/ set a owner for the views simirar to ms word properties( Author, created date etc) THanks Balu S

Answers: 1

Denodo data catalog

Solution Manager VCS integration - rollback granularity
answered 12-11-2019 03:07:42 -0500

Hello! We are on version 7.0.20190903 and are trying to better understand the rollback capabilites of Solution Manager deployments when VCS is configured. The documentation says: "The Solution Manager also allows to do a rollback after a failed deploym...

Answers: 3

#solutionmanager

Denodo Essential Exams Locked
answered 12-11-2019 02:32:54 -0500

Hi, I have completed various Denodo Essentials - on demand courses. All of my exams are locked. Can you please release them as I still have access to the courses for few more days.

Answers: 3

Creating an empty file
answered 11-11-2019 19:05:10 -0500

We have a requirement to generate an output csv file when there is data in the source file and also an empty csv output file for empty source file. The output file of the source file containing data follows a naming convention and the output file of an...

Answers: 1

Password not set for Password Based Encryptor error in Jenkins job
answered 11-11-2019 19:02:54 -0500

Hi Team I am facing below issue when i am calling denodo testing tool - TestRunner.Run method from my Junit Testing framework via Jenkins Job. Interestingly, Tests are running fine when i am running via command line through maven commands on the same ...

Answers: 1

#Denodo #denodotestingtool #testingtool #denodo

Data source connection change history
answered 11-11-2019 18:18:21 -0500

Hi Team, Denodo 6.0 | JDBC Data Sources If data source URI is changed, in which file is this information logged ? Can this file be read in Denodo, and possibly to trigger an alert when data source connection is updated. Does the file has histo...

Answers: 1

data source