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.

Optimization in denodo
answered 17-05-2019 21:20:26 -0400

Is there any option in denodo like SQL developer (Query optimizer option) if I supply an sql ,denodo will be showing the areas of improvement for that sql on areas of performance . For example if the query is a taking a specific plan and if the same qu...

Answers: 1

REGEXP_REPLACE function is not working
answered 17-05-2019 21:19:37 -0400

Hi , I am facing an issue while using an REGEXP_REPLACE function in order to remove the special characters of a value for a specified column. Below is the query we are using and the error Query : SELECT cstone_feed_key, cstone_last_updatetm, fin_card...

Answers: 3

Union all fails and REST service corrupts
answered 17-05-2019 21:18:13 -0400

I am trying to union all my connection result form 5 different source sources. I am exporting the union result as REST service. if one data source fails the error message in the result corrupt the whole xml which result in crashing whole system. how ...

Answers: 1

Union all

Error on generated SQL query
answered 17-05-2019 15:44:03 -0400

Hello, I'm using Denodo Express against a MariaDB database. When I execute the view, the have a syntax error because the SQL statement is not well generated. Expected SQL : SELECT id, Order_Id, Client_Id, Product_Id, Date, Qty, amount FROM test.orders...

Answers: 2
Related to: Getting the SQL query delegated by a derived view

Business Objects Universe Insert Table Issue
answered 17-05-2019 07:49:20 -0400

We recently got Business Objects Universe and Information Designer (Version V4.2) to connect with VDP (Version 7) using JDBC. However we are having issues with inserting tables with "_" as part of the object name. Objects such ZIP will have the columns...

Answers: 1

Which User is used when Denodo is configured to use Git as VCS.
answered 16-05-2019 18:22:02 -0400

Denodo 7.0 What does the bolded part of this sentence mean: "This means that user credentials specified in the Denodo Platform Git wizard will be ignored and the authentication will be done using the operating system user which is executing the Den...

Answers: 4
Related to: How to configure Git on TFS for Denodo VCS

VCS

GridGain
answered 16-05-2019 13:04:33 -0400

Hi, I'm trying to connect gridgain to denodo to use it as a cache but at the moment I'm going to save myself from this error: "Operation completed with errors: Error saving cache settings: error updating data source: null". Has anyone tried to use grid...

Answers: 1

GridGain In-memory datagrid

How to read data from pdf
answered 16-05-2019 13:02:21 -0400

My requirement is to read data from PDF file which is in local computer and load into a csv file in Denodo 7.0 Really appreciate your help in this.

Answers: 1

VCS is configured, but cannot associate a commit with an environment - How do I do that?
answered 15-05-2019 18:12:25 -0400

Denodo 7.0 I managed to get VCS configured. Now that I have it configured, I cannot commit objects because I get the error that: "No environment is selected, select an environment". There is no ability to select an environment in the dialog. Any ideas?

Answers: 1

Listing Committed Elements
answered 15-05-2019 18:10:21 -0400

Is it possible to get a list of what has been VCS committed? I see there is a number listed of items that has been committed and pending a push, but how to find out what they are?

Answers: 3

github vcs commit