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.

ODBC Timeout.
answered 09-03-2018 06:19:52 -0500

I created a ODBC connection DSN to Denodo, using the Denodo ODBC driver, that is using a long running query. I had the timeout set and eventhough the query was still returning data, the connection timedout according to the setting. That is not the beha...

Answers: 1

ODBC

JDBC Connection Query "select 1"
answered 09-03-2018 06:16:49 -0500

We have some webservices setup to hit Hadoop Impala's JDBC connection. We are seeing "select 1" queries every minute for each of the webservices that we have setup. Is there a way to change the frequency of these queries (they are being fired off every...

Answers: 1

Denodo 6.0 JDBC

Alias name of view is something different
answered 09-03-2018 05:36:48 -0500

Hi Team, I have view in DB as DND_PRODUCER_SUMMARY_VW, just importing into Denodo, while importing, I changed capital name into small letters as "ud_producer_summary_vw' but when i see VQL for this base view. I am getting as below, my question is why a...

Answers: 1

Lookup - Informatica PowerCenter
answered 09-03-2018 05:31:32 -0500

I hear regular complaints from my ETL team that Denodo Views selected as lookup is not performing well, they had to move it as source qualifier. Do you have any recomendataions on this before i get more details from my team.

Answers: 1

lookup DENODO Informatica

Meaning of the join arrow's direction in a join view
answered 08-03-2018 08:11:48 -0500

When joining two or more views (as source) together in a join view, Denodo will draw an arrow between the tables. The arrow's direction seems to depend on how you "draw" the line, i.e. from which table you start. Is there any "deeper" meaning to this ...

Answers: 1

join

ER Tool integration
answered 08-03-2018 07:41:41 -0500

We use SAP Power Designer for our logical data modelling. It is possible to populate the VDP definitions from external metadata e.g. definitions of data sources, joing views etc?

Answers: 1

logical models

Denodo 6: VDP tool Connection error: Connection Refused
answered 07-03-2018 11:01:26 -0500

Hi I'm getting connection refused error while trying to login to VDP Client //localhost:9999/admin. I've confirmed that the port is open, vql server is also started (started from the client and from execution on .vqlserver.sh. Please let me know wha...

Answers: 1

Error when using LIKE operator: URLDecoder: Illegal hex characters in escape (%) pattern
answered 07-03-2018 05:26:20 -0500

Hello, I am running into an issue when using the LIKE operator on my webservice. In order to make the like more effective, I have added a percent sign before and after the text I want to search on. This way I can bring back results that have my text a...

Answers: 4

REST search Like Filter encoding URL Web Service

How to update Licence Key File on Linux
answered 07-03-2018 02:56:43 -0500

Hi Experts , Can you please guide me , how to update Lincence Key file on Linux Server ? Regards, Ganesh T

Answers: 4

update

Is Kerberos necessary?
answered 06-03-2018 07:39:32 -0500

Hi Is it possible to have a pass-through session with JDBC or ODBC without using Kerberos?

Answers: 1
Related to: How to set up SSO with pass-through for ODBC connections to Denodo