Latest Activity

code

Export File Using Denodo Design Studio

Hello, is there a way to export results in Denodo Design Studio? PS: don't want to use admin tool(thick client) or Denodo-Data-Catalog. Thanks.

code

Automatic redirection of http calls

Hi, I am trying tu publish via Denodo web services some views that retrieve source data from an external site. To do that I have to get company's firewall open for those calls. Calls to retrieve dta from external site look like: https://<server-nam...

code

Denodo not connecting

I exported the vdb to a local path , and later ran that using VQL shell , after that i tried to stop the execution and it hanged , now when i am trynig to connect denodo it just showing Connecting ........ Please help as it stays on same login page and...

code

Can Denodo 7 ODBC connect to Denodo 8 Server

Hi Team, Can Denodo 7 ODBC connect to Denodo 8 Server? Or it is a must to connect Denodo 8 with Denodo 8 ODBC? I mean both windows and linux. How about JDBC, for both windows and linux. Thanks.

code

Can someone help me how to implement the below logic that uses sub query?

SELECT DISTINCT pd.PROJECT_ID, vuc.ID, vuc.NAME, vuc.PARENT_ID, ( SELECT DISTINCT CASE WHEN vuc.NODE_LEVEL=2 THEN 'null' WHEN vuc.NODE_LEVEL=3 THEN vuc.NAME WHEN vuc.NODE_LEVEL=4 THEN (select mo.name from unit_code mo where mo.id= vuc.PARENT_ID) END FR...

code

Base view Milli Seconds Issue

I have created base view with the data type as 'ENDDATE' :'java.sql.Timestamp' (OPT) (sourcetyperadix='10', sourcetypename='TIMESTAMP(6)', sourcetypeid='93', sourcetypedecimals='6', sourcetypesize='11') SORTABLE. In my source date having milli seconds ...

code

Denodo time issue

Hi ALL, i am facing one issue , in one of the postgres table , i have data in datetime , when i am creating Base view and accesing data , the date is showing as '1970-01-01 12:11:11.000' but the date present in soure is '2020-01-01 10:11:00' Any help...

code

Installation of Denedo platform on Local laptop

HI Denedo SME, I need help in installing Denedo platform on on premise / Local computer . (windows 64 bit ) machine. 1) I have laptop with windows64 bit , and 8 GB ram . 2) What are the Denedo tools / platform are required to installed on local com...

code

Incorrect script generated by DESC for i18

-- doubledecimalseparator should be '.' instead of '' DESC VQL MAP i18n us_pst Generated with Denodo Platform 8.0. DROP MAP i18n IF EXISTS us_pst CASCADE; CREATE MAP i18n us_pst ( 'country' = 'US' 'datepattern' = 'MMM d, yyyy h:mm:ss a' 'datesubtype...

Related to: Number of decimal places using i18n map

code

How to read field value from an array using VQL without flattening it.

Hi, I want to write a VQL to get any field value from an array without flattening it. How i can do it? I know how to get a field value from register. example for register: SELECT (REGISTER_NAME).FIELD_NAME from VIEW_NAME If there is a way get field ...