Latest Activity

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

code

Keep Alive setting in ODBC connection string

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

code

Connecting VDP from entity framework sample application

Just follow up question to my previuos query (https://community.denodo.com/answers/question/details?questionId=90670000000XclGAAS&title=Entityframework+connecting+to+VDP+ms+sql). As suggested,I tried connecting entity framework application to denod...

code

Void Plan

I am using express version on my local. When I try to execute any views or even select current_date function, I am getting error with "Void Plan".