Q&A

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

Getting alert "The VDP Server and the Administration Tool have different updates" whenever I try to login to Denodo Server from the local client
answered 03-07-2018 12:12:31 -0400

I am using Denodo Virtual DataPort Version 6.0. Whenever I login to Denodo Server from my local machine. I get following alert -"The VDP Server and the Administration Tool have different updates: VDP Server: 6.0.201800216 Administration Tool: " Could ...

Answers: 1

VDP alert Administration Tool