Latest Activity

code

Error when trying access to Oracle Autonomous Database with Wallet

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

code

Scheduler-Index

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

code

SSL and HTTPS

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,

code

Error in select view conditions

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?

code

Scheduling Remote tables

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

code

Unable to connect to MariaDB server

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

code

Requests/Queries are in hung state

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.

code

Reserved words in query of a view

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?

code

Time Functions

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

code

Update statement

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