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.

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

Need to run a select statement
answered 30-12-2019 20:57:26 -0500

hi, I am new to denodo and I am in need to run the below query and export results using denodo. I have imported the db views as base views in denodo, but in order to achive the below which involves multiple tables, sub queries, where condition and in...

Answers: 1

Wrong Answer in Denodo 7.0 Developer Introduction Certification
answered 28-12-2019 11:14:09 -0500

Hi, While giving the test for denodo 7.0 developer introduction module i came across some question where i think my answer option is correct but the portal says incorrect. if my observation is correct then i think you need to correct that in certifi...

Answers: 2

Certification

Salesforce connection
answered 26-12-2019 20:03:28 -0500

I'm not able to create a salesforce connection? I'm getting the below error. error=invalid_client_id&error_description=client%20identifier%20invalid can any one share the connection deatails what need to enter in each filed or with sample data? I...

Answers: 1