Q&A

I have denodo platform 8.0 running on EC2 installed using cloudformation template as per the installation guide by Denodo. I am trying to create a custom stored proc which has to read a license file (locally saved inside /opt/denodo/denodo-platform8.0/...

I tried the following and i still dont see the trailing zeros for decimal data... Generally, in Virtual DataPort “decimal“ type, precision, and scale of the decimal type is obtained from JDBC data sources. The Virtual DataPort Administration Tool wil...

Hi team, we are using denodo 8.0 and heres the issue: Source and target field are decimal. In SQL database source its numeric (19,8) and in denodo its decimal. When quering the view heres the data descrepncy : | SQL | Denodo 204481.43592593 | 204481.4...

HI Denodo SME, Do we have multi-cloud integration capability in Denodo ? Scenario : Integrating AWS Redshift data with Azure Synpse (analytic service) or something thing similar where customer wants to integrates data from two cloud provider , i...

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.

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...

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...

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.

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...

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 ...