Q&A

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

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.

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

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

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

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

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

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

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

I'm connecting to denodo from Azure Data Factory with ODBC, but I'm having trouble when the query takes more than 5 minutes. Apparently due to lack of activity the connection is shut down. I was able to make it work applying the keep alive setting wit...