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 April 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

Additional trace settings
answered 17-12-2018 04:03:54 -0500

To see the LDAP search query the following trace setting should also be applied call logcontroller('com.denodo.vdb.engine.wrapper.raw.ldap.executor.LDAPExecutor', 'trace');

Answers: 1
Related to: LDAP authentication best practices

ReadyAPI JDBC connection to denodo: java.sql.SQLException: connection error: no such object in table
answered 17-12-2018 04:03:43 -0500

I am trying to do a JDBC connection from ReadyAPI, I get the follwing error connection String -> jdbc:vdb://<HOST:127.0.0.1>:<PORT:9997>/<DB>?user=<USER >&password=<PASSWORD>; error: Fri Dec 07 11:07:18 CST 201...

Answers: 6

java.sql.SQLException

Write-back scenarios
answered 17-12-2018 03:55:17 -0500

Hi, I would like to get some information about write-back scenarios. Do you have any information about this topic? Thank you!

Answers: 1

Write-back scenarios

ITPilot Wrapper Sequence Generator 7.0 runs in Protected Mode in IE
answered 17-12-2018 00:10:43 -0500

I just started experimenting with ITPilot, and creating sequnces using the IE-based Sequence Generator, and noticed that all files saved/loaded are "sandboxed" to a virtulaized file path due to IE running in Protected Mode. So files I save to "C:\User...

Answers: 1

ITPILOT

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