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 April 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

Operational downtime Alerts in Denodo
answered 12-01-2018 07:19:01 -0500

Team , Whenever the server on which Denodo is installed is down or under maintance , Denodo needs to be restarted manually after maintance is done. While we are working on the workaround to get this automated , is there any other way to alert throug...

Answers: 1

GDPR and Denodo integration with IBM IGC
answered 12-01-2018 05:25:07 -0500

Hello Technical Team, I am working at Client site who has Denodo, Considering GDPR coming up in May 2018, will new version 7 , provide Integration to IBM Information Governance Catalog (IGC). This will very important question for us to get the metadata...

Answers: 1

JDBC for ServiceNow
answered 12-01-2018 04:55:45 -0500

Hi I am using Denodo version 6 and want to connect to ServiceNow to extract via JDBC Any idea how ? Thanks

Answers: 1

Cognos Data Server import metadata throws null pointer
answered 11-01-2018 19:20:12 -0500

Trying to connect Cognos via Data Server to Denodo v6. Part of the steps to make a Cognos Data Server connection function is to import the metadata, which in turn then a Data Module can access. We are seeing this null pointer from the JDBC stack. Anyo...

Answers: 1

Cognos

Cognos + Denodo + Framework Manager
answered 11-01-2018 12:13:01 -0500

This article is great if you are using Cognos' limited Data Module ability. Is it possible to hook up Cognos to Denodo via Data Source and a Framework Manager model?

Answers: 1
Related to: Connecting to Denodo from Cognos

Cognos

TIMESTAMPDIFF
answered 11-01-2018 07:05:44 -0500

Team, How can we convert TIMESTAMPDIFF function. Eg:- TIMESTAMPDIFF(SQL_TSI_DAY, Date1,Date2) Can you please let me know in case of any idea on this ?

Answers: 1

WHERE Clause in query
answered 10-01-2018 14:12:41 -0500

I have created dervied view's using Baseview views and query also has an where clause at the end on one the Base view. When I run the new derived view the where condition is executed at the end. I dont see this helping peformance. please let me know, I...

Answers: 1

query plan Sql performance WHERE CONDITIONS

Performance Bench Marks
answered 10-01-2018 09:27:29 -0500

I'm currently seeing performance issues when we run quiries extracting data from tables with multimilliion records. The data movement is slow and cpu consumption is quite high during the query execution. As a first step, I would like to compare it to t...

Answers: 1

performance Bulk Data Load Sql performance

REGEXP_LIKE function in a Scheduler query
answered 09-01-2018 08:35:06 -0500

Hello, I am trying to create a job in Scheduler, by putting a REGEXPLIKE function in the sql. The query which works in Oracle is: SELECT FROM mytable WHERE REGEXPLIKE (referer,'^https?://[a-z6.]{0,9}.?google[a-z]{0,11}.[a-z]','i')* But this quer...

Answers: 2

REGEXP_LIKE

Virtual Data Marts
answered 09-01-2018 07:35:44 -0500

Can you give an idea on how virtual data marts can be implemented from Denodo? 1.For existing physical data marts. 2.For developing from scratch within denodo.

Answers: 1