Latest Activity

code

Power BI Direct Query to SQL dn through Denodo

Hey , I am new to denodo. I have a powerbi file in direct query mode . it uses odbc connection to denedo serving layer which is connected to sql dB. when end user interact with powerbi, it will generate sql queries and pass that to underlying source in...

code

Unable to create jdbc data source in denodo design studio

Hi Team, Denodo installation is done in aws,am trying to create JDBC data source in denodo design studio in local machine ,am using mysql database as a source ,i have added mysql connector version 8 driver (.jar) in denodo home(denodo/lib/extensions/j...

code

Metadata repository

Can i have one metadata repository for 2 vdp server . we have Dev environment with 2 vdp servers on it. will i face any performance issue in this case.

code

Case Statement

case when id=1 then y else z end what if i have 3 attribute like "Null" I have a 3 values a b c while i am writing CASE statement i can do up to 2 values what if i have 3 option . case when id=1 then a else b end How i am suppose to get 3rd value .

code

VARCHAR(65536)

Few columns in denodo take VARCHAR(65536) as column size even though the size present as VARCHAR(200) OR VARCHAR(20) etc in db. Why do we see the change in column size in denodo and what is the reason for this? In unified views

code

How can I get java to set the exit code in my shell when a SQL statement run via jisql throws an exception in Denodo?

I am running a command line like this from a Bamboo job in a Windows cmd shell and would like to have the Bamboo fail the deployment if a SQL error occurs in JiSQL however it seems I am unable to get JiSQL to bubble the error out to java.exe or get jav...

code

Error during code deployment using Solution manager

Hello team, I am trying to deploy code in solution manager,I have created two environments one named development and another testing,I am trying to deploy code from development environment to testing environment. I have created revision in development...

code

jdbc connection to vdp through eclipse

Hi, to my previous question, as per your answer "jdbc:vdb://localhost:9999/admin\" admin admin" this is what is in sample code - jdbc client Instead of localhost i have used the server name showed by vdp at the time of logging in. and my username and...

code

Not able to connect to denodo via eclipse using jdbc driver

Hi, I am trying to connect to Denodo- vdp through eclipse using the jdbc driver. It is showing authentication error, username or password is incorrect. Can i get any help in this regard. I am using Denodo 8 and jdk is 11. Thanks in Advance, Jyothsna

code

Denodo offset in a WITH clause

Hi Denodo Teams, I'm tryng to do some operations on a view in denodo. Getting a view, I should compute some operations only on a portion of view data. In other words, in Oracle what I do is something like this: WITH sample AS ( SELECT * view_name OFFS...