Latest Activity

code

changing values and formats after saving denodo results to excel

Hi , I m trying to save the results from denodo to a csv or excel file . The problem is after saving the results to excel the format of certain values is changing . Like for example date in denodo results is of the format yyyy-mm-dd but when we save th...

code

How to get token with server configuration Oauth2 introspection

With server configuration Oauth2 introspection, I tried to setup a REST service with Oauth2, but it doesn't work. Can someone help me to setup a REST service using Server introspection From the documentation I read => At runtime, the Denodo serve...

code

denodo web studio page not found

i use denodo express for training yesterday after doing my labs when i try to launch the denodo design sudio from denodo platform control center its not opening the messge is "page not found 404 The page may not longer exist, or you may have typed the ...

code

Run 2 Core Licence on 4 Core Server

Hello, we have a 2 Core Licence, running on a 2 Core Server. We realized, that the Server is at its limit, when there is aditional load to the Denodo service. For example, when we scan vor Viruses, sometimes Denodo Services get shut down due to high l...

code

ssl certs installation

Hi, We enabled SSL certs but still not able to login Dendo URL. Getting error as " 10.84.152.55 took too long to respond " Can we connect on MS teams , coz production server was down for long back. Request to Please help on this. Regards, Bhaskar ...

SSL
code

Error While Saving Derived View "Error saving view: Syntax error: Exception parsing query near 'WITH'" in Denodo DEN80EDU12D Course with Denodo Express

Hi, i am attending DEN80EDU12D Connecting and Combining Data with Denodo - On-demand course. The lecturer asks to create a base view with parameters in the third topic of this course, Basic Derived Views (section Creating a SELECTION View: View Param...

code

Redirection of Data Read for UNION View

Would appreciate if someone can provide an insight for this problem statement We have a requirement to expose the data to user through Realtime (Hitting ODS for Current Day) and Historical (Hitting Netezza for Day - 1). Both of these dataset are expos...

code

how to parse out substring from a file-based data source

I have a data source that is based on a csv file. This file has a text column that can be pretty long and containg values that are structured as (AC12345) RANDOM TEXT Of VARYING LENGTH. The length of the string betwen the poarentheses are also varying,...

code

Programmatic IN Operator

I am trying to pass in a set of selection criteria for an IN operator but I can't seem to find any way for Denodo to accept it. Example: User enters A,B,C into a text box, and I would like to have that become SELECT * FROM <view> WHERE <column...

code

base view renamed but view name not updated in joined view?

Hi, i had a base view with name bv_test1 that i renamed to bv_LabBuildingFloorSpaceOrganizationAllocation , and this base view was used in creating the joined view . But in joined view i can see the previous name only. How can i rename it there? Please...