Latest Activity

code

Denodo RESTFul WS

how To generate the HTML Representation of the Denodo RESTFul WS ?

code

Error in connecting to Denodo from Databricks

Hi Team, I am trying to connect to Denodo server from Azure Databricks using spark read api for jdbc like: url = "jdbc:vdb://%s:%s/%s" % (server, port, vdb) remote_table = (spark.read .format("jdbc") .option("driver", driver) .option("url", url) .opti...

code

What is "Time zone for published web services"

In Denodo 7, for the attribute Server Configuration Default I18n Time zone for published web services What does this setting represent? We tried changing from CST to GMT, there is no difference in the output in date fields for RestAPIs.

code

How to Connect to OBIEE from Denodo

Hello Denodo Geeks, I am a newbie to Denodo. I would like to connect to OBIEE Server from Denodo. Any inputs will be appreciated. I did find Denodo tags that assist in connecting to Denodo from OBBIE,but I am trying to find the opposite way. Thank yo...

code

XML WITH DENODO

Hi, I have an XML field in my view and I have different problems to manipulate it in Denodo. First onne, I want to use the function xmlquery to get a specific list of element in my XML. for example, I have this xml : <shop> <products> <...

code

Analytic Functions at the Denodo engine level

My team has been running into quite a bit of issues with analytic functions when joining across data sources. We have experimented and worked with data movement to resolve some of these issues. However, reporting packages (like Looker) do not have the ...

code

Developing VQL Stored Procedures

Hi, Despite the fact that I have an "Enterprise plus" bundle, I can't create VQL stored procedures in denodo design. I don't have the option "File > New… > Stored procedure > VQL stored procedure" and if I type "CREATE OR REPLACE VQL PROCEDUR...

code

JobStartTime Scheduler

HI, When I add the @jobstarttime to the name of an output file in a scheduler-job, the output is'nt as expected. OutputFile: @{jobName}@{jobID}@{jobStartTime,outputDateFormat: YYYYMMDDhhmmss}.csv Results in: pro00050_controle_dubbele_records_1302_202...

code

rand() - function

Hello, In denodo 7 we have used rand() function to generate unique id in one of the VDB. It generates unique number for each row. In denodo 8 the same function is generating single unique number for all the rows. Issue : When we dig further, it is gene...

code

How to setup webservice to return an image

I was thinking there was a way to configure or call a Denodo web service such that if the only column returned was a blob (that contains and image) that the image would be return - essentially utilizing Denodo as a simple image server. However, I could...