Latest Activity

code

Fetch or top statement

Hi, i wanted to use the top(10) statememt but it's not supported by denodo? So i tried the fetch statemement. I want to use this within a View but it's not supported it seems. How can i make a view return only the top 1 row of my dataset? Thanks.

code

how to change localhost to hostname or IP on webservices

We have denodo 8.0 on windows environment. When we deploy the webservices, it points to localhost. I could see the option available for changing from localhost to hostname or IP under control center -> Configure - > JVM Options -> RMIhost ht...

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?