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

unable to delect dropdown list in itpilot
answered 20-08-2018 19:27:41 -0400

Hi i am working with itpilot and not able to select option from drop down list. How to do that any steps to achieve the same will be very helpful.

Answers: 1

ITPILOT

Date Format Transformation Pass Through Query in SAS
answered 20-08-2018 13:22:11 -0400

Hello, I have created a query in SAS that passes through Denodo via odbc connection (uses VQL syntax). My input date (effdate) is numeric with a length of 8 and looks like 20180815. I have tried numerous ways of converting it to a date. No matter what...

Answers: 2

Date Conversion TO_DATE TO_DATE function Date

DEN60EDU0104LAB04 - Create ds_support_site data source and import all procedures
asked 20-08-2018 11:00:37 -0400

Hi, I have found myself stuck on this lab. Specifically: “ds_support_site” data source, create two base views over the stored procedures included in the PKG_SUPPORT_DB package: I ran the SQL script that was given in SQL developer, but I did not see a ...

Answers: 0

ondemand

Denodo Notebook feature
answered 20-08-2018 10:11:24 -0400

I saw Denodo has Notebook feature which are similar to Apache Zeppelin and Jupyter; however, I'm not able to get any information while trying to google it. Can someone tell me if this is only new in version 7 or we can use in version 6 and where I can ...

Answers: 2

ERROR message 'Error parsing response'
answered 20-08-2018 09:50:05 -0400

Hello, I am receiving the error below when I run a vql script. What I am having trouble understanding is that when I add one additional criteria to call for a specific record the script comopletes fine with no errors. Any assistance on how I can resolv...

Answers: 3

Error parsing response

Version of the export script that could work standalone (outside of full VDP platform)
asked 20-08-2018 09:03:06 -0400

Hello, For CI/CD and automated migration from one environment to another, we are wondering if there is a (lightweight) standalone version of the export script included in the Denodo platform\bin folder?

Answers: 0

Denodo support for something like SQL EXECUTE AS function?
answered 20-08-2018 08:39:16 -0400

Hello, Does Denodo support some kind of impersonation feature like EXECUTE AS in SQL Server? This would allow a functional user to execute a query on behalf of another user. If Denodo doesn't support it through this kind of statement, does Denodo su...

Answers: 2

ITPilot case function doesn't work fine
asked 20-08-2018 07:47:53 -0400

Hi! I am working with ITPilot wrapper trying to process output record and create a new field with into a value editor. I have a field date as string and I try to format with two patterns (with and without hours) case max(indexof(Iterator_1_output.dat...

Answers: 0

ITPILOT CASE

Custom Function: Change QueryContext?
asked 20-08-2018 07:46:56 -0400

Hello, In the Denodo Custom Elements reference API there is a function to get the QueryContext. CustomElementsUtil.getQueryContext() This QueryContext object allows to retrieve the user, roles and database etc. However if I want to change the user...

Answers: 0

Performance issues in Data loading
answered 20-08-2018 01:25:58 -0400

Hi Team, We have a one job in Denodo Prod Region and data was loading into Cache DB, earlier it was taking very less than 10 min time, but now its taking more than 2 hours, really we could not able to find out the where is the issues and why its taking...

Answers: 1