Q&A

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

Solution Manager: connection error checking the version of the Denodo server
answered 23-02-2022 07:47:34 -0500

Hello Team, I have an issue when trying to create a new revision in Denodo Solution Manager. After selecting which server I want to connect to, I receive an error that states "connection error checking the version of the Denodo server" that pops up. I...

Answers: 5

Solution Manager

Connecting to databases across network
answered 23-02-2022 07:28:33 -0500

I have 2 different networks with each of it’s own VPN is used. I have a SQL SERVER on one N/W and another N/W has Redshift database. I need to see both databases data same time. Is it possible? Thanks!

Answers: 1

Issue connecting to Salesforce
answered 23-02-2022 06:22:02 -0500

Hello, I am having issues connecting to Veeva Salesforce. Performed the follwing tasks Created admin account in Salesforce Created a connected App in Salesforce Created a Data source connection ( File-> Data Source-> Salesforce) Selec...

Answers: 3

Denodo 8.0 Salesforce

Limitations
answered 23-02-2022 02:16:57 -0500

In the known Limitations, I see there items. “matching_rows” invalidation does not work. Only adding increments or full refresh (“all_rows”). Is this limitation still applicable in the latest version of Denodo. Please let us know as we are looking at...

Answers: 1
Related to: Configuring Databricks as MPP and Cache

Multiple Aggregate fields in a selection view
answered 22-02-2022 23:47:08 -0500

Hello Denodo Developers, is it possible to create multiple agrregate field in one selection view? say for example, I want to see count of cases denied, case processed and total cases by state. The filters for the denied, processed need to be passed int...

Answers: 1

VQL Shell count() discrepancy
answered 22-02-2022 08:45:20 -0500

Hi Team, We are getting less count from VDP VQL Shell than actual count. Example: VDP Admit tool: select count(*) from myview; count 300; if we execute the view retrieve all rows, count is 1000.

Answers: 1

Denodo express- access from different machines
answered 22-02-2022 08:07:31 -0500

Hi, I have installed Denodo express 8.0 on Windows VM. Now I want to access it from a different machine, is it possible? If yes, how?

Answers: 1

Order to start/stop denodo services
answered 22-02-2022 06:04:24 -0500

Hi, What is the best order to start/stop denodo services for Denodo 7.0?

Answers: 2

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