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.

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

Control upstream failure
answered 23-12-2019 02:39:51 -0500

Hi, We have some denodo jobs pulling from 22PM to a path in a linux server. Some files are expected to be loaded by the upstream from 20-21PM in the path. If the files are missing, we want the denodo jobs to keep waiting and do not execute. How can...

Answers: 1

Different Hashes for same values hash()
answered 20-12-2019 08:53:17 -0500

Can anyone please help me understand how hash() function generates different results for same string input? Tables are different but the source is same, i.e. Postgres DB. because if this is the case, then join won't work on string columns, and it ...

Answers: 1

join hash