Q&A

ODBC Connection to EXCEL 16
answered 08-04-2019 08:24:53 -0400

I am having problem in which passwords are being required when refreshing existing data. If incorect information is provided the source will no longer work? I also notice the connection in 16 is different from 13? Please advise on the correct way to br...

Answers: 1

EXCEL ODBC Driver

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

Can you assign a role in Denodo Data Catalog at the Category or folder level
answered 04-04-2019 08:53:47 -0400

We have 1 database but many Categories and Folders and Sub-folders with their own hierarchies. Can we assign users and roles at the Category and/or folder level. Example We want Data Steward 1 to have access to 3 out of 5 Categories. Within one of t...

Answers: 1

Roles Users

How to import column descriptions from MS SQL Server data sources?
answered 04-04-2019 08:34:26 -0400

Similar to the following article about Oracle: https://community.denodo.com/kb/view/document/How%20to%20import%20column%20descriptions%20from%20Oracle%20data%20sources?category=Data+Sources How does it work for MS SQL server to get the descriptions/c...

Answers: 3