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.

Restful Webservice - page not found
answered 23-03-2017 02:19:27 -0400

Hi When I browse to the default restful webservice ( http://[server]:9090/denodo-restfulws/[database]/views/[viewname] I get a page error: The page you requested was not found. The page may no longer exist, or you may have typed the URL incorrectly. ...

Answers: 2

Some text fields are presented as null, although they contain value
answered 23-03-2017 00:40:11 -0400

The fields are imported as text type, which is, as I believe, the right way to do so. However, due to some reason, they return null to Denodo, although they contain value in the driver. Probably it is some limit Denodo puts over the data, or some mista...

Answers: 1

datasource fields text

Aracne crawler proxy configuration
answered 22-03-2017 09:30:17 -0400

Hello, I am curious to know more about the proxy configuration settings of the Aracne crawler. I can see some information there on the Aracne administration guide, but it doesn't talk much about the need of it. I understand the use of proxy settings i...

Answers: 1

proxy crawler Aracne

Question regarding join mechanism
answered 22-03-2017 09:18:46 -0400

When a VQL is being run, Denodo creates sub VQL queries in order to send them to different data sources according to the execution plan. while doing that it creates a query like select t0."time" as time automatically. However, while there is some kin...

Answers: 1

joins vql

Run the Import.sh script without implicitly stating the Username and Password
answered 22-03-2017 08:03:28 -0400

I am calling the "import.sh" script inside a Linux (bash) shell script. In normal circumstances we supply the username and password as part of the parameters (the USERNAME and PASSWD values) import.sh -su -f $VQL_FILE_HOME/$FN_NAME.vql -pf $CONFIG_FIL...

Answers: 1

import vql import

Error while trying to gather stats
answered 21-03-2017 11:42:39 -0400

I keep getting error, on any jdbc while trying to gather stats manually. I am getting the error : Error executing query. total time ... Query [VIRTUAL] [ERROR] when looking into the logs, I get : com.denodo.vdb.engine.storedprocedure.jdbc.QueryResultS...

Answers: 2

Statistics

Automated deployment - Code promotion using TFS2015
answered 21-03-2017 10:41:00 -0400

We would like to auto-deploy our Denodo code between different enviornments using TFS2015. Has anyone done the following for deployment using TFS 2015 1) Downloading the latest database artifacts fron TFS 2) Creating the export script 3) Importing the ...

Answers: 2

deploy

Denodo integrate with Git
answered 21-03-2017 10:18:56 -0400

Hi, Is there any documentation on how to integrate Git with Denodo platform? Thanks.

Answers: 1

Using VDP Exporting a WebService using only specific Web service resources produces no Properties file
answered 21-03-2017 09:36:21 -0400

Using the VDP tool, when I attempt to export a Web Service and I want to export only specific Web service resources of that Web Service --> a Properties file is not being created. However in the VQL that is generated, I get the Header line stating: ...

Answers: 1

export Web Service

How to export VQL from one instance of Denodo to another instance of Denodo automatically or using some script?
answered 21-03-2017 08:45:40 -0400

We have 2 instances of Denodo (say Dev and QA). Is there a way to deploy the VQLs from Dev environment to QA environment automatically or using some scripts?

Answers: 1

automation deploy