Q&A

You must sign in to ask a question. If you do not have an account, you can register here

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

Connecting to Azure Blob Storage : OAuth credential error
answered 19-12-2019 17:52:05 -0500

Hi, I have followed the instruction here in: https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Azure%20Blob%20Storage%20from%20Denodo?category=Data+Sources After performing prerequisites in the Azure Portal, I'm trying to connect...

Answers: 1
Related to: How to connect to Azure Blob Storage from Denodo

oauth azure

Denodo Load Tests with Jmeter
answered 19-12-2019 13:35:52 -0500

Hi. I've been trying to do Load Tests with Jmeter version 5.1.1 but I have issues with heap memory. I've updated my java from 32 bits to 64 bits and downloaded the latest JDK. also I've edited this part of the jmeter file: : "${HEAP:="-Xms1g -Xmx1g...

Answers: 1

Jmeter

Denodo Data Virtualization job in San Diego, CA
asked 19-12-2019 12:20:17 -0500

Title: Denodo Data Virtualization Duration: 6+ Months (High Possibility of extension) Location: San Diego, CA Job Overview:• Primary tasks will be to upgrade Data Virtualization (Denodo ) software and update current self-service tools using Python &amp...

Answers: 0

Certification 7.0
answered 19-12-2019 06:05:39 -0500

Hi, I am planning to do a denodo certification for 7.0 version. Can you please tell me how many times i can attempt the certification test if i did not succeed the first time ? Also is there any extra money i have to pay for the second attempt. Tha...

Answers: 1

Certification