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 November 2018.

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.

Denodo data catalog Internal Database Configuration Missing
answered 23-10-2019 05:54:09 -0400

Hi Team, I am not able to find the internal database configuration option denodo after login as admin. I have full privliagesto setup one.I want to configure mysql Please help me

Answers: 1

Denodo Internal Database Configuration

Microsoft Query (Excel) not Compatible to Denodo Query
asked 23-10-2019 05:44:22 -0400

Hi team, I used excel to connect denodo for views data visualization, I follow this link: https://community.denodo.com/tutorials/browse/basics/4connect2odbcclient . And it works. However, when I want to do some advanced query, not only get the detail...

Answers: 0

double quote Excel single quote Microsoft Query

Denodo Data Catalog option to configure internal database missing
asked 22-10-2019 16:25:09 -0400

I have Denodo installed on my local machine and a remote machine, and I am trying to configure the one on the remote machine so that I can hookup my own database to store the metadata. I found the way to do it, but that way is for some reason only avai...

Answers: 0

data catalog

Base View date field is populating incorrect format
asked 22-10-2019 15:16:24 -0400

Hello, We have a base view that is populating a date field incorrectly. The date field should be populated under the format of date time with the time being zeros (example Tue Jul 29 00:00:00 EDT 1947) , however for a number of recrods we are seeing Tu...

Answers: 0

datetime locale date field

how to use excel microsoft query to do some aggregation function on one denodo views?
asked 22-10-2019 11:47:31 -0400

I have configured 32-bit ODBC, and let my excel connect denodo views. I can pull the data from denodo to excel in detail level, how do I use microsoft query to do some aggregation caculation on some view. For example, denodo view_a (contain column mont...

Answers: 0

excel

Denodo Essential Exams Locked
answered 22-10-2019 09:25:17 -0400

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: 2

Query Simplification
answered 22-10-2019 09:05:11 -0400

Hello, I have a scenario where I need to "Simply a Query" based on selection. For example I have two base views, first one named "bv_first_view" (with field names - id, name, age, address) , second base view named "bv_second_view" (with field names - ...

Answers: 4

DB2 Query Simplification

Denodo Scheduler
answered 22-10-2019 04:37:02 -0400

Hi to everyone, I have two question about Denodo Scheduler. The first one is: how can I kill a Scheduler process when the stop button doesn’t work? I tell you my case: I have created a VDP Job with a JDBC exporter and the extraction was in contrast...

Answers: 2

Denodo Scheduler 7.0 scai finance

why the SQL's execution time is slower in Denodo than the time in Oracle?
asked 22-10-2019 02:59:21 -0400

Hi support team, We have a VQL which execution time is more than 10 seconds in VQL shell, while it's generated native SQL can be run in Oracle client in only 3 to 4 seconds. In VQL shell, the "Execution Trace" shows "Virtual Plan" takes more than 1...

Answers: 0

denodo data catalog
answered 22-10-2019 00:24:11 -0400

Hi team, We are getting 404 error while accessing denodo catalog after our installation. we enabled ssl and also found below error sudo /opt/denodo/bin/datacatalog_startup.sh Starting Web Container... Oct 21, 2019 5:08:20 PM ClientCommunicatorAdmin ...

Answers: 1

data catalog