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.

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

Timestamp Issue
answered 26-12-2019 17:40:21 -0500

Hi, During our PoC with Denodo, we faced some issues related with Timestamp-NTZ and Timestamp-LTZ column types. When we include these fields in Base View (or SQL based Base View) columns are mismatching. Basically, denodo cannot determine the column(s...

Answers: 1

snowflake Base view DENODO timestamp

VDP Server
answered 26-12-2019 14:17:39 -0500

Hi, VDP sever using Express version 7.0 in my system is not starting. Tried installing latest version with latest License file. Need Help

Answers: 1

VDP server VDP start VDP

Denodo Disparat sources join without Cache.
answered 26-12-2019 14:12:56 -0500

Hi Guys, I am new to Denodo. I have installed Express edition on my laptop and running a sample task. I have two disparate data sources (Postgres and MySQL), Postgres has agents table while MySQL has Customer and Orders data. When I execute a join ...

Answers: 3

join Cache

Accessing Denodo docker container from host by docker hostname.
answered 26-12-2019 11:22:44 -0500

Hello, I'm using the Docker container image for development and integration tests. It has been working fine when I leave the hostname for the container as localhost, and I can access it from the host. Now I need other containers to access the Denodo c...

Answers: 2

ODBC binding parameters
answered 23-12-2019 17:54:49 -0500

I'm connecting true the ODBC driver form PHP to the denodo database. I'm using pdo and want to make use of binding parameters in de code. e.q.: This works: $denodo = new DenodoDatabase(); $sql = "SELECT * from orders where ordernumber = 20753852 limi...

Answers: 3

ODBC php Bindparam Windows

Context Clause
answered 23-12-2019 15:08:07 -0500

Hi. I am accessing Denodo views from WinSQL. The view is quite large and times out at 15 minutes per Denodo configured setting. So, I want to use the context clause in my query to extend the timeout duration. Although, I'm unsure whether the value need...

Answers: 1