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.

Is it a Denodo bug when publish a parent-child view to a xml restful service
answered 06-07-2018 17:11:27 -0400

Hello I combine two views into a parent-child view and publish it to a xml service, like fund_code_list ->fund_price_items. However, I do not find the fund_code_list element in the xml result. Could you please help on it?

Answers: 1

REST API

Unable to establish connection: IO Error: Connection reset
answered 06-07-2018 12:04:19 -0400

Hi Team, While we are doing test connection from Denodo to Db(Orcale) its giving error Unable to establish connection: IO Error: Connection reset. we are using database adapter Orcale 12c and driver class path is oracle.jdbc.OracleDriver. this is for ...

Answers: 1

restful web service . 404 page not found
answered 06-07-2018 03:40:55 -0400

Hi Team, Denodo 7.0 Denodo Home is in G: Drive. Works fine - http://localhost:9090/server/<db_name_here>/<webservice_name_here>/views/<view_name_here> Problem - 404. page not found http://localhost:9090/denodo-restfulws/<db_nam...

Answers: 2

REST REST Webservice

using import from repository and properties file
answered 06-07-2018 03:05:39 -0400

i would like to use the import script command with the -r and -f options such that I have a vql file generated from the source control repository. the only other thing that is missing is the properties file. I would like to be able to execute the vql f...

Answers: 1

import

How to execute a dynamic sql or a stored procedure for a view?
answered 05-07-2018 13:02:27 -0400

Hi, I used to create a stored procedure in cisco information server(CIS) to produce dynamic sql query. For example, few input params for query columns. However, I am told that I need to wrtie Java code for stored procedure in Denodo. Is it ture? I am ...

Answers: 3

Quary execution Stored Procedure

SSL Configuration: Self-Signed vs Public CA Certs
answered 05-07-2018 12:29:54 -0400

I wanted to see how the community is configuring SSL. Specifically, does it simplify SSL setup and deployment to avoid using self-singed certs and go with one of the main Public CA authorities? To be honest, we ran into several issues trying to lever...

Answers: 1

Self-Service SSL DVP

Connecting to SOAP service using SOAP licenceKey
answered 05-07-2018 08:48:56 -0400

Hi, We need to connect to SOAP service and the vendor of the service has shared LicenceKey with us. I can easily connect to it using SOAPUI tool. The responses recieved from SOAP via SOAPUI is what we expect.However, I'm struggling to connect to the ...

Answers: 1

licenceKey SOAP

Presto data source query issue
answered 05-07-2018 07:20:56 -0400

Using Version 6 of Denodo I am using the Simba Presto driver to connect to a Hive database on AWS. The Hive metadata store is on a MySQL database. I am able to connect to the database and see the Schemas and their respective tables. When I try to creat...

Answers: 5

Presto JDBC

Denodo Scheduler doesn't act on dependency
answered 04-07-2018 12:15:35 -0400

I have set dependency for a scheduler cache update job on previous job. To test i have manually started both jobs simultaneously the first job is still in running state and the second job (which is dependent on first job) just completed with zero resul...

Answers: 3

Getting the wrong query for external web service
answered 03-07-2018 12:47:46 -0400

I am a denodo newbee. I am trying to use OpenWeatherMap.org's web service interface to pull temperature data from a certain time and location and put it into a Denodo table. I can get Denodo to create the SQL to make the call, but it is using the wron...

Answers: 1

Connecting to an external web service