Q&A

Unable to connect Salesforce using DENODO
answered 29-04-2019 18:08:43 -0400

Dear Team, I am unable to connect sfdc connection via denodo. I have attached the screenshot ..could someone please help me.... error message like "INVALID SESSION"

Answers: 1

sales force connection salesforce oauth

Connect to Denodo using NodeJS
answered 26-04-2019 19:07:38 -0400

Hi Team, I want to establish a connection between Denodo and NodeJS. I want to run Query from Javascript level. I am trying with node JDBC, but not able to coonect with denodo. Is there any possible way to connect to denodo. I am Working in Javascript...

Answers: 1

NEO4J / JDBC / Connection

Denodo Solution Manager Monitoring Tool - java.sql.SQLException: Incorrect syntax near ')'.
answered 25-04-2019 18:49:11 -0400

I am in process of setting up the Denodo Solution Manager Monitoring Tool. After much pain in getting the connection string sorted out, I now get the following error in the solution-manager.log: 501926880 [Thread-90] ERROR 2019-04-24T15:31:53.363 com....

Answers: 1

Unable to connect to VDP server running on AWS with Admin tool on personal machine
answered 25-04-2019 16:26:07 -0400

As you suggested in my earlier question, I made the following checks before I tried to connect to Denodo server running on AWS from VDP admin tool on local computer. This time I am connecting to Denodo 7.0 enterprise edition installed on AWS. The Deno...

Answers: 1

Unable to use the analytic function in Denodo-VDP
answered 25-04-2019 09:12:14 -0400

Hi, I am trying to use the analytic function in my derived view in VDP. but it did not recognize the functions and getting errors. (tried all the analtic functions , I got the same errror.. see attached the error detail hyperlink) rank() OVER (PARTITI...

Answers: 4

#Analytic function

Redshift Spectrum table
answered 24-04-2019 18:13:27 -0400

Hi Denodo Team, We have configured redshift and everything working fine for redshift tables. however having issues with Redshift Spectrum tables. for Spectrum we see the schema name and if I hit Plus sign it returns nothing. we have many tables under ...

Answers: 1
Related to: How to connect to Amazon Redshift from Denodo

XML Data Source : Character reference "&#xB" is an invalid XML character.
answered 24-04-2019 18:09:45 -0400

Hi, I'm using v7.0 20181011. Attemting to create a base view from an XML data source, I'm getting the error "Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Character reference "" is an invalid XML character....

Answers: 1

XML XML Data Source

Schema change and Source Refresh with Denodo and Cache store
answered 24-04-2019 17:23:09 -0400

Hello, We have snowflake as our cache store. When we add a new column to source, our cache refresh jobs fails with "Number of columns in file (25) does not match that of the corresponding table (23),". Any process we ned to follow to update cache schem...

Answers: 1

Source refresh schema change Cache Cache error

HTTP client
answered 24-04-2019 13:38:18 -0400

Hi Team, Denodo Express 7.0 Please provide a working URL and supporting data for a MS Excel HTTP client example to practice. Thanks.

Answers: 3

Excel HTTP client

JARS Export
answered 23-04-2019 21:28:36 -0400

Hi Team, Is there any option to export jars alone in denodo 5.5 Version. If it so could you please share us the steps to do

Answers: 1