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.

How to Connect to Denodo from R/RStudio?
answered 22-08-2018 18:59:04 -0400

Hello , How to connect to Denodo from Rstudio and access the views created in Denodo? Can you please describe steps by step procedure.

Answers: 1

Scheduler | Mail | Handler Section: number of exported documents is more (or equals) than XX
answered 22-08-2018 14:09:34 -0400

Hi Denodo Team, In the Scheduler \ Mail \ Handler Section, there is an option to send an email when the number of exported tuples is greater (or equals) than the configured threshold. Is there a way to bypass the (or equals) criteria? I only want to s...

Answers: 1

Scheduler

Date Format Transformation Pass Through Query in SAS
answered 22-08-2018 12:01:56 -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: 3

Date Conversion TO_DATE TO_DATE function Date

Start navigation with url parameters
answered 22-08-2018 02:27:25 -0400

Hi! I am trying to start a wrapper navigation with a dynamic url and I can't find how to insert the parameters into the inial url. My idea is something like this: http://myurl?param1=@param1&param2=@param2 and setting param1 and param2 dynamically....

Answers: 2

Wrapper ITPILOT URL

Version of the export script that could work standalone (outside of full VDP platform)
answered 21-08-2018 16:37:34 -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: 1

Date Formatting
answered 21-08-2018 14:22:36 -0400

Hello, Here is my issue. I am working in Alteryx, pulling a table from Denodo. I'm looking to convert some odd date values to the equivalent format of Current_Date(). Like 2018-07-31 00:00:00. The date values I'm looking to convert are like such. 9101...

Answers: 4

Date Conversion Date

Denodo VDP Start Issue
answered 21-08-2018 14:21:58 -0400

Hi Team, All of a sudden when we were trying to bring up the vdp services we see the below entries, which never showed up earlier. Error Recursive call to appender FIleout Vdp services showed up fine, but want to know what is this Error about which ...

Answers: 1

Add users in Denodo 6.0 through Web service, Logging mechanism to store user activity, Pass user name and pwd in API request URL
answered 21-08-2018 12:32:55 -0400

Is there any API or Web service in Denodo to add Users and their roles. Is there any logging mechanism, where it stores Users activity like which User is accessing which API. How to pass username and password when security is enabled in Denodo...

Answers: 1

Create User API Security

Import SAS dataset
answered 21-08-2018 11:49:50 -0400

We need help in importing a SAS Dataset, I have read of custom java wrappers, please point us the right resources

Answers: 3

Denodo 7

ITPilot case function doesn't work fine
answered 21-08-2018 07:15:43 -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: 2

ITPILOT CASE