Home / Q&A / All Questions

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.

Filtering between Current_Date and Current_Date - x days
answered 24-08-2018 10:49:12 -0400

I'm looking to filter a query by dates. The date (my_dt) within the table I'm pulling from is in the format yyyyMMdd but as type numeric and length of 8. So, what I'm trying to do is filter where my_dt is between a date that is x days ago from today an...

Answers: 1

Date Conversion Date

Identifying problematic data sources
answered 24-08-2018 05:31:58 -0400

Hi Team, Denodo 5.5 Is there any way to identify if any JDBC datasource has connection issues. Like - login fail, account locked, TLS/SSL issues etc. Instead of running each datasource and identifying which could have problem. Any web service or an...

Answers: 1

Data Source

Timestamp Millisecond issue
answered 24-08-2018 04:42:56 -0400

In my source date is ‘Fri Jun 16 04:05:55.25896 IST 2017’, while using formatdate getting ‘Fri Jun 16 04:05:55.258 IST 2017’ this date. I have missed the milliseconds after 3rd digits. How can i retrive all digits?

Answers: 1

ODBC connection PC to Denodo Azure Server fails. Why Denodo is on ip 127.0.0.1?
answered 24-08-2018 04:03:34 -0400

I have installed Azure VM. It has own static public IP and private IP. Denodo seems to automatically set its own IP as 127.0.0.1. Now likely because of this I cannot create ODBC access from PC to Denodo VM? Look like traffic cannot be routed from publ...

Answers: 1

Interpolation variable - Passing value from another base view
answered 24-08-2018 02:57:02 -0400

I have first base view with interpolation variables. I would like to pass values for them from second base view. To achieve this, I have created a derived view joining first and second base views. it is working fine until there is a null value in one o...

Answers: 1

Interpolation Variables

ODBC connection fails when using IP. Why?
answered 23-08-2018 14:34:21 -0400

I have Denodo Server on Azure with 100.100.100.100(static ip). Port 9996 is open in the Network Security Group of Azure VM. I have ODBC Data Source inside same Windows Server. I can connect to Denodo server: localhost and Port: 9996 But I failed to ...

Answers: 1

Exclude RMI host and port from VQL export or DESC VQL DATABASE?
answered 23-08-2018 04:31:47 -0400

Hello, how can I exclude RMI host & port from a Denodo VQL export or DESC VQL DATABASE? I tried many combinations (https://community.denodo.com/docs/html/browse/6.0/vdp/vql/describing_catalog_elements/exporting_metadata/exporting_metadata) and it ...

Answers: 1

Scheduler-how to load the result of the job into a table
answered 23-08-2018 03:48:11 -0400

Hi, I am using Denodo express. I used scheduler and trying to run a script which inserts data into a table using select ...Is this viable . Also,I am unable to configure the datasource in exporter section.Can anyone help me with the steps to follow to ...

Answers: 1

ITPilot Wrapper with no results ERROR
answered 23-08-2018 03:21:34 -0400

Hi Team! When my ITPilot wrapper is working in a web page and there is no results to return, the scheduler return execution error. Could I change this result to warning? If I don't have results to get, for example, input search text is wrong, I don't...

Answers: 1

ITPILOT

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