Q&A

Hello, I tried to follow guide lines in this article to make a connection to an Oracle Database with wallet https://community.denodo.com/kb/en/view/document/Accessing%20Oracle%20Autonomous%20Database%20from%20Denodo Test connection receives this error...

I am getting above error while trying to run a VDPIndexer job dataSource 'Scheduler-Index'. Connection refused to host: <hostname>; nested exception is: java.net.ConnectException: Connection timed out (Connection timed out) Connect to I...

Hello Team, We have a confusion beetwen two concepts , activation of SSL and enabling the HTTPS only on the webcontainer . Would you please give us a little clarification about this two. Thank you in advance. Regards,

Hi, I am getting an error for a view : Error in select view conditions, function substringof not created. I am not able to find the view name from this error. How can I find it?

Hi Team, I am working as a Data engineer and doing the Data Mesh Layer development. I am trying to create a Remote table to optimize the perfomance of the view created. I am not able to create it from Denodo Design Studio as not allowing to add a nam...

Hello, I'm trying to connect to our MariaDB database in Denodo 7.0. As the MariaDB driver is not installed in our Denodo server, I tested using the MySQL5 Database adapter as a substitute, as suggested here: https://community.denodo.com/answers/quest...

Requests in Diagnostic monitoring tool are shown in active and even cancelling these is not making them inactive. Same way, trying to cancel queries from Query Monitor but nothing is happening. Please suggest.

Hello Denodo Community, I am creating a view on top of baseview which has username as one of the columns. When I add a filter on username column, it is showing as reserved word. How do I get around it?

Hi I have timestamps defined as decimals which I'm trying to convert to a date/time format to do a DaysBetween calculation --select getdaysbetween(to_date(date as decimal), to_date( '26-11-2021')) date as decimal = '20220225140000600' when I try t...

Hi, how can i run an update statement? I have views and then views built on top of those views, but i also need to run an update statement. How can i do that, does it need to be in a stored procedure? I am hoping that there is a way to run updates etc ...