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.

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

Pass-through security for SQL Server data sources
answered 18-12-2019 17:13:58 -0500

Currently we are using LDAP and Active Directory to allow users to authenticate to data sources in Denodo. We would like the capability to ignore this and use pass-through authentication, based on SQL Server permissions. In other words, if a user has W...

Answers: 1

SQL Server Active Directory Denodo_SQL_Server pass-through

Connecting to Denodo Via Trifacta
answered 18-12-2019 04:58:26 -0500

Hi, We want to create a source connection in Trifacta so that it can read from Denodo. Can there be a generic jdbc connection created for the same or is there any standard process to get that setup. Any inputs will be helpful.

Answers: 1