Q&A

Denodo Client 5.5 & 6.0
answered 08-04-2019 12:07:39 -0400

Hi, Can i have 2 client versions on same server, we have Denodo 5.5 version install on citrix server other team use it to connect to denodo servers. Can i install Denodo 6.0 client on same machine? if yes what are thing to keep into conciderations? Ple...

Answers: 1

denodo client

Ms-Access database connection for Lab - call_tracking
answered 08-04-2019 08:52:21 -0400

I am trying to connect to a MS ACCESS DB. I followed the instructions in the posts: https://community.denodo.com/answers/question/details?questionId=9060g0000000A0OAAU&title=Ms-Access+database+connection https://community.denodo.com/answers/questio...

Answers: 1

DESC VQL VIEW require Write Permission
answered 08-04-2019 08:43:08 -0400

May I know why "DESC VQL VIEW" require write permission

Answers: 1

Permissions

Retrieve Cache Mode for a VIEW using JDBC
answered 08-04-2019 06:16:37 -0400

I am tring to retrieve "Cache Mode for a VIEW" (OFF, FULL, PARTIAL), But I didnt find a way to fetch it. I used "DESC VQL VIEW <viewName>", but it require write permission for the view. Please advice me to fetch "Cache Mode associated with a VIEW"

Answers: 2

JDBC

Starting Denodo express 7.0 issue
answered 08-04-2019 01:53:30 -0400

I am following following instructions to Start Denodo Express on linux Once the installation process is complete Denodo Express will be available in the destination folder that you selected during the install. You have now two options for starting Den...

Answers: 1

Connection refused on Impala connection with JDBC, kerberos
answered 07-04-2019 23:34:39 -0400

We have Cloudera5.12.2 and we’d like to connect to Impala(impala-2.9.0+cdh5.12.2+0) with JDBC. We use kerberos and we checked that we can kinit with the user we intend to use. We just DL the latest denodo express. Java is version8. We have DL Clouder...

Answers: 6

Kerberos JDBC impala

Split Comma separated string to rows
answered 05-04-2019 14:32:48 -0400

Hi I am trying to split a comma separated string to multiple rows. I am not able to find an easy method to do it using the available functions. Essentially I have a field called tracking number in the datawarehouse. It has multiple tracking numbers se...

Answers: 4

Denodo MPP Configuration guidelines (engine and memory)
answered 05-04-2019 10:40:34 -0400

In the Denodo MPP guidelines https://community.denodo.com/kb/view/document/MPP%20Query%20Acceleration:%20Sizing%20guidelines?category=Performance+%26+Optimization it is stated that for Impala the recommendation is to use 16 nodes with each 32GB memory....

Answers: 3

Still Unable to establish connection
answered 05-04-2019 05:59:25 -0400

I am using Denodo 7 and have followed these instructions and get the following error when I try to test the connection (and, yes, we do use integrated authentication for connecting to our SQL Server databases): Unable to establish connection: This dri...

Answers: 3
Related to: Accessing MS SQL Server using Windows Authentication

Scheduler Handler Section
answered 05-04-2019 01:01:38 -0400

Hi Team, Thanks for the response! In denodo 7.0 there is no Aracne section still there is Move-file repository in handler section. How I can use this handler section(move-file repository) for moving extracted file from scheduler jobs to different loc...

Answers: 1

file movement Scheduler Section