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 avoid time zone conversion in Denodo ?
answered 16-12-2018 21:58:51 -0500

Hi, Is there a way we can avoid any implicit timezone conversion in Denodo ? We have a column in a table which house datetime from different regions of US along with an additional Flag column which tells us about the time zone of the row. In this scena...

Answers: 3

High DPI display and Windows 7
answered 14-12-2018 15:56:45 -0500

Hi, I am using Denodo 7 vdpadmin on a Windows 7 machine with a 4K display. The application is displayed unscaled and too tiny. I tried both configuration settings in https://community.denodo.com/docs/html/browse/7.0/platform/installation/appendix/laun...

Answers: 1

Power Query parameters not working when cache is on
answered 14-12-2018 13:01:38 -0500

Hi - I have a view with 1 parameter that I am consuming in Excel through ODBC. I cannot pass the parameter back to Denodo unless the cache is turned off of the view. Is there any solutions for this?

Answers: 1

Power BI Cache

Is there any option to automate, columns and tables from different sources to get a unified schema.
answered 14-12-2018 09:52:16 -0500

I am having sources from different databases i.e sql, oracle and flatfiles. Is there any way i can automate, to find a mapping between the source tables and columns ?

Answers: 1

How to connect Denodo with HDFS?
answered 14-12-2018 07:29:15 -0500

Hi. Does anyone know what is the best way to connect Denodo with HDFS? I cannot find any article or how-to about this topic. I added data sources like Oracle and MySQL databases, Hive. But I need to connect to HDFS.

Answers: 1

DENODO Hadoop HDFS

Start and End Cell Behavior in DenExp 7.0
answered 14-12-2018 07:28:48 -0500

Hi Team, Denodo 7.0 Express MS Excel 2010 Format .xlsx Id Name Age City 1 ABC London 2 PQR 20 Sydney 3 LMN 30 Munich 4 XYZ 40 Paris If I chose Start Cell as B1 and End Cell as D4. I get below result: Name Age ABCPQR 20LMN 30 XYZ 40 Why is city colu...

Answers: 1

Excel

SQL Server recursive query
answered 14-12-2018 05:42:20 -0500

According to https://community.denodo.com/answers/question/details?questionId=90670000000XcjoAAC&title=Can+denodo+Support+to+recursive+queries+%3F Denodo doesn't support recursive query directly. I am trying to create a base view through the method...

Answers: 1

recursive query SQL Server

CATALOG_VIEWS() giving wrong results in Localhost
answered 14-12-2018 03:42:40 -0500

Hi All, I am trying to use CATALOG_VIEWS() to get the list of modified views on a perticular day. Upon the servers, its working fine and giving me the correct results, but in localhost the same query with CATALOG_VIEWS() is giving all the existing vie...

Answers: 1

CATALOG_VIEWS() Local

Denodo4E Error - VDBConfiguration.properties Missing
answered 13-12-2018 18:10:58 -0500

Hi, I am trying to build a stored procedure and am following the tutorial for Denodo4E, but when I go to debug the VDP-ITP-Server I get an error stating: "The system cannot find the file specified Denodo Platform\conf\vdp\VDBConfiguration.properties (T...

Answers: 1

Denodo 6.0 Denodo4E

How to limit the log file retention or disk space usage for the Denodo Monitor logs?
answered 13-12-2018 07:47:28 -0500

Hello I am aware that the monitor is configured with: conf/ConfigurationParameters.properties however, normally the VDP logs are configures in a log4j config file, but for the monitor I could not find this log4j config file. So my question is: how ca...

Answers: 1