Latest Activity

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

code

calculating date -1

How do I achieve the functionality to calculate a date -1 to show a day prior in denodo?

code

How to connect to running DQVM from locally running VDP Administration Tool? ( ie what is the server address)?

Hello Im looking to get going on Lab Create a JDBC data source and import tables graphically - DEN80EDU12D01LAB01 the first lab in the Connection to databases course. I've setup my Denodo Quickstart VM (DQVM) and its running on 192.168.100.3 and I ha...

code

Using WEBCONTAINER_ELEMENT_STATUS to get webservices statuses

I am using WEBCONTAINER_ELEMENT_STATUS() to retrieve information on the webservices showing the "deployed" status. Is this deployed=true enough to know if the webservice is accessible? Thank You. EA

code

Reconciliation Mechanism in Denodo

Hi Team, We have a use case wherein the Business expects the data to be reconciled on a weekly basis, if the reconciliation is successful, data between source and denodo matches then the data should be refreshed to the final view, if not then the final...