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

Admin Credential Issue - Denodo Express
answered 25-04-2016 18:02:43 -0400

Hello, I downloaded Denodo Express v6.0 Windows 64 bit today. I installed it on one of our dev servers running windows 7 SP1. I started the Denodo Platform Control Center. I then tried to "Launch" the Virtual DataPort Administration Tool. It asks f...

Answers: 1

Migrate only users and roles.
answered 25-04-2016 04:42:25 -0400

I want to create a script which have only create commands for all the users and roles for that database or server.So that same users and roles can be created in different server using those commands .Please let me now if any one have other solution to ...

Answers: 1

EXTRACT
answered 22-04-2016 21:22:48 -0400

We are using EXTRACT function in Denodo for our Redshift connection because TRUC causes some very strange issues (server used up 9GB of data in like 3 minutes... I will open a real ticket for that one separately)... and EXTRACT works nicely to get the ...

Answers: 3

functions

creating a base view generates a timeout message
answered 21-04-2016 16:15:10 -0400

513395338 [AWT-EventQueue-0] ERROR 2016-04-20T14:11:38.518 com.denodo.vdb.admin.gui.frame.states.normal.tools.datasources.actions.CreateBaseViewAction - Unable to create base view java.util.concurrent.ExecutionException: com.denodo.util.exceptions.I...

Answers: 2

insufficient resources whire creating base view

ADDMONTH delegation for Redshift
answered 20-04-2016 19:13:57 -0400

Hi all Having two small issues with redshift: 1. ADDMONTH (or really any date type function) is not delegating to the source. So I get good results back, but in redshift its just selecting all the available fields.. its still quick but there is a lot...

Answers: 3

redshift

How to connect Big data through denodo platform Express version 6.0
answered 20-04-2016 18:20:57 -0400

Hi , I have downloaded the latest version of Denodo platform 6.0 . I checked all the manuals , but could not find the how to connect to Big data Hadoop . Could you please let me know which data sources we have to use to connect to Big Data.

Answers: 1

Download New Version of Express for Proof of Concept
answered 20-04-2016 16:37:46 -0400

Hello, I had downloaded version 5.5 around 3/18/16. I have not had time to install and play with it. I see that you now have 6.0 out. I have a few questions: 1. I am wonder if I can download 6.0 or do you folks need to reset my user to allow me to ...

Answers: 1

Is it possible to have the DEBUG messages from com.denodo.vdb.management.mbeans.request.RequestsManagementInfo logged to multiple files?
answered 20-04-2016 10:48:46 -0400

Hello, I was trying to configure the $DENODO_HOME/conf/vdp/log4j.xml file such that I left all the defaults, but added a configuration to log DEBUG messages from com.denodo.vdb.management.mbeans.request.RequestsManagementInfo in a separate file using ...

Answers: 3

connection error
answered 18-04-2016 19:11:35 -0400

I am evaluating express 6.0. On the VDP admin screen, I enter login admin and password admin. It fails to connect. I get the message below. 60399080 [AWT-EventQueue-0] ERROR 2016-04-14T08:39:44.370 com.denodo.vdb.admin.gui.components.connection.Connec...

Answers: 1

vdp timeout

Show tables with data type
answered 18-04-2016 18:17:38 -0400

Hi there, Are there any SP's native to Denodo which would give me the name of an object, the type (base view, etc...) and the data type of the table, similar to how sys.columns works for MSSQL Server? I fired off the Catalog_Views SP, but don't see al...

Answers: 2

Stored Procedures