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.

Exception parsing query near 'SCANNER'
answered 26-11-2019 07:15:26 -0500

I tried to deploy the wrapper from ITPilot to VDP. But it failed saying that 'An error was found while performing the operation: Syntax error: Exception parsing query near 'SCANNER''. Can you guys resolve this issue?

Answers: 3

SCANNER

User Access History
answered 25-11-2019 21:00:51 -0500

Hi Team, Denodo 6.0 Does Denodo stores user privilege and role assigning history and which user assigned access ? Through catalog permissions() we can view the recent permissions. But how to find : which user assigned the permission/role to ano...

Answers: 1

Role and User Management

how to use excel microsoft query to do some aggregation function on one denodo views?
answered 25-11-2019 13:10:19 -0500

I have configured 32-bit ODBC, and let my excel connect denodo views. I can pull the data from denodo to excel in detail level, how do I use microsoft query to do some aggregation caculation on some view. For example, denodo view_a (contain column mont...

Answers: 3

excel

Access interface in vdp connections file.
answered 25-11-2019 13:10:10 -0500

Hi Team, In "vdp-connections.log" file from Denodo Monitor. What could be the possible values for "AccessInterface: Type of access interface of the connection". ? I am intersted to know if "VDP" here would mean "Scheduler" Job. ? Please tell. Thanks.

Answers: 5

vdp connections file

Shell script Schedule
answered 25-11-2019 06:39:16 -0500

Team, We have installed Denodo 6.0 in our Unix environment. We would like to execute one shell script(rename.sh) file through scheduler before our actual denodo job start. Can we execute shell script through denodo scheduler?? Thanks Dp

Answers: 6

Job scheduler Denodo Scheduler 6.0

Denodo's Data Catalog's Capability
answered 22-11-2019 16:42:51 -0500

Can we search for the content in a PDF file by using Denodo? I tried to convert a PDF to HTML by using ITPilot and deployed it to Virtual DataPort, but still, I can only search for the column name and the file name under Data Catalog.

Answers: 1

data catalog

Denodo Pushdown
answered 22-11-2019 14:50:57 -0500

We are using Denodo version 7.0 and Netezza 7.0 Database to procure data. We have configured some of the data in cache and cache DB is also defined in the same Netezza sever as the DB from which we are fetching records. But Denodo instead of performin...

Answers: 1

http://localhost:8080/billing/services
answered 22-11-2019 08:26:09 -0500

Working my way through the tutorial. I could access this webservice but now I am getting an error: This site can’t be reached localhost refused to connect Anybody an idea why connection is now being refused when I could access it the last time I tri...

Answers: 1

SOAP Web Service

Not able to view Denodo Learnings
answered 22-11-2019 08:19:52 -0500

Hi Denodo Team, I am not able to see the below learnings/Training in my Learning dashboard. Data Virtualization Developer Introduction Data Virtualization Developer Basics - On-demand Advanced Data Virtualization Developer - On-demand Coul...

Answers: 1

Subtracting a no from a date DATEDIFF(dd,0,b.pymt_run)
answered 21-11-2019 16:05:22 -0500

Can you please help me to convert following statement in denodo DATEADD(dd, CASE WHEN DATEDIFF(dd,0,b.pymt_run)%7 > 4 THEN 7-DATEDIFF(dd,0,b.pymt_run)%7 ELSE 0 END,b.pymt_run) as fin_pymt_run Here b.pymt_run is of date datatype. Thank you!

Answers: 3

#date #datedifference