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.

Unable to connection with Box
answered 03-01-2020 17:54:25 -0500

I am trying to access csv file(delimeted) as a data source that is stored in box but when i am trying to test connection using box credential and url it gives me error like "Unable to establish connection"

Answers: 1

SSH custom wrapper - Fail a job if shell script failed
answered 03-01-2020 15:50:51 -0500

Hi, I am using the custom wrapper. I created a base view, and when I use some incorrect parameter, I am calling to a "dummy command" in the script. It returns a "127" code, which is correct. It is a failure in the script. The issue is that if I use ...

Answers: 1

ssh custom wrapper SSH cutom wrapper

denodo installation backup
answered 02-01-2020 13:02:12 -0500

Hi Team, Does Denodo provides any way to keep backup of Denodo installation ? If some scripted way is to be set up, what would be the most important folders to be backed up ? Thanks.

Answers: 5

Denodo backup

Schema name Prefix to base view
answered 02-01-2020 06:58:50 -0500

On creating base view, I have to prefix them with schema name only. When I use checkbox option its attaching catalog name as well which I don't want. Checkbox says schema and/or catalog name. I am using SQL Server data source.

Answers: 1

An error was found: java.lang.OutOfMemoryError: Java heap space
answered 02-01-2020 00:52:34 -0500

I am getting An error was found: java.lang.OutOfMemoryError: Java heap space on using export with option Include Jar Error Screenshot

Answers: 1

Export

denodo function, that can return the column data type
answered 01-01-2020 23:24:06 -0500

Dose denodo has a function, which can return the data type of a column, for example, an oracle table ACCOUNT, and column NM_L2_ID, I want to know the datatype of ACCOUNT.NM_L2_ID is varchar2 or not, do we have function in denodo that will return the da...

Answers: 1

return column data type

Data Movement
answered 31-12-2019 21:04:39 -0500

Hi, what is the difference between data movement to source vs data movement to view ? I found that my execution time reduced in case of data movement to view. Is it situational or is it always more performance efficient compared to data movement to ...

Answers: 1

Data Movement

how can I call a custom function created in Oracle DB from denodo
answered 31-12-2019 15:57:53 -0500

Hi , i have created a Pl/SQL function in underlying oracle database which set the context based on passed input user parameter. i want to call this function from denodo VQL. i imported this function in denodo by creating base view on it and then trie...

Answers: 1

Function Custom Functions

Connect to aws source
answered 31-12-2019 14:35:30 -0500

Hello, How do I connect to Impala that is on AWS? For example, is this correct? Database adapter : Impala 2.3 Driver class path : '<DENODO_HOME>\lib-external\jdbc-drivers\impala-2.3\ImpalaJDBC41.jar' database URI : jdbc:impala://xyz.<aws regio...

Answers: 1
Related to: How to connect to Cloudera Impala from the Denodo Platform

denodo impala aws

Association query
answered 30-12-2019 21:13:28 -0500

Hi All, I had stuck with a case that when i hit the associations rest service to get the details, am getting only table names in response but not the mapping details between those tables.

Answers: 1