Home / Q&A / All Questions

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 September 2019.

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.

JDBC Connection to SQL Server Express - URI
answered 29-04-2019 19:00:03 -0400

Running Denodo Express VDP on my laptop. Got SQL Express installed and loaded with AdventureWorks DW 2014 data. What would be the URI if this is the case? I am trying to connect via JDBC using the following URI: jdbc:jtds:sqlserver://IA-EME/SQLEXPRESS...

Answers: 3

SQL Server

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 JSON
answered 24-04-2019 17:22:22 -0400

Hi Team, Denodo Express 7.0 Please provide a working URL and supporting data for a JSON HTTP client example to practice. This does not work : http://data-server:8080/sales-ws/sales/ Thanks.

Answers: 1

JSON HTTP client