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

How to enable JDBC logging?
answered 21-02-2022 06:34:25 -0500

According to Enabling JDBC Logging, logging can be enabled e. g. using loggerLevel=FINE&loggerFile=c:/vdpjdbc.log. However, this results in: java.sql.SQLException: Invalid parameter: loggerLevel at com.denodo.vdb.jdbcdriver.VDBJDBCDriver.conn...

Answers: 1

How to write this If/Then function?
answered 21-02-2022 06:31:08 -0500

hello, I'm trying to write a field expression. here's are the assumptions. The data has an id, a date1, and a date2 I want the login to look like this: Max(if(id = NULL, NULL, date1),date2) So, what the max of two dates, but use the first date only ...

Answers: 5

Unable to establish JDBC connection in Denodo with Snowflake
answered 21-02-2022 04:30:22 -0500

Hi . I am trying to establish JDBC connection with Snowflake. In the username and password field I am entering my Snowflake Username & password. When I enter the username and password I am getting a message which says: " Unable to connect to the da...

Answers: 3

Gather Statistics for views built on top of external APIs
answered 21-02-2022 01:34:07 -0500

Hi team, Is there any recommendation on when to collect the statistics? I am building views on external APIs so is it recommended to collect stats on those views? Thanks!

Answers: 3

denodo view name maximum length
answered 21-02-2022 01:17:57 -0500

I can not find the maximum limit for denodo view name anywhare. We want maximum charecters denodo supports for view naming for denodo 7.0 Appreciate your help.

Answers: 1

Denodo 7.0 create view view name

Source Refresh not working on web Virtual DataPort
answered 18-02-2022 07:25:35 -0500

Hi, I have some columns that didn't change in my source, but they weren't in my base view because I didn't need them before. But now I need so I want to update my baseview and add that columns. A coleague of mine has the virtual dataport application an...

Answers: 1

Denodo 8.0 Source refresh

Bit datatype transforms to boolean in denodo base views
answered 18-02-2022 07:18:24 -0500

I have one scenario where one of the fields from the source(MSSQL) is a bit datatype while creating a base view in denodo it gets transformed into boolean datatype. Users want to see the results in 0/1 instead of true/false. Even end user application...

Answers: 1

Denodo 7.0 datatype

Best way to export all catalog permissions to a report?
answered 18-02-2022 06:30:32 -0500

Hello. What would be the best way to automatically export all users and roles catalog permissions to be used in audit reporting without the need for sysadmin priviliges? We would prefer if reportdevelopers did not have acces to admin-accounts.

Answers: 2

catalog_permissions useraccess

Schedule a remote table refresh
answered 17-02-2022 08:10:22 -0500

The remote table is created in a jdbc source system and the base view is created in Denodo. But how do I schedule a job to refresh this Remote table

Answers: 1

Remote Tables

Performance Issue
answered 17-02-2022 08:06:21 -0500

We need help here as in what could we be the ways to further optimize as it is taking forever to run. There are two branches on a high level/ Left branch - Union of 6 regions data with required customizations/joins happening for each branch (data - to...

Answers: 1