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

ODBC DS in Denodo retruning <null> in display
answered 17-12-2018 06:33:21 -0500

Hi Team, Denodo Express 7.0 MySQL 5 Community Server MySQL 5 Work Bench MySQL 5 and 8 ODBC Driver System and User DSN for both 5 and 8 (Unicode) In Denodo ODBC Data Source - connection succesful Base View - created Query on base view - runs successfu...

Answers: 1

Source change
answered 17-12-2018 04:39:03 -0500

Hi I have vew "V" having 4 tables currently pointing to mysql , Now my requirement is out 4 tables 2 tables pointing to mysql and 2 pointing to MongoDB , is their any way in denodo we can change only source tables and build same view, instead of rebu...

Answers: 1

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 -&gt; jdbc:vdb://&lt;HOST:127.0.0.1&gt;:&lt;PORT:9997&gt;/&lt;DB&gt;?user=&lt;USER &gt;&amp;password=&lt;PASSWORD&gt;; 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