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.

Need to Delete GCP Trial
answered 18-05-2020 00:46:34 -0400

Hello On 13 May 2020, I launched two diffrent trials: Azure & GCP. I need your help to delete only GCP. Thank you.

Answers: 1

gcp free-trial

Scheduler email-exported-files handler does not send email when there is an error
answered 15-05-2020 14:49:54 -0400

We are using a scheduled job to execute source_changes() to notify via email when any base view(s) no longer match their underlying data source. It works great when there are no errors, such as connectivity issues on the data source of any base views b...

Answers: 2

#Scheduler

Parameterised query Problem with IN clause when passing Array of String
answered 15-05-2020 09:30:58 -0400

Hello, I am stuck at one point while working on Denodo REST Web Service. Actually, i am creating view through SQL query. In my SQL query there is IN condition in where clause and the array of string values are used in IN condition. The values i am pas...

Answers: 1

array of string Paramaterised Query In Clause

How to track a user who post to a web service
answered 15-05-2020 07:41:48 -0400

Hi Team, After publishing a view to a web service, if a user post some data to the view, is that possible to track? Like username (Who posts to the view and session id) by adding extra columns to the view? This is our new requirement from our clinet s...

Answers: 1

Rest Webservices

Active connections staying opened
answered 15-05-2020 01:05:04 -0400

I have been observing in my monitoring logs that VDPActiveConn are high and constantly growing. You would expect a connection to be opened, used and closed. Yet in my logs they are staying oepned. I checked via JConsole the connections and 140 were ope...

Answers: 1

ODBC JDBC

JSON source representation
answered 14-05-2020 15:02:18 -0400

Hi, I would liket to import currency rates (https://api.exchangeratesapi.io/latest?base=USD) into Denodo in the form of one table with 2 columns, -Currency -Rate In fact Denodo generates a column for each currency. Thank you for helping, José

Answers: 6

json source

On which level should i place my associations
answered 13-05-2020 17:46:42 -0400

Hello, On which layer would you advice to place the associations? Lets say i have 4 levels: connectivity layer (only connections + base views) Integration layer (simple combinations of base views) Business Entities layer Presentation layer...

Answers: 3
Related to: Associations in Denodo

associations Association

cannot login to vtp
answered 13-05-2020 04:56:55 -0400

error message 27326191 [Server status checker] ERROR 2020-05-13T06:54:16.418 com.denodo.platformlauncher.programmanager.HTTPServerConnector [] - Http error 40427326199 [Server status checker] ERROR 2020-05-13T06:54:16.426 com.denodo.platformlauncher.pr...

Answers: 1

Update large number of Base Views Column Descriptions from another base view
answered 13-05-2020 03:43:25 -0400

Version 7.0, I have 7 systems and other 100 tables that are in Base Views. I want to update column descriptions from a Data Dictionary that is in another base view and I also have the Dictionary in a Excel file. Please tell me the steps, or point me to...

Answers: 3

data dictionary Base View descrptions descriptions

Creating a Multidimentional Datasource | SQL Server analysis Services
answered 13-05-2020 02:16:57 -0400

Hello, We have created a Multidimentional Datasource of SQL Server analysis Services. I have followed the Denodo article - https://community.denodo.com/kb/view/document/SSAS%20as%20data%20source?category=Data+Sources (have also followed all the Previ...

Answers: 5

Multidimensional Data Source Denodo_SQL_Server DataSource